Have a report that is scheduled to run the first of each month and got the following error:

missing operand after 'Date" operator

There is not a date selection criteria, there are two groups, one by item and then by order date which is displayed as the month-year.

Are you using any date variables in your RRD? Is the message actually showing a single quote and a double quote like you have above?

Typo on the initial post, it's 'Date', do not have any date variables in the RRD.

Could you copy the contents of the RRD (from Notepad) and paste them here? Be sure to X out any server/db names, logins, or passwords.

Here you, appreciate the time and help:

;WORKSPACE_MODE=FALSE
EmailReport[Web Orders Shipped Report]=C:\Users\p21service\Documents\Month_End_Reports\Web_Orders_Shipped.rpt?DiscardSavedData=True&recip=email@jis.com&subj=Web Orders Shipped Report&CC=&BCC=email@jis.com&msg=&export=Microsoft Excel 97-2000 (XLS)&smtpserver=###.##.#.##&smtpport=25&smtpauthentication=False&smtpuser=&smtppassword=&fromaddress=email@jis.com&attachmentfilename=Web_Orders_Shipped.xls&requestreadreceipt=False&pdfPassword=&EmailSupressIfNoRecords=True&UseSSL=False&

Well that's about as simple as it gets. We can definitely rule out the RRD, so it must be the report itself. Does the report run in the Crystal Designer? Are there any formulas that include a reference to the date?

Report runs fine within Crystal, but you might be on to something, the first group is by invoice date, so maybe that's causing the issue.

I didn't see any Parameters being passed by the RRD... does the report include any Parameters?

Is there perhaps something date-related in the record- or group-selection formula?

I had asked Matt to follow up with you as well.

What version of Crystal are you using to test? I wonder if there is a syntax issue between Crystal versions (Logicity is based off of the latest). Do you know if you're using any UDF (user defined functions) in the report?

Could it be possible you have a parameter in the report but are not using it? If you are in the solution builder and click specified for the parameters do you see any show up for date? Thanks!

Matt