COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: mshparber on 20 May 2015 02:25:35 AM

Title: Breaking rows in a list to pages
Post by: mshparber on 20 May 2015 02:25:35 AM
Hello friends,

I need to show the detailed data in active report and it takes time to show all the rows in a list (even when I use Data Deck to filter)
How do I limit the number of rows shown, let's say, to 10 rows by default and allow the user to scroll through the rest of the results?
I do not want to limit the query, just the results shown in a list. There's such an option in a regular report.
How do I do it in Active Report?

Thanks in advance
Michael
Title: Re: Breaking rows in a list to pages
Post by: MFGF on 21 May 2015 07:25:16 AM
Quote from: mshparber on 20 May 2015 02:25:35 AM
Hello friends,

I need to show the detailed data in active report and it takes time to show all the rows in a list (even when I use Data Deck to filter)
How do I limit the number of rows shown, let's say, to 10 rows by default and allow the user to scroll through the rest of the results?
I do not want to limit the query, just the results shown in a list. There's such an option in a regular report.
How do I do it in Active Report?

Thanks in advance
Michael

Hi,

You can show just the top part of the list by placing it within a block, and setting the Size & Overflow property of the block. If you select the "Use scrollbars only when necessary" option, you will then get a vertical scrollbar if needed.

MF.
Title: Re: Breaking rows in a list to pages
Post by: mshparber on 25 May 2015 12:54:50 AM
Great stuff, MF!

Thanks a lot!

Michael