Personal tools

Form Report

The Form Report's features will give you the ability to create study reports on any of the forms from the Encounter screen. Each form report needs to have captions added to the database field names, as well as the fields of the database you would like in the report selected. The current configured form reports at present are for the BC Antenatal Record, Labour and Birth Record and the Newborn Record.
  1. Click on Form Report
  2. Click on the desired report
  3. Click on the filter limitations you would like
  4. Select the desired date range with the little calendar buttons
  5. Click on either the [Report in HTML] or [Report in CSV]
  • Report in HTML for a report that will display in OSCAR
  • Report in CSV for a report that will display in Excel
  • 1 in the report means = yes; 0 in the report means = no

THE CSV REPORT

  1.  If the CSV report does not automatically open in Excel, save the file to your hard drive
  2. Open the Excel program
  3. Click DATA & then GET EXTERNAL DATA
  4. Click IMPORT TEXT FILE
  5. On the FILE of TYPE dropdown and select ALL FILES
  6. Find the file you saved to the hard drive & double click on it
  7. Under [Original File Type] it should be clicked on [Delimited]
  8. Click the NEXT button & TAB should be clicked off under [Delimiters]
  9. Click the NEXT button & under [Comma Data Format] GENERAL should be checked
  10. Click FINISH
  • In the next box you want it to IMPORT DATA into EXISTING WORKSHEET
  • Your report will flow into Excel in columns and rows
  • You can now manipulate your data as desired

TO EDIT FIELDS IN THE REPORT

  •  After selecting a report, click on CONFIGURATION on the upper right screen
  • The column to the right are the fields of the form that are currently selected for the report
  • The column to the left are fields in the selected form database that have NOT been used in the report currently

**NOTE: if you want to use any of the database fields on the left you MUST add captions to the fields or you will get an error when running the report.

ADD/EDIT CAPTION

  • To edit any of the field captions, click on the ADD CAPTION text link at the bottom of the left column
  • Fields that already have captions are yellow
  • Type the desired heading for the field in the left hand box and click on the ADD/UPDATE button opposite the database field name
  • When finished click on the BACK to the CONFIGURATION link on the upper right on the screen

SELECTING THE FIELDS FOR THE REPORT

  • Select a field in the left hand column and click on the ADD button to move the database field into the right column which will be in the report

  • To take field names out of the report click on the field in the right column and click on the DELETE button to move it back to the right column

CHANGE THE ORDER OF THE FIELDS IN THE REPORT

In the same window as above:

  • Click on the CHANGE ORDER word link at the bottom of the right column
  • Click on the tick box to the left of the field you want to move and click on the MOVE HERE button opposite where you want the field to move to
  • When finished click on the BACK to the CONFIGURATION word link

ADD FIELDS FROM THE MASTER DEMOGRAPHIC AREA TO THE REPORT

  • Click on the PATIENT PROFILE word link above the left column
  • These are the field from the Master Demographic screen
  • The captions can also be changed in these by clicking on the CAPTION word link
  • To go back to the form database fields, click on the FORM word link at the top of the column

Document Actions