Hi All,
We have come across a requirement where we have to give the option to enter the number of rows he wants to view in the report. is this possible in report studio ?
e.g. if in the prompt the user enters 25 then he only see's the 25 rows in the report.
Request you to guide us with the same. Thanks in advance.
Regards
The absurdity of some user requirements never fail to amaze and entertain.
Is your source relational or dimensional? Are a specific group of rows to be displayed or will any random bunch of rows suffice? What possible insight does a user expect to gain by viewing partial results?
I supposed if the source is relational you could do a running count of rows and then include a filter that limits the results using that query item and your row number parameter.
Hello Raghuvir,
You can make use of the RowNumber() report layout function to conditionally hide and show the list table rows.
Regards.