Hi, I have a report where there is a requirment to show the Page numbers in a table.since the Built in function for Page Number can be used only in a header or a footer , I need a help where i need to show the page number in a table. Please let me know if there is a way to represent page number in a table. Thanks, Santhosh
The workaround is to add another column in your DataSource which would act as a dummy page breaker and its value would serve as the PageNumber. i.e SELECT ROW_NUMBER() OVER (ORDER BY PRIMARYCOLUMN_OR_ANYCOLUMN)/ 40 + 1 PageNumber, OTHERCOLUMN... FROM YOURTABLE Add this column as the Parent Group and In Group Properties -> Page Break Options -> Check "Between each instance of a group". Then you can show the PageNumber Column as the PageNumber. But mind you this would limit the number of rows in a page to 40. If you want more rows then change it accordingly.