Can I Overlay Rows in a Table?

I've created a table with two group header rows and a detail row. I would
like the second group header to 'overlap with' the detail row when the
report prints. Is this possible? And if so, how do I go about
accomplishing this?
Thanks!Very good question. I'm curious as to how to do this too. Sorry this
isn't a helpful response, but hopefully others see this thread who can
answer it and know there's an interest.
Cindy wrote:
> I've created a table with two group header rows and a detail row. I would
> like the second group header to 'overlap with' the detail row when the
> report prints. Is this possible? And if so, how do I go about
> accomplishing this?
> Thanks!|||I don't want to hide my detail lines. I want my second group header to
print in the same visual row as my first row of detail.
Below is the best I can do with a textual visualization:
[Group Header #1]
[Group Header #2] Detail
Detail
Detail|||Thanks BYU,
That sounds like an approach. My second group header contains a memo field
with a lot of word-wrapping. My hope was that it would 'overlay' however
many detail lines it wraps out to. I believe with your suggestion I would
get a large space between my first detail row and my second row.
My crude illustration of what I am after:
[Group Header #1]
[Group Header #2 [Detail Row 1]
that could potentially [Detail Row 2]
wrap to multiple lines of [Detail Row 3]
text] [Detail Row 4]
[Detail Row 5]
[Group Header #1]
Your solution as I understand it:
[Group Header #1]
[Group Header #2 [Detail Row 1]
that could potentially
wrap to multiple lines of
text]
[Detail Row 2]
[Detail Row 3]
[Detail Row 4]
[Detail Row 5]
[Group Header #1]

Can I limit 'detail' rows per page?

Is there a way from the report designer, in layout mode, to set a limit
of rows to, let's say 5 per page?
Thanks,
TrintHello, I would like to do the same thing. For example, I would like to create an invoice template and have a header section contain the Billto, Shipto addresses and a footer section contain the remittance section. However, the middle of the 'page' should have a fixed number of records for the detail items on the invoice. If more than the fixed amount of detail records is reached, a second page would be displayed. Any help or insight with this would be helpful. Thanks, Dave
--
Message posted via http://www.sqlmonster.com|||Add a group to your table, set the group expression to
=System.Math.Floor((RowNumber(Nothing)-1)/<# of rows you want to display in
a page>, and turn on page break on the group. The header and footer sections
would be the group header and footer, and you can mark them repeated on new
page.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave C via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c5d891b35fa44feeaef5957179524cdc@.SQLMonster.com...
> Hello, I would like to do the same thing. For example, I would like to
create an invoice template and have a header section contain the Billto,
Shipto addresses and a footer section contain the remittance section.
However, the middle of the 'page' should have a fixed number of records for
the detail items on the invoice. If more than the fixed amount of detail
records is reached, a second page would be displayed. Any help or insight
with this would be helpful. Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com