Tuesday, April 08, 2014

SSRS 2008 R2 Report parameters for MySQL datasources

If you are using MySQL databases in SSRS you have to manually add the parameters.

For a date range

Manually add two parameters
@start (date/time)
@end (date/time)

Go into dataset properties
Updated the query with appropriate where clause:

e.g. WHERE table.date between @start and @end

# The system gives an error warning about defining the parameters, ignore this.

Define parameters in dataset properties
link parameter name "@start" with Parameter Value "@start" and same for @end

1 comment:

  1. Anonymous9:05 am

    ODBC does not allow for name parameters