Hi,
I would like to ask if is it possible to put page numbers in the field not using Header or footer?
Sincerely,
Ivan
*This post is locked for comments
Is there any specific reason, you want to have page numbers in body section of the report?
Yes in the body section is it possible? because I check the global expression can only be used only in the header and footer.
I don't know whether it works but review this link:
social.msdn.microsoft.com/.../page-number-records-number
I try it one time and I think it's not posible do it on Axapta SSRS reports.
Thanks Abascal for help but this one also not working.
I think it only applies on Header and footer page only.
I agree this funcionality seems disabled on Ax Reports
I disagree. There is content in the link that Abascal posted that will definitely work, however, it was not spelled out clearly enough.
In summary, you need to modify your query so that the query itself contains a field that represents the page number.
Then within your report design you need to make sure that your tablix that composes the body is grouped by the page number field of that dataset and that it page breaks between each group.
Finally, you need to make sure that the tablix contains rectangles (not the default textboxes) so that you can have a lot of flexibility when you are formatting the layout within them.
Remember, the page number will come from the dataset; it will not be available via the global functions that you would normally use.
There is no relationship between page header/footer area and body area in Reporting Services 2005. That means you cannot pass variable between two areas- page header/footer and the body. So, I’m afraid you cannot use page number on the report body so far. But if you are using reporting services 2008, you can reference dataset fields and dataset aggregations from expressions in the page header and page footer. Here is a discussion about why we cannot use global variables (Page Numbers) in the report body:
social.msdn.microsoft.com/.../243e6b82-70f5-4051-8b3f-4110f931591f
One possible workaround is calculating the page number yourself. Suppose the report has 100 records, and one page has 10 row, so using RowNumber()/Count(field,”dataset”) to achieve that. I haven't tried this.
Please mark this question as answered if this helps.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Community Member 2
Nayyar Siddiqi 2
