Joined: 17 May 2007
Online Status: Offline
Posts: 11
Topic: Grouping and calculation of time Posted: 09 Jun 2008 at 2:10am
I have a couple of questions about grouping, hoping someone here knows the answers (spend a long time searching for the answers without luck)
In my .Net application I have some classes, that I use to fill the reports
1.
I have a group based on one field, but I want the groups to be sorted on another field
The class for this report has (among other things) the following fields: Id (string) EndLocation (string) Truck (string) Location (string)
The report should group on the Id field, but sort the groups on the EndLocation field. If two groups have the same EndLocation it should sort those two based on the Truck field
2.
The class for this report has (among other things) the following fields: Name (string) TaskName (string) Time (timespan)
The report has two groups (first the name group, then the taskname group), which is easy to set up. The problem is with showing the time field: Each line in the inner group should show the time and the outer group should also show the full time for each 'name' It seems like Crystal Reports sees the timespan field as a text object, which makes it impossible for it calculate the total time. I could make another field in the class that returns the total number of minutes for each instance of my object, then maybe I could somehow use this number myself to calculate how many days/hours/minutes each taskname and each name took. But I have no idea where to start
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum