Batch parameter and emailing

Barkley564 · Posted: Fri Oct 26, 2007 11:32 am Post subject: Batch parameter and emailing

First of all - I'll echo everyone else and say what a great program this is. It's been very helpful!

Here is the only issue I'm having, and I need to know if it's something I'm doing wrong.

I created my first report that uses the batch function (only one parameter). The name of the parameter is the email address I want it sent to, so when I export the report it batches through 8 email addresses and sends 8 emails with different attachments for each. When I manually export the report it runs great, but when I set it up on a schedule, it doesn't run.

I have other reports that don't batch, and they run on the schedule just fine. Is there some restriction with using batch as a parameter and having the report on a schedule?

I also took the trouble report and changed it from batch to one of the parameter entries. I then put it on a schedule and it exported / emailed fine, so I know the report is good.

Thanks for your time!

Barkley564 · Posted: Fri Oct 26, 2007 12:04 pm Post subject:

I upgraded to the newest version - and saw the 'process log' section. Here is the error it generates when [batch] is chosen:
10/26/2007 2:00:05 PM
Messasge: Logon failed.
Details: [Database Vendor Code: 18456 ]
Source: Crystal Reports ActiveX Designer
Stack Trace: at CRAXDRT.ReportClass.ReadRecords()
at CrystalDelivery.frmMain.fncCheckAlerts(String ReportSettingsInfo, String strCheckReport, Int32 intRow, Boolean booWeek, Boolean booTime, Boolean booHistory)
Target Site: Void ReadRecords()

kgroff · Site Admin

Sounds like a bug to me. I see about getting a fix soon.

kgroff · Site Admin

When I manually export the report it runs great

Just to clarify, batch for this report does work for you in manual mode but fails in auto mode?

Barkley564 · Posted: Fri Oct 26, 2007 5:07 pm Post subject:

That's correct. If I choose the report in Crystal Delivery and click Export, it exports all 7 times and emails correctly. However, in automatic mode I get the error above.

kgroff · Site Admin

Try version 7.0.6.0 to see if it corrects this problem.

Barkley564 · Posted: Tue Oct 30, 2007 12:47 pm Post subject:

I upgraded to 7.0.6.0 and had the same problem.

I even removed the report and set it back up in case it was dependent on a setting.

kgroff · Site Admin

I create a dummy report that contained a parameter with two email address as values. I used [BATCH] for the parameter value and [PV:2] dynamic text value in the To: field of the email. The report was emailed in both manual and auto mode. This test was done in version 7.0.6.1. See if that makes a difference.

Barkley564 · Posted: Wed Oct 31, 2007 2:32 pm Post subject:

Can you post the new version to the main page for download?

kgroff · Site Admin

7.0.6.2 should be available.

Barkley564 · Posted: Wed Nov 14, 2007 7:52 am Post subject:

Sorry for the delay in updating - the new version worked. Thanks a million!