duration/grouping by duration
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1385
Printed Date: 29 Apr 2024 at 12:27pm
Topic: duration/grouping by duration
Posted By: nmercure
Subject: duration/grouping by duration
Date Posted: 26 Sep 2007 at 8:49am
|
I have a report that I want to group by duration (number of days). So, say my report is based off of a trouble ticket which consists of 3 assignments that could be resolved at any time in any order. I want to find the duration between when the call was taken and when the assignment with the latest date and time was solved.
Then I want to group by number of days. Help, I'm pulling my hair out.
 |
Replies:
Posted By: Brandtrock
Date Posted: 26 Sep 2007 at 12:14pm
|
Create a formula field that takes the date and time of the assignment with the latest date and time and subtracts the date and time the call was taken. This formula field then becomes your basis for grouping your data. Regards, ------------- Brandtrock |