I am migrating reports from Seagate Info to CE10 and am having problems with sales reports not refreshing. I ran a daily shipment report last week (10/3) and then exported it in a .rpt format. I then uploaded the file to CE. The select criteria is sales_date=currentdate - 1, but when run the report, it gives me data from 10/3. If I change the select criteria to 10/7 via the filter in CE, the report returns the correct data, but if I change it again to Currentdate-1, I get 10/3 data again. The same thing happens running the report using CR10. What's going on here??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reports Not Refreshing
- Thread starter mwake
- Start date
eyeswideclosed
MIS
couple things to check, make sure save data with report is not on, also to force a refresh each time, pass a parameter with a constantly changing value like the time or a random number.
- Thread starter
- #3
eyeswideclosed
MIS
yeah, what i do then is make a parameter on the report and suppress it so it doesn't show, and pass it the time or something else that always changes, that will force a refresh. in the old days they had rf=1 which forced a refresh but no longer.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question