Need help on Complex report

L

Leif

I've already left a message or two on this complex report and I appreciate
all the help. However, I've run into another issue.

I have a form like report and has an embedded table. The previous issue was
the breaking of a text field between two pages. This was resolved by placing
each question/answer of the table in its own separate group. That works fine.

The top of the page is to be shown on each page. I do that by placing it in
the page header section. Below the page heading is a section of text that
only needs to be shown once per record. A record may span 2-3 pages
depending on how much text is placed in the answer (each section is set to
can grow).

After this text is the table header, which again should be shown at the top
of each page. I do that by placing the table header in its own section and
marking it as repeat. I also set the record key for the Grouping section.

Everything works fine, except a new record does not generate a page break as
I expected. I can set the table header section to break before section,
however, that causes a problem on the first page of the report.

I possibly could use a break object and turn it off/on based on some
condition in VBA. However, I don't know what condition I could test for in
VBA.

Thanks for your help.
 
E

Evi

Does it work if you use Force New Page - After Section, in the *Group*
footer (ie not the report or page footer)?
Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top