View Report gives false result

If the result of an indicator is 'zero', view report section give the output as '1'. After clicking on that, it gives an EvaluationException .

Steps:

EDIT

Creating indicator :

• Reporting -> Report Administration -> Cohort Queries -> Add SQL Cohort query
• Use SQL queries like,
  1. SELECT COUNT FROM tbl_name
  2. SELECT count(distinct e.patient_id) FROM encounter e INNER JOIN person p ON e.patient_id =
  p.person_id WHERE DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(), p.birthdate)), '%Y')+0 < 15 AND
  e.encounter_type IN (42, 49) AND e.encounter_datetime >= :startOfPeriod AND e.encounter_datetime
  <=:endOfPeriod and e.location_id =:locationId
  which should give the response as 0. And save.

Adding Indicator to the Report :

• Report Administration -> Edit or create a Period Indicator Report -> Add(Indicators section) -> Tick Create from cohort query -> Select created Cohort query from the list -> Enter number and a Label -> Save

Render the report :
Go to reporting -> Report Administration -> Request the report with parameters -> View Report
In that page you can see the indicator return the value as '1'
Click on that and it should give the exception