Solved

crystal reports with c#2010

Posted on 2014-01-08
4
271 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 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

707 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