Solved

crystal reports with c#2010

Posted on 2014-01-08
4
268 Views
Last Modified: 2014-02-11
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
0
Comment
Question by:cycledude
  • 2
  • 2
4 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 39767775
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
 

Author Comment

by:cycledude
ID: 39767792
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39767798
you can have as many sub-report as you want
0
 

Author Closing Comment

by:cycledude
ID: 39850108
thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question