"Brian W via SQLMonster.com" <forum@SQLMonster.com> wrote in message
news:b2988c48db8c497da3a28d65832f968e@SQLMonster.com...
> Hello All,
>
> I am building a report for printing billing invoices.
>
> In my data source, there are two tables:
>
> 1. A header table - 1 record for each invoice (address, payer info, etc..)
> 2. A detail table - multiple records per invoice (detailed charge info)
>
> The user will select multiple invoices to be printed at a time.
>
> The format of an individual invoice is pretty simple:
>
> A. Some stuff from the header table at the TOP and BOTTOM of the page
(just some basic info like names and adresses, etc..)
> B. A MIDDLE section that shows the charge details (probably with a table)
>
> In my brief time with Reporting Services, I can see how to set all this up
and have each invoice show up on a separate page.
>
> ------
>
> NOW for the hard part. The MIDDLE section (that shows the charge details)

>
> Is it possible to limit.. say the details of a table control.. to only 20
lines per page? Or is there any other solution?
>
>
> Thanks.
>
> --
> Message posted via http://www.sqlmonster.com

"Wayne Snyder" wrote:

> Create a group in the table and for the grouping condition use something
> like
>
> =System.Math.Ceiling(RowNumber(Nothing)/20)
>
> Then set to page break on each group, and include headers/footers..
>
> This will break EVERY 20 rows, so where I have Nothing you might need to put
> the scope of the table.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Brian W via SQLMonster.com" <forum@SQLMonster.com> wrote in message
> news:b2988c48db8c497da3a28d65832f968e@SQLMonster.com...
> > Hello All,
> >
> > I am building a report for printing billing invoices.
> >
> > In my data source, there are two tables:
> >
> > 1. A header table - 1 record for each invoice (address, payer info, etc..)
> > 2. A detail table - multiple records per invoice (detailed charge info)
> >
> > The user will select multiple invoices to be printed at a time.
> >
> > The format of an individual invoice is pretty simple:
> >
> > A. Some stuff from the header table at the TOP and BOTTOM of the page
> (just some basic info like names and adresses, etc..)
> > B. A MIDDLE section that shows the charge details (probably with a table)
> >
> > In my brief time with Reporting Services, I can see how to set all this up
> and have each invoice show up on a separate page.
> >
> > ------
> >
> > NOW for the hard part. The MIDDLE section (that shows the charge details)
> can only hold about 20 line items.. Any more than that and the invoice needs
> to print the rest on a 2nd page (preferably with the same TOP and BOTTOM
> parts as the first page)
> >
> > Is it possible to limit.. say the details of a table control.. to only 20
> lines per page? Or is there any other solution?
> >
> >
> > Thanks.
> >
> > --
> > Message posted via http://www.sqlmonster.com
>
>