crystal reports with c#2010

Hi

I am using the free version of crystal for vs 2010,

I have a report which is taking data from an access database. The report has a sub report, which summarises the data in the main report, which is fine... but the client want something which i am having trouble creating...


the summary shows figures total figures from each of the 5 departments that the report is analysing.

Dept 1
Dept 2
Dept 3
Dept 4
Dept 5


What he would also like to see in the summary is a grouping of figures from 2 of the departments and another with the other 3... so:


 group 1 consists of
dept 1
dept 2

and group 2 consists of
dept 3
dept 4
dept 5




so I have setup some formula fields to do something like this:


if {Command.department_name} = "dept 3"
or {Command.department_name} = "dept 4"
or {Command.department_name} = "dept 5" then
    {#totClockedHours}
else
 0


which appear to work as expected, so I figured that I could create a running sum on this field to produce the total that I need.... computer says no...

so... am I approaching this wrong, is there another way to do it....

Cheers

CD
cycledudeAsked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
Can't you just add a column to your datasource and use that new column to use the plain old grouping functions of CR?
0
 
cycledudeAuthor Commented:
I am already using the grouping facility of CR for each dept..  unless I do another sub report within the main report (can you have more than 1 sub report?)
0
 
Éric MoreauSenior .Net ConsultantCommented:
you can have as many sub-report as you want
0
 
cycledudeAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.