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
render variable based on function ReportOutput()
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...
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
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
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