I have a report setup with the following sections (with descriptions):

Report Header - Title Page

Page Header - Suppressed

Details a - Text heading for 'Details b' (i.e. explaining the data contained)

Details b - Details/Statistics

Because 'Details b' has quite a lot of information, and spans over multiple pages, (in a tabular form) it messes with the formatting and, as such, I have two questions:

1) How do I make 'Details a' and the start of 'Details b' be on the same page? Currently I have a bit of text on one page (with a load of white space) and then the detail starts on the next page.

2) As the information spans across multiple pages (which isn't a problem) I'd like to know if it is possible to repeat the table headers on every page (like you can on Word).

Any help is gratefully received.

Regards,
Dr4ke

1) Instead of using Detail A, use a Group Header and uncheck Keep Details Together.

2) If you are using a Group Header instead of Detail A, go into the Group Expert, select the group and click Options. Click the Options tab and check repeat Group Header On Each Page.

Dealing with subreports is a little different....

1. Right-click on the subreport, Format, and turn off "Keep Together".

2. Make sure that you've turned off "Keep Together" for all of the sections of the subreport.

3. Your column headings from Details A in the main report will NOT ever repeat on subsequent pages. Page headers in the main report don't really work for this either. Instead, since there are no page headers available in subreports, you have to "fake" it. Here's what you would do:

- Delete the column headings from the main report.

- Create a group in the subreport on a field that has only one value throughout the subreport. This can be one of the fields that you use to link the report or it can be a formula that you create in the subreport.

- Make this the outer-most group in the subreport.

- Edit the group and turn on "Repeat Group Header on Every Page".

This will get your column headers on every page.

-Dell

The group headers info is for question 2 in your original post:


Subreports don't have "page" headers or footers, so the only way to get your table headers repeated on multiple pages is to use a group in the subreport and set it to repeat the header on every page.

Since there is no field that only has one value throughout the subreport, you'll have to create a formula for this. You could use something as simple as this:

{@FakeGroup}
1

Make this the outer-most group in the subreport and put your table headers in the group header.

-Dell

I'm working from memory here, without opening Crystal. Try changing the formula from "1" to "CurrentDate" and see if it will let you group on it then.

-Dell