How to hide gridlines when we export cognos report to Excel formats

[sunny8]

Hello group,

I'm looking for challanging solution to hide gridlines of excel sheet when we export cognos report to Excel formats. Please find the attachment for better understaning of my requirement. Let me know if there is any possibility to fix this. Appreciate your quick response!!!!!

Thanks
Sunil

[adam_mc]

Try creating a Conditional Style based on the Report Output being Excel.

Might be something like: ReportOutput () = 'XLS'
You can select this from the Report Functions when you are creating a Conditional Style.

Apply that to the specific sections you require (Lists, Crosstab, Cells, Headers, Footers etc...).

Hope this helps!

[sunny8]

Hello Adam,

I guess, you did not understand my exact requirement. Can you please look in to screen shot attached in the previous post for better understanding.

Thanks,
Sunil

[BigChris]

Sunil, Adam's suggestion is valid - whatever formatting you do you'll only want to do it for the xls output.

[sunny8]

Adam/Chris,

But i don't want to hide the gridlines for specific objects ( List, Crosstab, Cell ). I need to hide the gridlines for whole excel sheet when the report runs in Excel format. Hope, you understand my requirement.

Thanks
Sunil

[adam_mc]

Not sure why you would still want to use Excel output if that is the case?!
Why not use PDF instead?

However, if Excel is still the requirement, try setting a Conditional Style on the output format being Excel (see thread) on the Page as a whole.
I am not sure if this will supersede the styles of any other containers on the page or whether you will have to set this Conditional Style on all objects.

Hope this helps.