Cognos Analytics

 View Only

  • 1.  Cognos Excel output adjusting the column width based on footer text length

    Posted Thu January 05, 2023 10:51 AM
    Hi,

    We got a requirement that need to add notes in report page footer. And the notes is very lengthy. when we download the output in excel then based on footer length the first column width is getting adjusted and taking more width for first column in the list and it doesnt looks good.

    Tried placing the text in table/block and gave width since its not coming as expected. Is there any possible way that list column width should not get more wider based on footer?

    Note: The problem is only for excel output .HTML and PDF are good. we have used report page option Group repeating cells as 'NO' because of this excel output rows/columns will not merged.


    Thanks in advance.

    Regards,
    Pavithra.

    ------------------------------
    Pavithra N
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Excel output adjusting the column width based on footer text length

    IBM Champion
    Posted Thu January 05, 2023 11:39 AM
    Hi Pavithra,

    You might want to try to use RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL.
    Specifies whether text is wrapped within a cell in Excel outputs. The default value is false.
    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=reference-report-service-batch-report-service-advanced-settings

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 3.  RE: Cognos Excel output adjusting the column width based on footer text length

    IBM Champion
    Posted Fri January 06, 2023 03:59 AM
    Hi, I don't have a perfect solution but managed to prevent this at least to some extend. Align report obejcts that give an output (like data containers, layout calculations and text) vertically and set their width to 100%. Maybe you have to play with this a while but for some constellations the Excel line with the footer message will be merged. If you wreck the HTML layout by these adjustment you need to move the adjustment into a conditional style that does these just for ReportOutput() = 'spreadsheetML'.

    ------------------------------
    Philipp Hornung
    Business Intelligence Manager
    Techniker Krankenkasse
    Hamburg
    ------------------------------

    Original Message


  • 4.  RE: Cognos Excel output adjusting the column width based on footer text length

    Posted Sat January 07, 2023 02:21 AM
    You can try add a table with multiple columns then merge those columns and add the text .
    Add as many columns in the table as required to add the width.

    ------------------------------
    sumeet yadav
    ------------------------------

    Original Message


  • 5.  RE: Cognos Excel output adjusting the column width based on footer text length

    Posted Mon February 06, 2023 05:06 AM
    Hello Everyone,

    Thanks for your valuable responses. Apologies for my late response.

    Found a solution for this . In Footer ,placed the text in a table and changed the table classes to Field set .Then in footer properties need to set no wrap. Thats it.

    By doing this whenever text is lengthy/small/medium it s not making the first list column wider. 

    Thanks,
    Pavithra.

    ------------------------------
    Pavithra N
    ------------------------------

    Original Message