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

Thursday, April 03, 2014

RS-232 temp/rh logging

Setup RS-232 connection between a Rotronic temp sensor and a Rasberry Pi.

Next step is to write an integration script to import the data into a MySQL database..