Cross Referencing in Reports

  • Thread starter Thread starter F1stman
  • Start date Start date
F

F1stman

Hello,

I have two reports which are based largely on the same set of data. The main
difference is one gives detailed financial information for projects while the
other offers a narrative/progress report.

I need to set the narrative report to include a page number reference to the
related record in the financial report.

An example would be:

Project 22 - Narrative
Please refer to financial report of pg ## of CIP3 (financial report)

Many thanks and please let me know if you need clarification!

Adam Kemp
 
Interesting problem. I don't have an exact answer, but here is where I would
do some experimenting.
In the report I want to reference, I would try using a table that would have
the information needed by the other report. I think writing a record with
the needed information using the Print event of the report section where the
data are might work. Then in the Format event of the report section where
you want to retrieve the data, you could read the table and programatically
populate text boxes with that information.

Again, this is only an idea, I have never tried it.
 
Thank you to both who responded. This is what I expected to have to do. I
will grind through it and try to post my method if I get it to function
correctly.
 
F1stman said:
Hello,

I have two reports which are based largely on the same set of data. The main
difference is one gives detailed financial information for projects while the
other offers a narrative/progress report.

I need to set the narrative report to include a page number reference to the
related record in the financial report.

An example would be:

Project 22 - Narrative
Please refer to financial report of pg ## of CIP3 (financial report)

Many thanks and please let me know if you need clarification!

Adam Kemp
Click to expand...
 
Back
Top