[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

crystal reports with c#2010

Posted on 2014-01-08
4
Medium Priority
?
275 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 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