how to hide the header section of the report when opening in excel

[inu]

Hi
While working with report studio, When we run the report in html , pdf fromat, it should display with all section, header, body, footer. But when we run the report in excel format, header part should not be displayed, as it occupies big space with column.

I want to hide this heading or tiltle, while we open the report in excel format. Is it possible, if it is , then let me know, please.



Warm Regards
Inam

[Samrat]

Hi,

Use render variable and use reportoutput() function and if output is excel then do not render header portion of the report else keep rendereing as yes..  you may have to keep your header portion in a table and render the table portion..

Cheers
Samrat..

[inu]

Hi samrat
Thanks a lot....Could you please post the syntax , which i need to write in expression definition.


Warm Regards
Inam

[Samrat]

In Conditional explorer create Boolean variable and try this

ReportOutput ()=XLS

By default Yes and No values will appear in Values section.

Go to report page and select table in the header and under properties in 'render variable' option select render variable you created and it wil by default select Yes.. thats it..