SQL Server Performance Forum – Threads Archive
page numbers
The report I want to render needs a total pages only for the group it is currently showing, such thatinvoices go out to 3 customers customer one’s invoice is 1 page
customer two’s invoice is 3 pages
customer three’s invoice is 6 pages if i am looking at the page with the first invoice, the pages will appear as
"page 1 of 10" when i need it to say "page 1 of 1"
if i am looking at the page with the second invoice, the pages will appear as
"page 2 of 10" when i need it to say "page 1 of 3"
if i am looking at the page with the third invoice, the pages will appear as
"page 5 of 10" when i need it to say "page 1 of 6" is there a way to correct this problem? Joe Janka
]]>