October 18, 2016 at 10:33 am
Hi all,
Followed this article: https://www.mssqltips.com/sqlservertip/3493/display-a-fixed-number-of-rows-per-page-for-an-ssrs-report/
and limited the rows to 25, so that I could see the header on each page.
In Visual Studio in my SRSS I can see the Column Readers fine on both the first and second pages.
But when I publish the report to Reporting Services, the first page is fine (shows 25 rows), but then I click page 2, the report just hangs on "Loading" forever...
I've tried different browsers etc, same result.
There are only 3 records on page 2, so it's not a data issue.
If I turn off the setting on the Static Row Group to KeepwithGroup to After, that's when it does not work.
If I turn the KeepWithGroup to None, then it works, but I do not get my column headers on page 2....
This is driving me round the bend.... anyone suggest another way to get this working.
October 19, 2016 at 4:34 am
Managed to get this working by using a Parent Group and added in: =ceiling(rownumber(nothing)/2000)
The side-effect of applying this is now that my interactive sort has stopped working.
Anyone able to do a step by step on being able to use a Parent Group with =ceiling(rownumber(nothing)/2000) and also still allow me to use interactove sort on each column?
If everything is on one page the interactive sort works, if u have multiple pages (pagination so that my headers are always at the top), the interactive search no longer works.
Any help appreciated.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply