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

Shared variable: how to use them ?

Status
Not open for further replies.

redeemasp

Programmer
Jun 1, 2004
63
GB
Hi there

I've a job number and a description that I want to pass from a sub report to my main report:

How do I do this? any tutorial around?

thanks
 
In your sub report create a formula to pass teh values to the variables i.e.

//@SubRptData
WhilePrintingRecords;

Shared StringVar JobNum := {My Job Number}; ''change to Numbervar if a number is required here
Shared StringVar Desription := {My Description}

Then in the main report create formulas to display the data from the sub report i.e.

//@JobNo
WhilePrintingRecords;

Shared StringVar JobNum;

//@Description
WhilePrintingRecords;

Shared StringVar Description;

These can then be placed on the main report to diplay the sub report data, bearing in mind they must placed in a section after the section containing the sub report.

HTH

Gary Parker
MIS Data Analyst
Manchester, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top