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

To add a template you click on the Add Template tab.  You can upload your own or one developed by the community. Note that the template list is filtered in the search box

Templates made available by the community are available on this page, or, if you are familiar with SQL you can code your own. A tutorial for creating your own RBT’s is available here.

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

Documentation Copyright © 2012-2022 by Peter Hutten-Czapski MD under the Creative Commons Attribution-Share Alike 3.0 Unported License

Next Security Log Report (Audit Log), Fax Status & OSCAR Status
Table of Contents