Dynamic Query Building in SQL Reporting

• Bala Nagendra Rao Betha

  Grasshopper

  Points: 16

  More actions

  January 4, 2005 at 12:44 am

  #361805

  We have a requirement in which the list of column names is flexible in report. The user should have the freedom to choose from a drop-down list of columns he wants to show in report. Will SQL Reports be able to do this?

• Jos Janssen

  Old Hand

  Points: 322

  More actions

  January 4, 2005 at 1:24 am

  #535716

  There are interesting sample reports available at http://www.msbicentral.com.

  Look especially at the CondtionalColumnPlacement.RDL sample. This will probably get you up and running.

  Regards.

  Jos Janssen

• Bala Nagendra Rao Betha

  Grasshopper

  Points: 16

  More actions

  January 4, 2005 at 3:07 am

  #535734

  Jos,

  Thanks a lot. Your help has been very useful.

  thanks and regards

  Bala Nagendra