Solved

# Passing values from subreport to main report in Crystal Reports 10

Posted on 2008-06-23
4,082 Views
I have two subreports in a main report.  One subreport lists and calculate the total billings by Job for a certain time period.  The other subreport lists and calculates the charges by Job Phase and then by Job by the same time period.  I need to pass the calcuated variables (total billings) and (total charges) by Job to the main report so that I can do a profit/loss calculation.  I've attached the report for your viewing- please change extension back to .rpt.  Thanks!!  Any help is always appreciated...
JobCost.txt
0
Question by:stephaniem712
[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
• 4
• 3

LVL 13

Expert Comment

ID: 21847914
0

Author Comment

ID: 21848053
I read that article.  But, this is a little more complicated.  I need to do a calculation by Job.  So from the subreport, I need to basically pass a "subtotal" by Job for the Billings subreport and the Charges subreport.  On the main report, I need to do a calculation using these two figures to calculate a profit/loss by job.  I'm stuck...
0

LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 21848415
Use separate variables for each report.

CHange you formula in the main report header to something like this

WhilePrintingRecords;
Shared NumberVar BillingTotal := 0;
Shared NumberVar ChargeTotal := 0;

In the billing subreport use the BillingTotal variable
In the Charge subreport use the ChargeTotal variable

Add a formula to the group footer to do the calculations
WhilePrintingRecords;
Shared NumberVar BillingTotal;
Shared NumberVar ChargeTotal;

Calculations

mlmcc
0

Author Comment

ID: 21849879
I put

WhilePrintingRecords;
Shared CurrencyVar BillingTotal;
Shared CurrencyVar ChargeTotal;
(BILLINGTOTAL-CHARGETOTAL);

in the group footer.  I'm doing something wrong.  All I get is the Billing Amount instead of the Billing Amount less the Charge Amount....  I'm drawing a blank...

Thanks!
0

LVL 100

Expert Comment

ID: 21850110
Did you change the subreport formulas and the formula in the report header?

mlmcc
0

Author Comment

ID: 21850272
yes
0

LVL 100

Expert Comment

ID: 21850337
Can you attach the new report?

mlmcc
0

Author Comment

ID: 21850352
My error.  I put chargetotal instead of chargestotal...  left off the s.  Thanks for your help!  It looks like it's working now...
0

## Featured Post

Question has a verified solution.

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

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…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Simple Linear Regression
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
###### Suggested Courses
Course of the Month7 days, 8 hours left to enroll