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
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
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