Search the OSCAR Documentation
< All Topics
Print

Report by Template

Report by Template (RBT) is a powerful way to access data from anywhere in any OSCAR.  The following describes the RBT for OSCAR 19 and Open OSCAR.  While the interface is different, the steps are similar for older OSCARs.

Navigate to Administration > Reports > Reports By Template

Initially you start with an empty library.

Populating the Library

Adding a Template

Templates are available on this site, or, if you are familiar with SQL you can code your own.  Click on the Add Template tab and browse to the template file you want to upload

After it uploads the file is scanned to ensure that it is in the correct format, and if so you will get a success

If there is an error in formatting you will get a warning and you will need to either fix the file or upload it in a different part of OSCAR such as the dashboard (not all of OSCAR XML files are Report by Template)

Now your library is populated

Running Reports

Either filter the list with the Search box eg INR…

or click on the template name directly

Fill in the required parameters according to the instructions specific to the template and click Run Query

Your report is displayed.

The Show entries selection will alter the number of entries per page that are shown (it defaults to 10).

The column headings are clickable to sort by that heading

You can print that which is shown (adjust the show entries as desired)

Or export the entire dataset to spreadsheet

RBT Groups

The RBT Groups tab is where you can define groups of related templates

If for example you wanted to define a Panel group, enter the label and click Add Group

To view the templates in the group just click on the grouping name, eg Immunization

Next Security Log Report
Table of Contents