SQL Server Performance

Dynamic Columns in Report

Discussion in 'SQL Server Reporting Services' started by dineshasanka, Sep 19, 2006.

  1. dineshasanka Moderator

  2. jastone New Member

    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
  3. dineshasanka Moderator

    yes.basically I should give an option end user to select what ever the fields that he wants

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

  4. jastone New Member

    put an =iif(Parameters!OptionOne.Value = "FieldName1", Fields!Field1.Value, Fields!Field2.Value) in the textbox's value (and accompanying header too

    Joe Janka

Share This Page