Cross Referencing in Reports

[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

 

[Klatuu]

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.

 

[Douglas J. Steele]

While a little ancient, check out http://support.microsoft.com/kb/131588

I would expect the principles to be the same for cross-references.

 

[F1stman]

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.

 

[Nicholas Meyer]

gj

 

[0932]

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