Dynamic Columns

Hello... I've got a report... and based on a parameter to
the report I'd like to include/exclude the column from
appearing once you've run the report..
Example, by default report spits out aggregate data... if
I can determine a specific parameter isnt blank, I'd like
to hide a column, and show another column for customers
name.
Thanks in advance
Weston WeemsDesign the report with both columns. Click on the table so it shows the grey
header above the table, then click on the grey header of the column, so that
the total column is now selected (header, detail, footer). In the properties
area find the "Visibility" property and click on the plus sign. Next to
"Hidden" will be False by default. Click to the right of it and select
Expression in the dropdown. The expression should be something like this:
=IIF(Parameters!SomeParm.Value = "", True, False)
and do the same for the other column, swap the true and false around.
"Weston Weems" <anonymous@.discussions.microsoft.com> wrote in message
news:09df01c50986$08e748d0$a401280a@.phx.gbl...
> Hello... I've got a report... and based on a parameter to
> the report I'd like to include/exclude the column from
> appearing once you've run the report..
> Example, by default report spits out aggregate data... if
> I can determine a specific parameter isnt blank, I'd like
> to hide a column, and show another column for customers
> name.
> Thanks in advance
> Weston Weems