Report Query Builder - Introduction and report examples

Article author
Greg Pietras
  • Updated

What is the purpose of the article?


This article serves as an introduction to the Reporting tool available in Meddbase. Furthermore, the article sets out examples of reports with different complexity and the process of building them.

    Please note: Each example of a report contains a link to a detailed article. Click the relevant report example title depending on the level of complexity you are interested in.

 

Introduction


When analytics and data tracking are at the forefront of your business, it is important to have the correct tools. The Meddbase Report Query Builder is a powerful tool for handling the vast amounts of data your system can collect. From appointments to demographics, accounts to referrals, your data can be pulled into functional, powerful reports.

Please be aware the Query Builder is a chargeable feature. If you feel this would be appropriate for your clinic/practice please contact your Meddbase Account Manager or contact the team via the following email address accountmanagement@meddbase.com 

 

Report examples (with varying complexity)


Simple report on Patient Demographics

  • Quick and easy to build, no complex features used

Report on Appointments containing filters and parameters

  • Utilizing the Filter Builder to filter out data for a more detailed report

Report on Invoices - displaying multiple results using Aggregates

  • Utilizing filters as well as aggregates to organise multiple results in columns

Report on clinic utilisation using the Alias Manager

  • Building sub-queries via the Alias Manager

 

Review date


This article was last updated on 14th of June 2021 in the context of Meddbase version 1.244.0.29994