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

Can we pull values from one report to other report?

Status
Not open for further replies.

Lnxvas

Programmer
Oct 15, 2008
15
0
0
US
i have 2 report which are related. i have to pull some values from 1st report and sum those values and put that sumed value in the 2nd report.

is this possiable?

Thanks
 
you can use shared variables to do this.

But,you have to have the other report as subreport for the first report.
 
thanks,

but the problem here is it is not a subreport.. it is a individual report. the relation between these two reports is one of the report is like jounral entry for the other.
 
You would need to set up the first report as a subreport in the report header. In the sub, you would do the necessary calculation and set it up as a shared variable in the report footer. You could then reference that value in the main report or in a second subreport, which must be placed in a section below the one containing the first subreport.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top