Prev: Strange join created by report model 2005
Next: Force subreport size
From: Kiroa on 12 Apr 2010 10:51
Hello,

I am trying to include total # of pages per group on a SSRS report.

For example, if the SRS reports has parameters customer ID and document
date, it will print all invoices for that customer(s) for the date.

For each page of the form, we would like to include page # + total # of
pages, such as 1/3, 2/3, 3/3, 1/2, 2/2, 1/4, 2/4, 3/4 and so forth.

I can get the page # with some coding, but I am unable to find a way to get
the total # of pages per group. I've tried in both SQL 2005 and 2008.

The only way I found is to “preprocess the report in a silent run”, but
this requires a separate custom app, and probably won't work for my case.

Is there any way to accomplish this?

Thank you in advance.

From: Kiwi_smith on 12 Apr 2010 19:56
I have been searching and Googling high and low to get group page totals, and
eventually gave up because none of the solutions worked for me. In the end,
I was able to get what I wanted by counting rows in my SQL stored procedure,
and resetting the row count for each group.
This gave me the total number of rows for each group; if my group row total
was 35, for example, and I knew I could fit 10 rows per page, then my page
count would be 4.


"Kiroa" wrote:

> Hello,
>
> I am trying to include total # of pages per group on a SSRS report.
>
> For example, if the SRS reports has parameters customer ID and document
> date, it will print all invoices for that customer(s) for the date.
>
> For each page of the form, we would like to include page # + total # of
> pages, such as 1/3, 2/3, 3/3, 1/2, 2/2, 1/4, 2/4, 3/4 and so forth.
>
> I can get the page # with some coding, but I am unable to find a way to get
> the total # of pages per group. I've tried in both SQL 2005 and 2008.
>
> The only way I found is to “preprocess the report in a silent run”, but
> this requires a separate custom app, and probably won't work for my case.
>
> Is there any way to accomplish this?
>
> Thank you in advance.
>
 | 
Pages: 1
Prev: Strange join created by report model 2005
Next: Force subreport size