Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Different list rows per page amount for HTML view than Excel view

    Posted 08/21/23 02:08 PM

    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



    ------------------------------
    Ben Nemceff
    ------------------------------


  • 2.  RE: Different list rows per page amount for HTML view than Excel view
    Best Answer

    Posted 08/22/23 03:32 AM

    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.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 3.  RE: Different list rows per page amount for HTML view than Excel view

    Posted 08/23/23 09:51 AM

    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



    ------------------------------
    Ben Nemceff
    ------------------------------

    Original Message


  • 4.  RE: Different list rows per page amount for HTML view than Excel view

    Posted 08/29/23 03:05 AM

    Another (simpler) method of achieving this would be to use the report property: Rows per page in HTML reports. This is found within the Report tab of the properties of the report, rather than in the report editor:  

    Assuming the number of rows you want is one of the available options.  

    To use this then simply leave the rows per page on the list within the report editor blank. You should find Excel still fills the page, and then the HTML page will show the rows selected above.  

    Ben's technique is far more powerful, but comes at a cost of complicating the report. You end up duplicating the list and potentially having to maintain multiple lists.

    I am not saying the above wold be the answer, but it is something you should be aware of and investigating before you complicate the report.



    ------------------------------
    Marc Reed
    ------------------------------

    Original Message


Related Content