WhilePrintingRecords

[Jewel142]

Help!

I am trying to pull a grand total from a subreport into the main report. No matter where I put the formula, I get $0.00

The sub report is for previous benefit deductions with all detail suppressed and only a grand total listed in the report footer. The following formula was created in the sub report and pulls the correct amount in the sub report:

WhilePrintingRecords;
Shared CurrencyVar PensionDedGT := ({#Grand Total})


In the Main Report I created the following formula:

whileprintingrecords; Shared CurrencyVar PensionDedGT

I've put it everywhere on the report, headers, footers, detail sections and I end up with a $0.00 value. Any suggestions? This is my first attempt at linking subreports this way. Any help with be very greately appreciated.

Jewel

 

[briangriffin]

Where is the subreport? If it's not actually displaying anything, try putting it in the report header.

 

[Jewel142]

I've tried to put it in the Group Header#1 but I still don't get anything to diplay other than $0.00

 

[briangriffin]

Describe more about what you're trying to do. Is the subreport linked? It sounds like you want to display the same grand total (from the subreport) into each group header in the main report - right?

 

[lbass]

Make sure that the subreport is not suppressed and that the section in which it is placed is not suppressed. The sub MUST be in a section above the one in which the shared variable is referenced.

-LB

 

[Jewel142]

The subreports are linked by EE number and SSN. What I am trying to do is populate specific fields on the report based on subtotals or grand totals on the various subreports.

The main report populates all the pertinent employee information. One subreport is currently in the Group Header #1 section but has be suppressed. This pulls all the benefit information into the report but I need to extract out defined codes and populate them into their own fields For example:

PreTx Contributions $$$$$
PostTx Contributions $$$$
Interest $$$$

I wanted to share the values between the two reports so that I could use them for summary calculations.

It's actually a benefit statement for each employee so every active employee would have their own page. Unfortunately the data is pulled off both our payroll tables and benefit tables.

Thanks for your help!

 

[briangriffin]

Follow LB's advice and it should work. Here's an article that you'll probably find beneficial:

http://www.cne.com/20090315_passing_shared_variables.php

 

[Jewel142]

That worked thank you! I added it to my group header unsurpressed, miminized it as much as I could and set the font color to white.

I'm going to try that with all my other subreports. Thanks again!!

Jewel

 

[lbass]

If you have a version later than 9.0, you don't have to minimize the size. You can suppress all sections within the subreport, remove the border, and format the sub in the subreport tab to "suppress blank subreport" and format the section containing the subreport to "suppress blank section". What you CAN'T do is suppress the subreport object or the section it is in.

-LB