How can I pass parameters using MYSQL and MS Reporting Services
Posted on 2009-05-11
Normally when I create a report using Microsoft Reporting Services connected to a SQL 2005 database, I declare the parameters in the beginning of the code as follows:
Declare @Start datetime, @End datetime
Later in the code I then use:
Where tablename.date >= @Start and tablename.date<= @End
Now I'm connecting to an older MYSQL version 4.? database but I keep getting an error about syntax in the first line when I try declaring the parameter. I know the query works without the parameters but I don't know how to pass parameters in MYSQL. I could not find much help on this online either. The vendor I'm working with is using this MYSQL db so I have very limited control over what I can do on that database and/or server.
I really thought I was over the hump just getting MSRS to work with MYSQL but now this - any help is greatly appreciated.