SQL Server Performance

how to hide a dynamic column during runtime?

Discussion in 'SQL Server Reporting Services' started by lancastro1416, Mar 2, 2007.

  1. lancastro1416 New Member

    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...
  2. lancastro1416 New Member

    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...

Share This Page