Logo/Image Output to Excel

[jv_oz]

Hi all,

I have a report studio report that looks awesome in HTML and PDF. It has a logo in the top right corner. When this is output as an Excel 2007 file it still puts the logo in the top right corner, however it merges a block of about 10 columns and four rows - which just looks dumb!

So, can anyone please advise how I can either stop or limit the cell merging where the logo is OR remove the logo from output when Excel 2007 is chosen?

Thanks heaps for your help,

John

[sdf]

render variable based on function ReportOutput()

[BigChris]

The render variable is the way to prevent the logo being shown. I don't know of a way to stop it merging multiple rows though...I get the same thing with my logo when it goes out to Excel so I'd be interested in a solution. I don't think there'll be one though...

[New_Guy]

Hi,
There is no way around it except altering the output with VBA within Excel. We had this issue from years and asked the users if they want to really see a logo that is 15px height in for excel format which can fit in one row.
Good luck
New Guy

[Cognos_Jan2017]

I don't have a Logo Report to test this, but we encountered a "dumb looking Merge" running to Excel 2007.

We guessed maybe it would run OK to Excel 2002 ... it did.  Maybe it will work w/ your Logo?

Please let us know.  Thank you, Bob

[jv_oz]

Hi all,

Thanks for your advice.

I have used the report variable as suggested. For others who may be looking at this, this was the process:

• Create a Boolean Variable in the Condition Explorer called "ExcelOutput"
• Define the expression "ReportOutput() in ('singleXLS', 'XLWA', 'xlsxData', 'spreadsheetML', 'XHTML', 'CSV')" in the Variable
• Insert a Conditional Block in my report.
• Define the Block Variable in the Conditional Block to use "ExcelOutput"
• Set the Current Block to "Yes"
• Insert a Text block and some text into the Conditional Block
• Set the Current Block to "No"
• Insert an Image into the Conditional Block