report spanning pages

mysterj1

Registered User.
Local time
Today, 08:28
Joined
Jan 31, 2010
Messages
23
First off, thanks for your time. I'm somewhat savvy to technology - not so much in making db's - but I haven't been able to identify how to get around this issue. I'll do my best to explain it succinctly:

I have a personal db that I use for managing a rather large music database, including the following fields (all text fields):

Group_Name
Album_Name
Year_Released
Genre

The report is grouped by Genre. Sort order is Group_Name, Year_Released, and Album_Name.

Q: if an artist has enough records that it is necessary to span pages in the report, how do I have both the Genre and the artist display at the top of the new page?

Example: The Rolling Stones have so many albums that the records span three pages. How do I go about making the Genre and Group_Name appear at the top of the page for each report page including their data?

Thanks again for your time; it is much appreciated!
 
Are you showing the Page Header?

If so place your Text Box there.

There is some fine tuning that can be done in the Format Tab of the Properties Box.
 
Rain,

Thank you for the reply. I do have the page header showing on each page.

I have been experimenting with some of the properties within the report, but with no success so far.
 
Let me put some other info here.

The report includes data from the following fields:

Group_Name
Album_Name
Year_Released
Genre

The records in the report are grouped by Genre. They are then sorted by a) Group_Name, b) Year_Released, and c) Album_Name. So there are headers for both Genre and Group_Name fields.

What I am trying to do is have the text boxes in both the Genre and Group_Name headers display on the page when there are so many records that they span pages.
 
OK I figured it out, problem was that I needed to set the REPEAT SECTION property for both the header areas (for Genre and Group_Name) to yes. Now if the records go to multiple pages it shows both the Genre and Group_Name on each page.
 

Users who are viewing this thread

Back
Top Bottom