Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-828

View Report gives false result

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Must
    • Resolution: Information Provided
    • None
    • None
    • None
    • Low

    Description

      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

      Gliffy Diagrams

        Attachments

          1. 1.PNG
            1.PNG
            9 kB
          2. 2.PNG
            2.PNG
            33 kB

          Activity

            People

              Unassigned Unassigned
              choxmi Choxmi Sathsara
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: