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!

Store and Fetch Variables to create a Report Index

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
The main report, Capital_Detail_Final_WIndex, is the project detail report and is grouped by Pgcode (Program Code) and sorted by Pgcode, Institution and Project Identifier.&nbsp;&nbsp;I am trying to store the page number for each Institution on the subreport using the following StoreNumberVar which is placed on the detail section:<br>WhilePrintingRecords;<br>StoreNumberVar({statuschng.Inst},PageNumber);<br><br>I then have placed the fetch variable on the Main Report in the detail section.<br><br>WhilePrintingRecords;<br>FetchNumberVar ({statuschng.Inst});<br>&nbsp;<br>I have placed this variable on the detail line beside the Institution name.&nbsp;&nbsp;I want the page number that the institution is printed on in the detail report to print beside the institution in the table of contents.&nbsp;&nbsp;Unfortunately, it prints the page number of the main report.<br><br>Is there a way to store the result of the StoreNumberVar so that it prints the page number for each institution.&nbsp;&nbsp;i.e. there are usually three institutions per page, so instition 1, 2 and 3 would be on page 1; institution 4, 5 and 6 would be on page 2; institution 7, 8 and 9 would be on page 3; etc.&nbsp;&nbsp;I need to fetch the page 1 for the first three institutions, etc. for the table of contents.<br><br>Any help with creating a table of contents would be greatly appreciated.&nbsp;&nbsp;I can't seem to find any technical help regarding this and yet it seems like it should be a very common report.&nbsp;&nbsp;Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top