[dba-SQLServer] Counting Pages For Sub Query In SSRS 2005

Francisco Tapia fhtapia at gmail.com
Mon Jun 8 11:15:27 CDT 2009


in SSRS 2K we used to do this in the footer with a text control and the
following function from the globals group like so:
="Page " & Globals!PageNumber & " of " & Globals!TotalPages


-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Mon, Jun 8, 2009 at 8:14 AM, Paul Hartland
<paul.hartland at googlemail.com>wrote:

> To all,
>
> Been on this all day and have yet to come up with a good idea that works
> well, we produce a report (SSRS 2005) on a weekly basis that we send out to
> all our employees, telling them dates & locations of jobs that they are on.
>
> What has been suggest is that we put page x of y, in the header of the
> report so that the person knows that they have received all their required
> pages of work.
>
> In the main body of the report, their is a table with the persons job
> details.  In one of the footer lines of the table are two sub-queries which
> then list all the people that are also on that job.  This can
> increment/decrement drastically, i.e. one day they will be on a job with
> two
> other people the next day they could be part of a group of 50+, so the
> pages
> numbers vary depending on the jobs they are put on.
>
> Does anybody know how I can show the page x of y for this ?
>
> Thanks in advance for any help on this.
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list