SSRS and MySQL

[Database Administrator]

Hi All!

has anyone succesfully goten RS to work with MySQL? I can get basics to
work, but I keep failing when I try to use parameters. the stuff I have
found on the web has not been helpful... any suggestions or help would be
greatly appreciated. I sure don't want to go back to Crystal for this.

thanks in advance.

[Database Administrator]

Any error message on it failing? If you are using an ODBC driver your
parameter needs to have a placeholder of a ?.

For instance:
select * from sometable where somefield = ?


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


"darwin" wrote in message
news:11286CAB-4358-4F93-BC13-328D357FD7FD@microsoft.com...
> Hi All!
>
> has anyone succesfully goten RS to work with MySQL? I can get basics to
> work, but I keep failing when I try to use parameters. the stuff I have
> found on the web has not been helpful... any suggestions or help would be
> greatly appreciated. I sure don't want to go back to Crystal for this.
>
> thanks in advance.
>

[Database Administrator]

Hi Bruce,

Sorry it toook so long to get back to you. Yes that was the issue, I was
trying to pass named parameters from RS to MySQL. Just using the ? instead
works fine so far.

Much Thanks

"Bruce L-C [MVP]" wrote:

> Any error message on it failing? If you are using an ODBC driver your
> parameter needs to have a placeholder of a ?.
>
> For instance:
> select * from sometable where somefield = ?
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "darwin" wrote in message
> news:11286CAB-4358-4F93-BC13-328D357FD7FD@microsoft.com...
> > Hi All!
> >
> > has anyone succesfully goten RS to work with MySQL? I can get basics to
> > work, but I keep failing when I try to use parameters. the stuff I have
> > found on the web has not been helpful... any suggestions or help would be
> > greatly appreciated. I sure don't want to go back to Crystal for this.
> >
> > thanks in advance.
> >
>
>
>

[simondoubt]

Just the answer I was looking for!
Using the '?' as a parameter placeholder and everything working fine now.

Thanks...