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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport

Status
Not open for further replies.

brishanny

MIS
Oct 3, 2003
17
US
I have a main report with a subreport. In Group Header1 of the main report can I place a value from the subreport?

I am using Visual Cut and want to dynamcially put the Margin percent in the subject line. My subreport contains all the order detail information with the Margin percent.

Thanks
 
In Crystal 8.5 you can return data from a subreport, check the keywords 'shared variables' for details. But the data is only available in sections below the section that runs the subreport.

If it has to run for a group and be in the group header, have one very thin group-heder subsection to run the subreport, and then show the output in the next group-heder subsection

Madawc Williams
East Anglia, Great Britain
 
RIght click the Group Header 1 and select insert section below.

Place the subreport in the 1st GH, and then you can use a formula within to pass values to teh main report, as in:

subreport formula:
whileprintingrecords;
shared numbervar SomeValue := {sum(table.field})

Main report GHB formula:

whileprintingrecords;
shared numbervar SomeValue;
{MainReptable.field} / SomeValue

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top