Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Grouping and calculation of time Post Reply Post New Topic
Author Message
Adagio
Newbie
Newbie
Avatar

Joined: 17 May 2007
Online Status: Offline
Posts: 11
Quote Adagio Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.