I have been trying and trying but can't seem to get this right.
I have 2 tables on my report. Each linked to a different datasource. What I want to do is have each table show not more than 10 rows at a time and should there be more have an option to display the next 10 rows in the table. Is this even possible in SSRS?
I know it is possible in other applications but I want to do it in SSRS.
So for example:
Table A only returns 7 rows from the database for what ever reason, but table B returns 34. What I want table B to do is show the first 10 rows and then a little button to click to the next 10 and so on. And if possible have the ability to show how many "pages" of 10 there are.
That merely adds a group of 10 rows that can be expanded but if there are 100 groups shows all 100 groups which are expandable and therefore not usable as it still scrolls for WAY to long. I have since learnt that what I am wanting to do is not possible in SSRS, so will have to look at a standrd ASPX page solution or some other software.