1. dineshasanka Moderator

   Can we create report which should have dynamic columns.
   
   
   
   ----------------------------------------
   Contributing Editor & Forums Moderator
   http://www.SQL-Server-Performance.Com
   
   

   dineshasanka, Sep 19, 2006

   #2
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

   jastone, Oct 4, 2006

   #2
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
   
   

   dineshasanka, Oct 4, 2006

   #2
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

   jastone, Oct 5, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in