I have report created in BIDS 2008 on report Data in report are displayed by table. I have three groups and detail part, sub totals on the groups and grand total at the end. Page brake is set up after first group change. This is working ok and numbering is ok.
However, problem is position of page number. I have page footer and there I have text box where I put my page number as expression: = Format(Globals!PageNumber) + " of " + Format(Globals!TotalPages) + " pages".
E.g. 1 of 5 pages or 2 of 5 those page numbers are not showing at the bottom of page.
If the group is small, page number is bellow group sometimes in the midlle of page height. I need it at the bottom of page.
Any idea how to solve this?