Dynamic Columns in Report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dynamic Columns in Report

Can we create report which should have dynamic columns. —————————————-
Contributing Editor & Forums Moderator
what would you like in terms of dynamic? something like if a parameter = option one, then it pulls column1 and if parameter = option two, it pulls column2? Joe Janka
yes.basically I should give an option end user to select what ever the fields that he wants —————————————-
Contributing Editor, Writer & Forums Moderator
put an =iif(Parameters!OptionOne.Value = "FieldName1", Fields!Field1.Value, Fields!Field2.Value) in the textbox’s value (and accompanying header too Joe Janka