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 - pass a field to main report detail

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
I am using CR10

I have a paramtised sub report to select a company code and bring up some fields such as address which I have placed in GH1 of main report and supressed as dont want to see it. I want to bring 2 of the fields (at least to start with)into 3 detail areas d1,d2 and d3. I need to drop the fields into a text object. How do I do this please?
 
You will need to use shared variables.

In subreport
@Eval

whileprintingrecords;

Shared stringvar addr1:={Address1Field};
Shared stringvar addr2:={Address2Field};

In main report below where SR is executed, the following formula can be used in details or where ever.

@addr1

whileprintingrecords;

Shared stringvar addr1;

Repeat for second variable

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top