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!

Sub Reports

Status
Not open for further replies.

jveglia

MIS
Mar 26, 2001
13
US
I created a report that passes a sum amount from a sub report to the main report. It works find. The question i have is I am trying not to show the figure from the sub -report on the main report and show it net with another group total. When I suppress the sub report from printing the sum from the subreport is not passed to the main report. Is there a way around this or do i have to show the figure on the main report?

Thanks for your help.
 
There are two separate issues here. If you passed a value to the main report using a shared variable, you do not have to display it on the main report--you could use it directly in a calculation and display that, e.g.:

whileprintingrecords;
shared numbervar amt;
amt/{table.qty}

...where {table.qty} is from the main report.

If you mean you want the subreport not to show, it depends upon your version of CR. If 9.0 or above, you can suppress all sections WITHIN the sub, format the sub to "suppress blank subreport" (format subreport->subreport tab), remove the borders from the sub, and then in the section expert, use "suppress blank section" on the section containing the sub (if you want the section to disappear too).

What you CAN'T do is suppress the subreport object or suppress the section it is in, if you want to pass a shared variable.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top