How to View & Print a report with diffrent captions

[Guest]

I wnat to know about how to print a report in multiple pages i.e. I have
created a report and I want to view one reocrd in this report but its display
me 3 pages, on the first page the label captioned "original", on the second
page "duplicate" and on the third page "triplicate"?

 

[Marshall Barton]

I wnat to know about how to print a report in multiple pages i.e. I have
created a report and I want to view one reocrd in this report but its display
me 3 pages, on the first page the label captioned "original", on the second
page "duplicate" and on the third page "triplicate"?

Create a table with one Text field and one Integer field.
Populate it with three records:
1 original
2 duplicate
3 triplicate

Now, change the report's record source query to include this
new table **without** any join line between the two tables.
Drag the two fields down to the query's field list.

Finally, bind a text box to the text field as the report's
"label" and set the report to sort on the integer field.