Using Dataset Filters for Cascading Parameters. RRS feed

  • Question

  • Since I am using ODBC and cannot use the IN predicate for a multi-value report parameter, I am forced to use the Dataset Filter instead of a Query Parameter (unamed parameter ? to be specific to ODBC).  However, it does not appear that the second parameter of the cascade gets refreshed correctly.  It acts as if it isn't aware (no parameter binding) that it relies on a higher level parameter, especially when the selection in the higher level parameter is changed.


    Both report parameters are associated to queries that use an ODBC data source.  Again the relationship between them is a Dataset Filter in the lower level parameter, whose Value points to the higher level parameter.


    Friday, April 25, 2008 3:58 PM

All replies