Paul Hartland
paul.hartland at googlemail.com
Tue Jun 9 01:11:15 CDT 2009
Thank you Franciso & Betsy for your replies, I do know how to the that type of page numbering. But reading through my email I probably didn't explain myself too well, this report uses a large query which has all the employee's that are on jobs for a specific week/date range. I will try another example below: Arthur Andrews, Paul Hartland, Lesly Smith all have jobs on one week, Arthur has jobs which run across 10 pages, Paul has jobs which run over 5 pages, Lesly has jobs which run over 7 pages. Using either of the functions supplied the results would be page x of 22 (10+5+7), however all the employees are printed alphabetically, with a page break after the group (which is based on their payroll number). What I ideally want is still the report to have the whole 22 pages, but on Arthurs pages I need to show page x of 10, Pauls pages to show page x of 5 & Leslys pages to show page x of 7. Has anyone achieved this or had a similar issue ? Thank you again in advance. Paul Hartland paul.hartland at googlemail.com 2009/6/8 Francisco Tapia <fhtapia at gmail.com> > 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 > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- Paul Hartland paul.hartland at googlemail.com