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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datetime parameters that keep changing

Status
Not open for further replies.

kwirky

MIS
Apr 22, 2010
85
AU
Hi,
How do I create a date time parameter that allows the data to refresh from when the report was last run to the current time?
I am creating a sales report that will be migrated to Crystal Server so that it can be emailed automatically twice a day to managers. They want the data to show sales from when the last report was generated to the current time. The report will be scheduled to run at 12pm (lunchtime) and then again at 5.30pm, so I would need the data from 5.30pm to 12 noon, and then 12 noon to 5.30pm.
I am guessing that I could use dynamic parameters, but I do not know how to use them.
We are using CR XI.
Thanks.
 
Hi again,
I can do currentdatetime for the end date, but how do I get a similar formula which shows when the report was last run?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top