How to hide the multiple columns at runtime by clicking the Link button in a SSRS 2008

See more:

SSRS

Hi Good Morning.

This is Chandra.

My query is like

I have eight columns in my report such as Col1,Col2,Col3,Col4,Col5,Col6,Col7, Col8

I have four link buttons in my report such as Part1 Part2 Part3 Part4

Intially the report will be going to display all columns such as Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8 by selecting some item from the drop down. I am using Tabular report to display the report.

Here my problem is
If i click Part1 link button the Tabular report should display All columns.

If i click Part2 link button the Tabular report should display Col1 Col2 Col3 and Col4

If i click Part3 link button the Tabular report should display Col1 Col2 Col5 and Col6

If i click Part4 link button the Tabular report should display Col1 Col2 Col7 and Col8

How can i do that? Can any one give some example to acieve this.

Thanks

Chandrakanth