Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Page Numbering

edited November 2005 in Subreports
I am unable to get page numbering correct using the following, please help

Main Report (Detail Band only)
SubReport1
Header
Detail
Footer
SubReport3 (Detail Band)
SubReport4


Main report has detail band only and contains 2 section subreports1 and 3

Subreport1 has Reset page number checked.

I want the page number to start from 1 every time subreport1 is printed.

Problem is the page number works ok up until subreport3 header and then it
prints as 1.

If I remove the reset page number on subreport1 then pages number
sequentially without resetting as expected.

with reset page checked on SR1
SR1 PAGE 1
SR1 PAGE 2
SR1 PAGE 3
SR1 PAGE 4
SR3 PAGE 1
SR1 PAGE 1
SR1 PAGE 2
SR1 PAGE 3
SR3 PAGE 1

without reset page checked on SR1
SR1 PAGE 1
SR1 PAGE 2
SR1 PAGE 3
SR1 PAGE 4
SR3 PAGE 5
SR1 PAGE 6
SR1 PAGE 7
SR1 PAGE 8
SR3 PAGE 9

what i want to achieve
SR1 PAGE 1
SR1 PAGE 2
SR1 PAGE 3
SR1 PAGE 4
SR3 PAGE 5
SR1 PAGE 1
SR1 PAGE 2
SR1 PAGE 3
SR3 PAGE 4

Comments

  • edited November 2005
    Hi Steve,

    The problem with your design is that once a subreport ends, ReportBuilder
    looses all stored page information. You might be able to store the number
    of the last page printed for Subreport1 then manually place the page number
    of Subreport3 once it prints. Otherwise you may need to try placing both
    subreports inside another section subreport and just keep track of its
    pagination.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2005
    I have tried placing both subreports inside a section subreport with the
    reset page number on/off i still had problems. I also tried placing
    Subreport3 in the summary band of Subreport1.

    Eventually I botched it up using a variable, by storing off the page number
    in subreport1 and then incrementing it within subreport 3 and placing the
    variable on the page in subreport3 instead of the page number.

    Just wondered if there would be a more elegant solution.

    Thanks for looking in to my problem.

    Regards

This discussion has been closed.