How to limit the output in a report for testing?

Let us assume that I have to create a report whose output has 1 Million rows. When I create the report and run it may take several hours to show me the complete report. So can I limit the output to just 100 rows to save time while testing the report? Thanks in advance.

sreshty
Profile Answers by sreshty Questions by sreshty
May 21st, 2008
2
3444

Questions by sreshty

Cognos

Answer

Showing Answers 1 - 2 of 2 Answers

angel987
Profile Answers by angel987

Jun 26th, 2008

In the run options set the data mode to limited data.

arunkiranrega
Profile Answers by arunkiranrega

Aug 11th, 2008

You can limit data by applying filter on some query item - for example if you have somany contract ids - you can apply filter contract id -1234