Hi,
Just would want to ask how can I put in formula the start date and end date of my report based from the database fields (datetime)? Not sure if its OnFirstRecord function?
Basically I'm in charge of doing the reports only. I have no control over the database fields. My report consists of a chart, datetime vs data (raw). The data in the DB values varies each day. It's filled up by another group so there would be no parameters defined in my crystal reports. Just need to "chart" the entire data for each day (need to generate it once a day after office hours).
My reports are now finished, but I would like to add a range in my report header that would consist of the start date and end date in the database, so people who read it will know of the date range for each report.
example: The data in the database varies each day, see sample below.
1st day:
10/01/04 87
10/02/04 76
10/03/04 90
etc.
2nd day:
06/23/04 54
06/24/04 103
06/25/04 99
etc.
and so on...
Thanks in advance.
Regards,
Chris
Just would want to ask how can I put in formula the start date and end date of my report based from the database fields (datetime)? Not sure if its OnFirstRecord function?
Basically I'm in charge of doing the reports only. I have no control over the database fields. My report consists of a chart, datetime vs data (raw). The data in the DB values varies each day. It's filled up by another group so there would be no parameters defined in my crystal reports. Just need to "chart" the entire data for each day (need to generate it once a day after office hours).
My reports are now finished, but I would like to add a range in my report header that would consist of the start date and end date in the database, so people who read it will know of the date range for each report.
example: The data in the database varies each day, see sample below.
1st day:
10/01/04 87
10/02/04 76
10/03/04 90
etc.
2nd day:
06/23/04 54
06/24/04 103
06/25/04 99
etc.
and so on...
Thanks in advance.
Regards,
Chris