Pentaho and Mysql Servers are located in UTC timezone. The data in MySQL is also stored in UTC timezone. Users can be in any time zone.
We would like to display data according to Client's specific timezone.
As example, if the report query returns a transaction date of 9/25/2014 6:00 PM UTC, this should be displayed to a user in Eastern time as 9/25/2014 2:00 PM on the reports.