Crystal Delivery 8.0.0.1
I'm trying to use this application to send a few reports as scheduled, however I am coming across a few issues. 1st - In some cases, the automated reports just wont send as scheduled. Exporting them manually works fine from what I can tell. when they are not sent, an event is logged in the application log regarding crystalcmd.exe and permissions denied. Unfortunately I cleared my log to attempt to resolve the next issue so I will post if/when it reoccurs. 2nd - I have a report that I cannot export automatically or manually. I receive the following in the application event log: Type: Error Source: .NET Runtime 2.0 Error Event ID: 5000 EventType clr20r3, P1 crystalcmd.exe, P2 7.0.4.6, P3 48fe1204, P4 crystaldecisions.reportappserver.datasetconversion, P5 10.5.3700.0, P6 48b540e6, P7 1f, P8 297, P9 2xa1m4tdhkntb0crpv0cdnqc142qyqk, P10 NIL My initial research indicates that this is an unhanded exception. Recommendation for future versions: Implement additional error handling. I.E. The instance above, or when e-mailing a file check to see if the file is valid rather than assuming its there (This is another error I received). Additionally, the ability to enable/disable tasks or change the order of reports would be great. I would love to make a donation, considering that Crystal Server goes for 2K+ you should make a little extra...but if the application isn't reliable for me I cannot justify it at this time. Also, would you be willing to share the source? I program in VB and may be able to assist if needed Thanks!

Forgot to mention that this application is running on a Windows 2003 server in the event it makes any difference.

Some additional info regarding the 2nd issue in the original post (If I can provide anything else please let me know). This report is using two connection sources: 1st is DatabasenameA, ServerA, UserIDA 2nd is Database name is blank, ServerB, UserIDB I tried to view this report using the built in viewer which prompts me to enter my server credentials, it is here I notice two issues. When prompted for my credentials, the server name is ServerB, the Database is DabasenameA and the login id is UserIDB. When I enter the credentials for either server, the login request is denied. I do not see any login attempts at all on ServerA, and cannot tell on ServerB as this is a Cache Database without login auditing for SQL. Could it be that the Blank Database name in the second connection is causing this issue (If this field is null the Crystal Delivery Application is using the previous value?) Looks like that's the issue, which is only present when more than 1 data source is present as all of my other reports work fine with just one datasource and no database name. I played around with the report config, and populating the spot where a database name would go returned the information I populated in the database name field. Looks like I will have to create a workaround for now (Use Access as a middle man?)...hopefully this issue will be updated in a later version

I've seen posts in the past that Crystal Delivery will not work with Windows Server. I had a similar problem and would up loading on an XP PC and it works fine now.

Well it saddens me to say this since I believe this product has great potential, but due to the reliability and other issues I've encountered I've created my own solution using Winbatch. It may not be perfect but at least it runs as scheduled using Windows Scheduler, and if it doesn't then at least I can debug the code and correct it on my own. If anyone else is interested, I've posted my code below. This will give you a good understanding if you want to create your own code in VBS or etc.... varReportName = "Title of Report Here" varReportTemplate = "D:\Production\Crystal Reports\EBO\Client Reports\%varReportName%.rpt" varReportOutput = "D:\Production\Crystal Reports\EBO\Exported Reports\%varReportName%.pdf" varServer1Name = "Database Name here as specified in your data sources" varServer1Database = "" varServer1UserID = "" varServer1Password = "" varDestinationType = 1 ;Output to Disk ;varExportType = 1 ;Crystal Report ;varExportType = 2 ;Data Interchange ;varExportType = 3 ;Record Style ;varExportType = 5 ;Comma Seperated Values ;varExportType = 6 ;Tab Seperated Values ;varExportType = 7 ;Character Seperated Values ;varExportType = 8 ;Text ;varExportType = 9 ;Tab Seperated Text ;varExportType = 10 ;Paginated Text ;varExportType = 11 ;Lotus 123WKS ;varExportType = 12 ;Lotus 123WK1 ;varExportType = 13 ;Lotus123WK3 ;varExportType = 14 ;Word for Windows ;varExportType = 21 ;Excel 5.0 ;varExportType = 22 ;Excel 5.0 Tabular ;varExportType = 23 ;ODBC ;varExportType = 24 ;HTML32 Standard ;varExportType = 25 ;Explorer32 Extend ;varExportType = 27 ;Excel 7.0 ;varExportType = 28 ;Excel 7.0 Tabular ;varExportType = 29 ;Excel 8.0 ;varExportType = 30 ;Excel 8.0 Tabular varExportType = 31 ;Portable Document Format (PDF) ;varExportType = 32 ;HTML40 ;varExportType = 33 ;Crystal Report 7.0 ;varExportType = 34 ;Report Definition ;varExportType = 35 ;Exact Rich Text ;varExportType = 36 ;XML varMailServerAddress = "" varMailServerPort = "" varMailServerUsername = "" varMailServerPassword = "" now=TimeYmdHms() year = ItemExtract(1,now,":") mod 100 month = ItemExtract(2,now,":") day = ItemExtract(3,now,":") ;Some days and months may only have one digit. ;To make sure they have two digits: If StrLen(year) == 1 then year ="0%year%" If StrLen(month) == 1 then month="0%month%" If StrLen(day) == 1 then day= "0%day%" varMessageFrom = "" varMessageTo = "" varMessageCC = "" varMessageBCC = "" varMessageSubject = "%varReportName% - %month%/%day%/%year%" varMessageBody = StrCat("Hello All,",@LF,"Attached is the %varReportName% report.", @LF, @LF,"Thank you,",@LF,"Information Services") varMessageFlags = "" objCrystalApplication = objectopen("CrystalRuntime.Application") objCrystalApplication.LogOnServer("PDSODBC.DLL",varServer1Name,varServer1Database,varServer1UserID,varServer1Password) ; open the saved report objCrystalReport = objCrystalApplication.OpenReport(varReportTemplate) objCrystalReport.DiscardSavedData() ;Export Report objCrystalExport = objCrystalReport.ExportOptions objCrystalExport.DestinationType = varDestinationType objCrystalExport.FormatType = varExportType objCrystalExport.DiskFileName = varReportOutput Result = objCrystalReport.Export(BOOL:@false) If Result == 0 ;E-mail the file - success Terminate(!AddExtender("WWPST44I.DLL"),"Title Here","Error Message Here") kInit(varMailServerAddress,varMessageFrom,varMailServerUsername,varMailServerPassword,varMailServerPort) kDest(varMessageTo,varMessageCC,varMessageBCC) RC = kSendText(varMessageSubject,varMessageBody,varReportOutput,varMessageFlags) If RC == 0 Then Message("EMAIL Processing","E-EMAIL send failed") Else ;Export not succesful, log or e-mail error details. End If objectclose(objCrystalExport) objectclose(objCrystalReport) objectclose(objCrystalApplication) Please note, if you have more than 1 database/source you will need to add the additional parameters as noted below where X is the current # of the data source (I.E. 2 - whatever). Just insert them below the other values in the code above: varServerXDatabase = "" varServerXUserID = "" varServerXPassword = "" objCrystalApplication.LogOnServer("PDSODBC.DLL",varServerXName,varServerXDatabase,varServerXUserID,varServerXPassword)