?
Solved

Add the Total from two Subreports

Posted on 2009-02-23
5
Medium Priority
?
230 Views
Last Modified: 2012-05-06
I have a report that in one section has two seperate subreports that have their own total.
eg
Job #        Sub1:total labour       Sub2:total parts

I am trying to get (total labour + total parts) to show at the end of this section.

Is this possible?
0
Comment
Question by:robd2007
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:Spykair
ID: 23718756
Yes.
You can create a formula column where you add these 2 fields together.

Spykair
0
 

Author Comment

by:robd2007
ID: 23718802
When I go to create a new formula in the main report, the field names are not listed to be used.

Do i have to do anything to make it so i can see then in the formula editor?
0
 

Author Comment

by:robd2007
ID: 23718873
When i say field names from the subreports, i should have described as the result from a shared variable i set up in the subreports, to try to get it out in the main report.
0
 
LVL 10

Accepted Solution

by:
Spykair earned 1500 total points
ID: 23718912
You'll have to declare the shared variable before the sub report. Then you can use it in the main report.

Spykair
0
 
LVL 10

Expert Comment

by:Spykair
ID: 23730412
Glad I could help

Spykair
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

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 …
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

839 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