Hi, I'm trying to add cascading parameters for a report, but whatever I do, it doesn't work. I've followed all the instructions provided by Microsoft and I've also checked many forums. I've tried to add the cascading parameters following this instructions: http://technet.microsoft.com/en-us/library/dd255197.aspx My problem is that when i run the report, and I select a product, then subproducts dropdown is EMPTY. It's not executing the query. I'm connecting to a MYSQL database using ODBC drivers, maybe that's why it's not working. Help would be really apreciatted. Kind regards.

Hi Guillermo88, To create cascading parameters, we should define the dataset query first and include a query parameter for each cascading parameter that we need. Even though the data source type is ODBC, we can create cascading parameters in our reports. Based on your description, you can retrieve data from the MySQL database via ODBC driver. Could you please post me the dataset queries in your report? I will try to assist you solve this issue. Thanks, Bin Long

Hi Guillermo88, Based on your description, you can retrieve data from the MySQL database via ODBC driver. Even though the data source type is ODBC, we can create cascading parameters in our reports. Could you please post me the dataset structure with sample data? They are benefit for solving this issue. In the “To create a dataset to provide values for a dependent parameter” section of the link above, to provides values for a dependent parameter is effect on the query. Personally, I suggest you try to add a filter on the dataset to provide values for a dependent parameter. Hope this helps. Thanks, Bin Long

There might be a problem with your where clause in your main dataset query. Please post your main data set query so that we will help you. Thanks Tarak

Hi, thanks for the replies, I solved part of the problem making the query like this: SELECT DISTINCT BOOKINGCODE FROM BOOKING_CODES_NEW WHERE (TYPE = ?) If i put SELECT DISTINCT BOOKINGCODE FROM BOOKING_CODES_NEW WHERE (TYPE = @Category) the dropdown wouldn't work. Sadly, this didn't solve my problem, because I have to send multiple values and so I read on the internet that passing multiple value parameters wasn't supported when working with a MySQL database.... Ok so then I created a linked Server, so I could access a MS SQL Database, because that would let me use multiple value parameters. The thing is that when using a linked server, the query changes: select * from openquery(MYSQL,'SELECT DISTINCT BOOKINGCODE FROM BOOKING_CODES_NEW WHERE TYPE IN @Category') Of course I know this is wrong and that it won't work, so, does anyone know the syntax i must follow to get this to work? That query is used for a job dropdown, and the job dropdown depends on the job category. First of all, MYSQL just accepts this syntax: WHERE TYPE = @Category', and not WHERE TYPE IN @Category'. Thanks in advance.Guillermo

Create views on top of OPENQUERY(s) to simplify data access. Related article: How to: Add Cascading Parameters to a Report (Reporting Services)Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

Create views on top of OPENQUERY(s) to simplify data access. -- CREATE VIEW to map an OPENQUERY CREATE VIEW vSPWHO AS SELECT * FROM OPENQUERY(HPESTAR,'exec sp_who') GO ------------ -- Test view SELECT * FROM vSPWHO ORDER BY spid ------------ Related article: How to: Add Cascading Parameters to a Report (Reporting Services) Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

I have never used view queries and I don't see how that would help me with parameters. And I've read that article like 20 times, and it's useless when connecting to MYSQL databases. Thanks in advance.Guillermo

Here is another cascading parameter article: http://blog.infotoad.com/post/2009/06/25/Working-with-Cascading-Parameters-in-Reporting-Services.aspx Let us know if easy to follow. Thanks. Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

It's very easy to follow and I've done that dozens of times, but that isn't working with ODBC,passing multiple value parameters and working with a linked server. I need to pass multiple value parameters, and this isn't supported if you arent connecting to a SQL Database, but if you create a linked server yo a MYSQL database it should work properly, but it isn't. Kind regards. Thanks in advance.Guillermo

How about enveloping the OPENQUERY into a view (see above) or a stored procedure? -- CREATE PROCEDURE to map an OPENQUERY CREATE PROCEDURE sprocSPWHO AS SELECT * FROM OPENQUERY(HPESTAR,'exec sp_who') ORDER BY spid GO ------------ -- Test PROCEDURE EXEC sprocSPWHO ------------ Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM