I have used older versions of Crystal Reports Distributor (CRD). I really liked it... It some funky problems but from what I understand it was completely re-written and that fixed a lot of the "special features" (it didn't like being used through remote desktop).
CRD does appear to have more features and flexibility than CR Server 11. With CR 11 we recently ran into an issue where I don't want a blank report to be email out if there are no matches and I didn't find an easy way to configure this. We are looking into a work around that will put a file in a directory and once that file is created (the event) it will kick off the report. We may end up created a Windows scheduled task and a script to do an SQL query and create a file if any records are returned, which would then trigger the report to be run and sent (guess I could do a runmacro.exe call too). I really don't like having to do this external process just to suppress a blank report. CRexporter is also a free tool that I have used. http://www.rainforestnet.com/crexport-download.htm We just used a scheduled task that ran a batch file. I haven't used it for mass reporting but know of some places that do use it for large amount of month end reports. Unfortunately using these external processes (CR 11 and CRexporter) to run report forces us to hard code credentials in the batch files (or we could use escalations which would help some). Jason On Wed, Feb 6, 2008 at 3:26 PM, patrick zandi <[EMAIL PROTECTED]> wrote: > ** > Consider the following as well in your CR Decisions.. > > http://www.recrystallize.com/ > > Also the following: > http://www.sharewareconnection.com/crystal-reports-distributor.htm > > and > > http://www.christiansteven.com/main/crystal/crystal-destinations.htm?type=GoogleAdWordsSearch&gclid=CKXZwvnasJECFRGCGgodP27rfQ > > > Never tested never tried.. but look promising.. > > On Feb 6, 2008 4:44 PM, Hennigan, Sandra H CTR OSD-CIO < > [EMAIL PROTECTED]> wrote: > > > UNCLASSIFIED > > > > This was first sent out in September 2007 but didn't generate many > > responses. > > > > Unlike Howard Richter, the original sender, we are using: > > Windows Server 2003 > > MS SQL 2000 > > ASR 6.3 patch 21 > > Help Desk 5.5 > > > > I have Crystal Reports version 8.5, 9.0 and 10 at my disposal. > > > > Managers here have a daily Crystal Report report that runs from a link - > > works great, managers like. BUT > > > > Instead of having to use the link, managers would like the report > > emailed > > to them as they are not always in office with Remedy access. > > > > They want this process automated, with the Crystal Report report saved > > as > > a PDF attached to an email, sent by 0500 daily, Monday thru Friday. > > > > > > Any ideas on how I can generate and attach the report? > > > > Any assistance would be greatly appreciated. > > > > Sandra Hennigan > > > > Remedy Administrator > > Office # 703-602-2525 x251 > > > > Apparently, there is nothing that cannot happen today. Mark Twain > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter > > Sent: Thursday, September 13, 2007 5:14 PM > > To: [email protected] > > Subject: Automating reports > > > > ** > > > > Has anyone seen a product or know of a way to automate reports from > > Remedy > > (we are using ServiceDesk 7). > > > > I would even look at creating an escalation, but trying to use out of > > box. > > > > Thanks to all, > > -- > > Howard Richter > > > > Remedy ServiceDesk Manager > > CedarCrestone Managed Services Center > > [EMAIL PROTECTED] > > > > __20060125_______________________This posting was submitted with HTML in > > it___ > > > > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > > -- > Patrick Zandi > > Dev Technology Group --> www.devtechnology.com > Exceeding your Expectations ! __Platinum Sponsor: www.rmsportal.comARSlist: > "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
