03/11/2009
The Paging In Report Viewer
In Local Report, to display one result per page, after add the table, go to table properties, in the group tab, add new item with the following expression:
=Int((RowNumber(Nothing)-1)/1)
With the Page break at end option checked only.
And to display 10 items per page, change the expression to the following:
=Int((RowNumber(Nothing)-1)/10)
Subscribe to:
Post Comments (Atom)
Thanks man, I almost lose hope to solve this problem, thanks again
ReplyDeleteNice m.fawaz go ahead
ReplyDeleteWelcome Salameh
ReplyDeleteThanks Fadi
ReplyDeletecould you please add a screenshots if you don't mind?
ReplyDeletethanks in advance
What to do in case I want to show 100 records per page? I tried with =Int((RowNumber(Nothing)-1)/100) but it always shows a defualt count of 45 rows..
ReplyDeletePlease help
Abhishek, if it dosn't display 100 records, first make sure the records more than 45, after that test the expression, if it doesn't display 100 records, increase it and test. but this should work.
ReplyDeletePlease inform me about the status, to try help you.
Hi Mohammad, I have got more than 1000 records coming up in 5 pages. I changed the expression several times. It works when I want to show 10,20 or anything below 45 rows per page. But whenever I increase it to 50 or more, it doesn't work...:(
ReplyDeleteAbhishek, try to increase reportviewer height.
Delete="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString()
ReplyDeleteHi Mohammad, I have 4000 records already grouping by account number and in the same added another expression as
ReplyDelete=Int((RowNumber(Nothing)-1/100).. I increased the reportviewer height too...but the paging not working...can you please let me know