If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display title across merged cells in Excel 2007

Started by acadia97, 19 Mar 2013 09:13:04 AM

Previous topic - Next topic

acadia97

We are running Cognos BI version 10.1.1.  Recently we applied the Interim fix 2 for security exposure issued by IBM. 

Before we applied the fix, a report studio report with 2 objects - a text box and a calculated date - exported to Excel 2007 displayed across merged cells, the entire width of the report. 

After we applied the fix, the same report exported to Excel 2007 displays in 2 (unmerged) cells, 1 for the text box (column A), and 1 for the calculated date (column B). 

Our user prefers the merged cell output.  I would appreciate any suggestions!  Thank you. 

Rahul Ganguli

If the textbox and date are in a block, you can add then in a table in two different cells and then merge the cells.
Also, can you send the report XML so we will have a better look into it.

Regards,
Rahul

acadia97

Thank you Rahul for the suggestion.  I believe this will approach satisfy our user community.