report page count by account

[hobbes]

I have a query which pulls all of the records I want. I have that query attached to a report that puts a page break after each account. One account can have many transactions which are grouped together. So I end up with a report that has various numbers of pages for each account (based on the number of transactions for that account). My report has a page count in the footer (automatically put in there with the report wizard). So if I have a report with 600 pages, that number is reflected on each page. I need to know if it's possible to display only the number of pages associated with each account.

For example:
account 1 has three pages
account 2 has one page
account 3 has one page
account 4 has six pages
account 5 has four pages

So instead of the bottom/footer of each page saying 'Page 1 of 600', 'Page 2 of 600', 'Page 3 of 600', etc., I would like it to say 'Page 1 of 3', 'Page 2 of 3', 'Page 3 of 3', 'Page 1 of 1', 'Page 1 of 1', 'Page 1 of 6', 'Page 2 of 6', etc. So in essence there is a count of pages for the individual accounts displayed.

How do I go about doing this?

Thanks!

 

[Puyol]

Hello,

go to www.msdn.com
and search for this number:
841779

You will find the answer!

Puyol