scheduled reports showing incorrect data

[eoggb]

This is so puzzling, but I have a report that when scheduled it shows an incorrect sales %. I have checked the parameters, dates everything. I even copied the report to my folder on enterprise and recreated the scheduled report with the same parameters (date)and it shows the correct %. I ran both reports (my folder & where it located on enterprise) from crystal reports and it show the correct % but the momement I schedule it with all the same parameters form it's folder I get the wrong %. This report has nothing from the repository, all data is pulling from the database. Any suggestions.....

 

[MJRBIM]

Is the SCHEDULE using a different Database Login than you are (which may be row-limited)?

Can you put a record count field in the report footer - to confirm that the report is returning the same number of records when SCHEDULED and when run from Crystal Reports?

What happens if you VIEW the report in Enterprise, rather than SCHEDULE?

 

[eoggb]

when i view it on enetrprise it shows the correct %, but onec scheduled with the same param the % is incorrect

 

[synapsevampire]

Try posting technical information.

What version of CE, what the percentage differences are, and what formula/means you used to create this percentage.

-k