Prompt for number of rows to view in report.

[Raghuvir]

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

[Lynn]

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.

[cognos810]

Hello Raghuvir,
You can make use of the RowNumber() report layout function to conditionally hide and show the list table rows.

Regards.