Page Numbering

rbuser

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

nicocizik

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

rbuser

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