Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

display total from subreport

Status
Not open for further replies.

mfenn

IS-IT--Management
Sep 6, 2008
22
US
Hello,
Im using CR 8.5 with ODBC connection to tables.

I need to pull a total from the subreport into the footer of the main report. The subreport will display the correct amount when run by itself but displays 0.00 in the main report.

I have tried just putting the subreport in the main report but it doesn't display anything(blank). I am also trying a shared variable, which is displaying 0.00 instead of the actual amount.

In sub report I did a running total of bils.amt and created the shared varriable, which is in GF1 of sub:

whileprintingrecords;
shared numbervar bilsamt := {#RTotal0}

I placed the shared variable in GF1 of the main report to display the total from sub.

whileprintingrecords;
shared numbervar bilsamt;

The variable alwasy displays 0.00 on the subreport

Any help would be appreciated.
Thanks
 
HI,
Figured this out myself. Seems I supressed the running total (not the shared variable) in the subreport which for some reason made the variable not display in the main report.

I moved the running total and variable to the details on subreport and unsupressed. Now the variable is displaying in the main report.

Thanks anyway.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top