Cascading Parameters Using ODBC

• ImYourDBA

  SSCertifiable

  Points: 5654

  More actions

  September 28, 2010 at 10:10 am

  #224442

  Does anyone know how to successfully utilize cascading parameters when using an ODBC connections in SSRS? Basically I have a data source that is an ODBC connection to a Sybase database and I need to be able to implement cascading parameters so a user can select param 1, which then filters down the options to choose from for param 2. And if they do not want to select anything for param 2, then can leave it blank (or select all if need be).

  Thanks

  Owner & Principal SQL Server Consultant
  Im Your DBA, Inc.
  https://www.imyourdba.com/

• prvmine

  SSCertifiable

  Points: 7007

  More actions

  September 28, 2010 at 6:29 pm

  #1228725

  this should give you a start

  for 2005

  http://msdn.microsoft.com/en-us/library/aa337169(v=SQL.90).aspx

  for 2008

  http://msdn.microsoft.com/en-us/library/aa337169(SQL.100).aspx

  the best explanation I've seen is in "Professional SQL Server 2005 Reporting Services" by Paul Turley, Todd Bryant, James Counihan, and Dave DuVarney