Crystal Reports "Times" (DataTime,CurrentTime,etc) 1

[pmmgpgp]

We are currently CR XI release 2

I'm having difficulty identifying two times. I need to display within my reports when the was Submitted and when it Completed. It seemed that I could look at CurrentTime twice, but CurrentTime seems to be grabbed from the OS at the start and provides this "one time" no matter when one looks at it.

DataTime is described as "time that the report was last refreshed". But I find this quite vague (I have some stored Procedures that take more that 15 minutes to complete). Is this when the query started, when the 1st record was returned or when the last record was returned ?

I can get my ending information using EvaluateAfter(TotalPageCount); and using a command object to get server's date and time. Perhaps I could do something simular for the start but I can't find the correct "event" to key on.

I hope that I've made some sense. Any guidance or pointers will be appreciated.

Dave


Dave, Your Friend in Beautiful Roanoke, VA

 

[lbass]

I think that datadate picks up the datetime when you click on refresh. Print datetime will reflect the current datetime, and will change whenever you save the report.

After running a report, if the saved icon shows that the report has already been saved, sometimes you have to resize a field or do something to force the report to require a save to get the print datetime after running. Otherwise, if the report shows that data has not been saved and you save the report just as it finishes running, you can subtract datatime from print time to get the elapsed time. I haven't tried your evaluateafter method--but I'm not sure the print time will ever automatically print after running a report without first saving.

-LB