how to hide a dynamic column during runtime? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to hide a dynamic column during runtime?

im working on a report which shows the data based on the users input. I have used a matrix because I have no control on how many fields the users want, so practically we have a dynamic column here. My problem is that they require me to able the user to hide the columns he/she wishes to during runtime. We have a previous report that enables the user to hide it during runtime but it has static column. Any idea on how I could do it?… Thank you so much…
quote:Originally posted by lancastro1416 im working on a report which shows the data based on the users input. I have used a matrix because I have no control on how many fields the users want, so practically we have a dynamic column here. My problem is that they require me to able the user to hide the columns he/she wishes to during runtime. We have a previous report that enables the user to hide it during runtime but it has static column. Any idea on how I could do it?… Thank you so much…

by the way im using microsoft reporting services.. we have a previous report before that hides column during runtime.. it has static column like i’ve said… we use report parameter… our parameter value consists of 1 and 0… example if all the columns are shown it will have a value of 11111111… and if the last column is selcted to be hidden it will have a value of 11111110… we use navigation in this so when a column is selected to be hidden, we will pass a parameter… but in dynamic column i have no idea how to pass that parameter since the columns are created during runtime because it is dependent on the query… any ideas?… thanks…
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |