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 > >