Getting as much on on page as possible.

J

Jarryd

Hi all,

I have a report that displays all comments made about a particular trial
done for a particular customer. The comments are 7 textboxes: one holding a
date and the rest holding 120 characters of text each. So when you run the
report it should look something like this:

Comments: Customer 1 -- REPORT HEADER
------------------------
TRIAL: 1A-BILKO/99 -- PAGE HEADER
------------------------
Date: 12/12/2005 -- ID FIELD HEADER
------------------------
Line 1 -- DETAIL
Line 2
Line 3
Line 4
Line 5
Line 6
------------------------
Date 23/12/2005
------------------------
Line 1
Line 2
Line 3
Line 4
Line 5
Line 6
------------------------
Date 29/12/2005
------------------------
Line 1
Line 2
Line 3
Line 4
Line 5
Line 6
------------------------------
Page 1 of 2
------------------------------

------------------------
TRIAL: 1A-BILKO/99
------------------------
Date 01/01/2006
------------------------
Line 1
Line 2
Line 3
Line 4
Line 5
Line 6
------------------------------
Page 2 of 2
------------------------------

The problem is that it doesn't come out like that. It should fit at least 5
comments on a page. Each comment (detail section) should have a Date (id
header) heading on the same page. So if the comments run on to a new page
the the ID HEADER should start on a new page and the comments should follow
it. So instead of:

------------------------
Date 29/12/2005
------------------------

------------------------------
Page 1 of 2
------------------------------
Line 1
Line 2
------------------------
TRIAL: 1A-BILKO/99
------------------------
Line 3
Line 4
Line 5
Line 6
------------------------------
Page 2 of 2
------------------------------

You should get:
------------------------
TRIAL: 1A-BILKO/99
------------------------
Date 29/12/2005
------------------------
Line 1
Line 2
Line 3
Line 4
Line 5
Line 6
------------------------------
Page 2 of 2
------------------------------

I have messed around with Force New Page and Force New Row on all the
sections I can in a million differenct combinations, but I can't get it to
do what I want. Surely there must be a way to tell it that if the detail
sections runs over the page then start a new page with the page header at
the top, the header for the detail section underneath it, and then all the
details. Lastly, Sorry for making this post appear so long.

TIA,

Jarryd
 
J

Jarryd

Hi,

I forgot to mention that the best I have managed to get it is fit three
comments per page by setting the ID HEADER to force a new row before
section, but if I take that off I can see that it can clearly fit in five.
Does anyone know how to crack thsi nut?

TIA,

Jarryd
 

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