HI,

In Cognos 11.1.7, I'd like the list property "Rows per Page" to be set at a number like 250 so render time is not too long, yet a user can get a decent amount of results on their initial view and scroll along that first page for more, rather than going to the "page down" button.  

The excel output ends up splitting the output amongst multiple worksheet tabs when the property is set to 250.  It can be sidestepped by clearing out that "Rows per Page" property and entering no value, but then this makes the render time on the default view in HTML too long.  I see I could export to Excel Data or CSV, but I really want to maintain those data type and formatting properties I get when it's exported to Excel.  

Does anyone know of a way to accommodate this  request?

Much of the report use is by way of filters that slice and dice this data and create views of just a few hundred rows, but the top level company view that is used as well is thousands of rows.

Thank you

Hi Ben,

the only way I know is to create different report layouts for each output format. To do so creat a new string variable wit the expression ReportOutput(). Then enter the desired values. You don't need to enter one for HTML as this is the default layout. "spreadsheetML" is the value for Excel format.

 Afterwards enable conditional layouts in the report properties

Voila, one report layout for each output format. Keep in mind that you have to maintain each output format separately. I reduce the amount of work by using layout component references a lot. Just name your report objects and refer to them on other pages.

HI,

In Cognos 11.1.7, I'd like the list property "Rows per Page" to be set at a number like 250 so render time is not too long, yet a user can get a decent amount of results on their initial view and scroll along that first page for more, rather than going to the "page down" button.  

The excel output ends up splitting the output amongst multiple worksheet tabs when the property is set to 250.  It can be sidestepped by clearing out that "Rows per Page" property and entering no value, but then this makes the render time on the default view in HTML too long.  I see I could export to Excel Data or CSV, but I really want to maintain those data type and formatting properties I get when it's exported to Excel.  

Does anyone know of a way to accommodate this  request?

Much of the report use is by way of filters that slice and dice this data and create views of just a few hundred rows, but the top level company view that is used as well is thousands of rows.

Thank you

Hi Robert, 

Thank you, I really appreciate it!  This is going to work out great, I'm going to play with it some more as I haven't used layout component references before so this is going to help me out with that experience too.  I just need to clean it up a little more but initial tests look like it will work great for what I needed.

-Ben

Hi Ben,

the only way I know is to create different report layouts for each output format. To do so creat a new string variable wit the expression ReportOutput(). Then enter the desired values. You don't need to enter one for HTML as this is the default layout. "spreadsheetML" is the value for Excel format.

 Afterwards enable conditional layouts in the report properties

Voila, one report layout for each output format. Keep in mind that you have to maintain each output format separately. I reduce the amount of work by using layout component references a lot. Just name your report objects and refer to them on other pages.

HI,

In Cognos 11.1.7, I'd like the list property "Rows per Page" to be set at a number like 250 so render time is not too long, yet a user can get a decent amount of results on their initial view and scroll along that first page for more, rather than going to the "page down" button.  

The excel output ends up splitting the output amongst multiple worksheet tabs when the property is set to 250.  It can be sidestepped by clearing out that "Rows per Page" property and entering no value, but then this makes the render time on the default view in HTML too long.  I see I could export to Excel Data or CSV, but I really want to maintain those data type and formatting properties I get when it's exported to Excel.  

Does anyone know of a way to accommodate this  request?

Much of the report use is by way of filters that slice and dice this data and create views of just a few hundred rows, but the top level company view that is used as well is thousands of rows.

Thank you