Hiding/Showing columns based on the columns present in the dataset

I have query which retrieves multiple column vary from 5 to 15 based on input parameter passed.I am using table to map all this column.If column is not retrieved in the dataset(I am not talking abt Null data but column is completely missing) then I want to hide it in my report.

Can I do that?

Any reply showing me the right way is appricited.

-Thanks,

Digs

In the Column properties, expand the Visibility section, and then click on Hidden, and choose Expression.

In the expression, use the same input parameters that you are using to build the column list in your SQL Statement to set the property.

An example expression might look like this:

=iif(Parameters!ShowColumn1.Value= True, false, true)

Where Parameters!ShowColumn1 is a report parameter that you have defined,

This should get you started...

BobP

|||

Hi,

Thanks for the reply..Need bit change =IIf(Fields!Collection.IsMissing=True,True,False) In Visibility -- > Hidden

-Thanks,

Digs

Hiding document map.

First off let me say that I am not sure that I want to hide the document map.
I have a situation where I have a report that displays data in groups of
'contractors'. I have a document map that lists these 'contractors'. When a
'contractor' is selected from the document map it will move to the page that
the 'contractor' can be found on but it does not set focus to that
'contractor' group.
Is it possible to set focus to that group?
If it is not possible to set focus, then how can I hide the document map? I
am using the Report Manager to display this report.
Thanks in advance.You can "hide" the document map in Report Manager by clicking on the "x"
button in the document map window.
If you don't want the content of the document map being generated at all,
then you should remove the expression from the grouping's "Label" property.
By default reportitems and groupings don't have a Label value specified and
therefore no document map is generated.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Anger" <MichaelAnger@.discussions.microsoft.com> wrote in message
news:DCDB64DB-5504-4ED2-9E2A-A38D1203A58D@.microsoft.com...
> First off let me say that I am not sure that I want to hide the document
map.
> I have a situation where I have a report that displays data in groups of
> 'contractors'. I have a document map that lists these 'contractors'. When
a
> 'contractor' is selected from the document map it will move to the page
that
> the 'contractor' can be found on but it does not set focus to that
> 'contractor' group.
> Is it possible to set focus to that group?
> If it is not possible to set focus, then how can I hide the document map?
I
> am using the Report Manager to display this report.
> Thanks in advance.