CODEWITHSUNDEEP
reporting-servicesexportssrs-2008reportbuilder3.0
Jacob
Jacob

Reputation: 11

Export Report, excluding column

I created a report (via Report Builder 3.0), which I set to Group on specific Column. When Exporting to Excel, I set up the report to have each Group on different Sheet, with the name of each Sheet matching the value of the Group.

My question is - how do I exclude the Grouped column from being added as a column on the Excel sheets. I obviously need to still have the same functionality, but don't need the actual column to show up.

Any ideas?

Upvotes: 0

Views: 847

Answers (1)

Neil Norris
Neil Norris

Reputation: 411

  1. You can do it with parameters.

    Create a Dataset SELECT "0" AS Value, "View" as Label union all SELECT "1" AS Value, "Print" as Label

then in "Column Visibility..."

Click "Show or Hide based on an Expression"

Then create an expression to utilise the parameter values.

  1. In Code

Select the header of the column you want to hide, right-click and select "Column Visibility…". In the dialog that pops up, select “Show or hide based on an expression”.

Enter this as an expression:

=Iif(Globals!RenderFormat.Name = "EXCEL", True, False)

Upvotes: 1

Related Questions