Monday, March 19, 2012

Dynamically Hide Table columns through code ?

How can I hide columns of table dynamically through code ? I am using Sql
Server Reporting Service 2005.
Best Regards,
LuqmanLuqman,
You should be able to click on the column heading and then right-click and
choose properties. In the properties window make sure it shows that you have
selected the entire column...should be something like "tablecolumn3". In the
Visibility property click on the Hidden property and set your expression
there. This will hide the column based on the condition you specify.
If you need the column visibility to toggle between hidden/visible after the
report is rendered, you will need to specify a "ToggleItem" under the
Visibility property. This will allow the end user to control the visibility
of the column.
Hope that helps
Luqman wrote:
>How can I hide columns of table dynamically through code ? I am using Sql
>Server Reporting Service 2005.
>Best Regards,
>Luqman
--
Message posted via http://www.sqlmonster.com|||On Sep 13, 10:46 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Luqman,
> You should be able to click on the column heading and then right-click and
> choose properties. In the properties window make sure it shows that you have
> selected the entire column...should be something like "tablecolumn3". In the
> Visibility property click on the Hidden property and set your expression
> there. This will hide the column based on the condition you specify.
> If you need the column visibility to toggle between hidden/visible after the
> report is rendered, you will need to specify a "ToggleItem" under the
> Visibility property. This will allow the end user to control the visibility
> of the column.
> Hope that helps
> Luqman wrote:
> >How can I hide columns of table dynamically through code ? I am using Sql
> >Server Reporting Service 2005.
> >Best Regards,
> >Luqman
> --
> Message posted viahttp://www.sqlmonster.com
Each column u can refer as textbox and it has a property called ->
Visibility -> Hidden' - U can provide expression here to Hide/Show

No comments:

Post a Comment