verticle lines on invoice report

[supmktg]

I've created an invoice report that has a group header as it's first visible section, followed by the detail section and then the page footer section which contains the total amount due.

I'm trying to add verticle lines connecting the group header to the page footer, but I can't figure out how to do it. If I add verticle lines to the detail section, they are only equal in height to the # of detail line items.

Can anyone suggest a way of doing this?.... or a way of making the space between the header and footer look less silly when there are just a few line items on the invoice?


Thanks,

Supmktg

 

[Nouba]

The problem is described in Microsoft knowledge base Article - 170838 ACC: How to Create a Line That Can Shrink and Grow in a Report

 

[supmktg]

Norbert,

Thanks for your reply. I'm not sure if I'm not following the MS article, or if you misunderstood my problem.

What I want to do is put a fixed verticle line 6 inches in height on each side, connecting the group header to the page footer. I want the line's height to remain 6 inches no matter how many detail records there are. I do not want the detail section to shrink or grow, but remain the same 6 inch height whether there is one detail record or 20 detail records on each invoice within the 6 inches surrounded by these lines.

There's got to be a way to do this, it's a common invoice layout that I'm trying to duplicate.

Thanks

Supmktg

 

[barbarossaii]

what about adding an extra field, which is never null & has 20 records per page ? then you can get the lines by the detail section of the displayed 20 records per page, even if there is no 'real' data on the page (except the data in the extra field; in the rpt set the properties to invisible => the content will not be printed or shown).


HTH,
Barbarossa II

 

[supmktg]

Thanks Barbarossa II,

I created a new report based on a new table that I created for this test with 20 records in it. I made the field invisible and the verticle line still appeared as you expected.

Now, I can't figure out how to combine this method into my existing report so each page will have 20 invisible records and show however many 'real' records there are on the page.

Can you explain further?

Supmktg