'LastFullMonth' function in Crystal XI 1

[kratz]

After I ran a report (in Crystal 11) utilizing LastFullMonth as the primary selection criterion I observed that it ran fine and produced correct data; then I published and scheduled a it (in InfoView). One time it ran and selected no data and another time it blew up complaining that "{?dateRange}" in an invalid field name.
It appears that InfoView replaced "LastFullMonth" with "{?dateRange}".

If you have observed this phenomenon, do you know of a solution?

 

[synapsevampire]

Post what is in the Report->Selection Formulas->Record

Crystal doesn't change anything by moving it to CRS.

Does the report have a parameter, and if so, why, since you aren't using it.

-k

 

[kratz]

Thank you.
(Due to my ignorance, I'm not certain I infer correctly.)
The record selection formula in Crystal XI reads
{CORRESPONDERLOG.CORRESPONDER_DATE} in LastFullMonth
but in InfoView it reads
{CORRESPONDERLOG.CORRESPONDER_DATE} in {?dateRange}.
So between when the report ran perfectly in Crystal XI and when I looked at it in InfoView "LastFullMonth" was replaced with {?dateRange}.
Do you think maybe the fact that I have parameters which I don't use is the cause of my problem? (I'll try publishing w/o the parameter and see what happens.)

 

[synapsevampire]

I think that you published an old version.

-k

 

[kratz]

Thank you.
Originaly I had published this report to run with a parameter for an initial run of all pre-2007 data. The infoview version apparently retained a marker for the parameter even after I published a version sans parameter to the same report name. I think that marker was retained because I used the "reschedule" option instead of starting over from scratch with the 'schedule" option.
Now the report works fine. So I am grateful to you for walking me through to a solution.