?
Solved

crystal reports with c#2010

Posted on 2014-01-08
4
Medium Priority
?
274 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

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…
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 …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month12 days, 6 hours left to enroll

752 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