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

Time Grouping

Status
Not open for further replies.

rasadmin

MIS
Sep 24, 2001
8
0
0
GB
Hello,

I'm new to both Crystal Reports and this forum......

I have an application log in an Oracle database of Transaction Time (DateTime MM/DD/YY HH:MM:SS), Transaction Name and Execute Time. I need to group the transactions into 10Minute slots for graphing. Is there a function in Crystal to do this? Or does anyone have a formula?

Thanks.
 
I just did this with a crosstab. Under group options select specified options. Then set up grouping options using time ranges. Create a group for each time frame, the options give you the ability to pick ranges. setup each range and then run the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top