Solved

Passing values from subreport to main report in Crystal Reports 10

Posted on 2008-06-23
8
4,042 Views
Last Modified: 2013-11-15
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
Comment
Question by:stephaniem712
  • 4
  • 3
8 Comments
 
LVL 13

Expert Comment

by:crgary_tx
ID: 21847914
0
 

Author Comment

by:stephaniem712
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

by:
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

by:stephaniem712
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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 100

Expert Comment

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

mlmcc
0
 

Author Comment

by:stephaniem712
ID: 21850272
yes
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 21850337
Can you attach the new report?

mlmcc
0
 

Author Comment

by:stephaniem712
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

How to increase the row limit in Jasper Server.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

705 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now