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
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