I need to print multi-paged invoices. Therefore I'd like to
reset the page number to 1 whenever the customer changes
(i.e. pagenumbering on group-level). The whole print-job
encompasses hundreds of pages.
How can I do this?This cannot be done in the current release.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Aebi" <maus2001@.bluewin.ch> wrote in message
news:Ompzea5eEHA.2544@.TK2MSFTNGP10.phx.gbl...
> I need to print multi-paged invoices. Therefore I'd like to
> reset the page number to 1 whenever the customer changes
> (i.e. pagenumbering on group-level). The whole print-job
> encompasses hundreds of pages.
> How can I do this?
>
>
Showing posts with label pagenumber. Show all posts
Showing posts with label pagenumber. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
Reset Total Pages
Is there a way to reset TotalPages in a report ? I have successfully reset
PageNumber using:
http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
But would like to know if someone has figured a way to reset TotalPages
using similar code...I would also be interested in a solution to this. I am trying to implement a
customer-facing report that requires this functionality and haven't been able
to figure out the methodolgy for calculating Globals!TotalPages so I could
modify it or code something similiar. Anyone have any clues for me?
PageNumber using:
http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
But would like to know if someone has figured a way to reset TotalPages
using similar code...I would also be interested in a solution to this. I am trying to implement a
customer-facing report that requires this functionality and haven't been able
to figure out the methodolgy for calculating Globals!TotalPages so I could
modify it or code something similiar. Anyone have any clues for me?
Labels:
database,
microsoft,
mysql,
oracle,
pagenumber,
pages,
report,
reset,
server,
sql,
successfully,
total,
totalpages
Friday, March 23, 2012
Reset PageNumber On Group Change
I need to reset the page number when a group changes. The group is controlled
in a list. PageNumber works well for overall numbering, but not inside the
group, furthermore, I cannot access the current pagenumber from inside the
group.
I am using RS 2005.Add this to your report code:
Shared offset as Integer
Public Function GrpPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End if
Return pagenumber - offset
End Function
Then place a text box in the page footer with this expression - assuming you
have the group set with page break at end and have labeled your Group cell.
="Page " & Code.GrpPN(Not(ReportItems!txtGroup.Value Is Nothing),
Globals!PageNumber)
Hope that helps (this was in 2000)
--
Allison
"Rick" wrote:
> I need to reset the page number when a group changes. The group is controlled
> in a list. PageNumber works well for overall numbering, but not inside the
> group, furthermore, I cannot access the current pagenumber from inside the
> group.
> I am using RS 2005.
in a list. PageNumber works well for overall numbering, but not inside the
group, furthermore, I cannot access the current pagenumber from inside the
group.
I am using RS 2005.Add this to your report code:
Shared offset as Integer
Public Function GrpPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End if
Return pagenumber - offset
End Function
Then place a text box in the page footer with this expression - assuming you
have the group set with page break at end and have labeled your Group cell.
="Page " & Code.GrpPN(Not(ReportItems!txtGroup.Value Is Nothing),
Globals!PageNumber)
Hope that helps (this was in 2000)
--
Allison
"Rick" wrote:
> I need to reset the page number when a group changes. The group is controlled
> in a list. PageNumber works well for overall numbering, but not inside the
> group, furthermore, I cannot access the current pagenumber from inside the
> group.
> I am using RS 2005.
Subscribe to:
Posts (Atom)