SQL Server Performance

page numbers

Discussion in 'SQL Server Reporting Services' started by jastone, Feb 15, 2005.

  1. jastone New Member

    The report I want to render needs a total pages only for the group it is currently showing, such that
    invoices 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

Share This Page