Sunday, March 11, 2012

Crystal report Impossible to convert to RS?

I am trying to re-create a report in RS which we currently have in Crystal.
The report does a grouping of data based on client. There should be an
"address" page in-between each of the client's data pages which displays the
client name and address (for an envelope). This page should not have a page
footer. Also, the client's data pages should have a footer with page numbers
but the numbering for the pages should be re-set for each client. For example:
First printed page: CLIENT A Address page (no footer)
Second printed page: CLIENT A Data page (displays "page 1 of 1" in footer)
Third printed page: CLIENT B Address page (no footer)
Fourth printed page: CLIENT B Data page (displays "page 1 of 2" in footer)
Fifth printed page: CLIENT B Data page (displays "page 2 of 2" in footer)
Sixth printed page: CLIENT C Address page (no footer)
Seventh printed page: CLIENT C Data page (displays "page 1 of 1" in footer)
I can do the "address" page by creating a group header at the top of my
table which is the same size as a regular page. The problem for me is:
How do I have a footer displaying the page number only on the data pages?
How do I reset the page numberign for each client (or grouping)?You won't be able to get the "of X" part of the page report, but you can
reset the page number using a little custom code. Basically you define a
static variable for the report and reset it every time the grouping item
changes.
See https://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:973069DA-28B4-40A3-A075-EBC1C3E216D5@.microsoft.com...
>I am trying to re-create a report in RS which we currently have in Crystal.
> The report does a grouping of data based on client. There should be an
> "address" page in-between each of the client's data pages which displays
> the
> client name and address (for an envelope). This page should not have a
> page
> footer. Also, the client's data pages should have a footer with page
> numbers
> but the numbering for the pages should be re-set for each client. For
> example:
> First printed page: CLIENT A Address page (no footer)
> Second printed page: CLIENT A Data page (displays "page 1 of 1" in footer)
> Third printed page: CLIENT B Address page (no footer)
> Fourth printed page: CLIENT B Data page (displays "page 1 of 2" in footer)
> Fifth printed page: CLIENT B Data page (displays "page 2 of 2" in footer)
> Sixth printed page: CLIENT C Address page (no footer)
> Seventh printed page: CLIENT C Data page (displays "page 1 of 1" in
> footer)
> I can do the "address" page by creating a group header at the top of my
> table which is the same size as a regular page. The problem for me is:
> How do I have a footer displaying the page number only on the data pages?
> How do I reset the page numberign for each client (or grouping)?

No comments:

Post a Comment