RE: suppress label when exporting while exporting to excel

[allyne]

Hello,

Is there a way to suppress a label when exporting to excel. I have a group header label that I don't want to export when exporting to excel.

Thanks for your help!

 

[lbass]

You have the option of not showing page headers upon export--it is one of the options in the export screen when you select a regular Excel export.

To suppress a group header only upon export I think you would have to create a parameter that checks whether the plan is to export and then you can use the parameter to conditionally suppress the group header.

-LB

 

[allyne]

Hi LB,

Thanks for the quick response! I'm looking for a way to just suppress one label in the group header without using a parameter. The report will need to export to excel using Data-Only and either Typical or Minimal exporting format. Any thought?

Thanks!

 

[lbass]

You need to convey your intent to the report in some way. If you are able to place the label in the page header (or recreate it with a text box) and have it display correctly, you could then use the export option regarding showing page headers or not. Otherwise I think a parameter is necessary.

-LB