Steps to run a report
Running a report
After configuring and saving your report, navigate to the Run tab.
Select View Now. You should see the records displayed on the report table.
| Panel | ||
|---|---|---|
| ||
Search Rx-Universe and Rx-Suite
|
Explore basic reporting functions!
| Child pages (Children Display) | ||||||
|---|---|---|---|---|---|---|
|
Apply runtime column filter
| Anchor | ||||
|---|---|---|---|---|
|
A runtime column filter is a column on the report which values you can use to include or exclude records in your report. They can only be applied when a report is run and the configurations won’t be saved, unlike standard filters. Runtime column filters are pre-defined and are report-target specific.
There are two types of runtime column filters that you can apply to your report, Date type and Standard.
Date type runtime column filters are columns in the report that have date or date/time data types. This will filter your records for a specific period.
To apply a Date type runtime column filter, you select the column for your Date Type dropdown. Then you select either a standard date Range or a custom one where you can add a Start Date/Time and End Date/Time.
| Info |
|---|
All Time Date Type option turns off the time/period filter and will include all the records from the database. Range options are not applicable when All Time is the selected date type. |
Standard runtime column filters are non-date/time columns available in the report that are identified as the commonly used categories or filters of the customers. Each report will have a specific list of standard runtime column filters. There is an option to select only records with blank values for the column.
To apply a standard runtime column filter, you select the values that you want to be included in the report for that column. You can select multiple filter values per column.
Export to PDF
Based on your selected report target, you can select the columns you want to show in your report. To set up your columns:
After selecting a report target, the Columns option list will display. You can look up a column in the Search area or scroll through the list to manually find it.
Select Add (+) icon to add the column to the selected column panel.
You can reorder the columns by dragging and dropping the column card.
If you want to rename the column, you enter the custom name on the Rename Column field. This will rename your column in the report table and in the exported files.
You can set a sort priority to your columns by entering a numeric sort order value in the Sort Priority field. If no sort priority is entered, the records will be sorted based on the first column of the report.
There is no limit on the number of columns you can add to the report and you can add the same column multiple times.
| Note |
|---|
The list of selected columns will reset if you change your report target. |
Export to CSV
After adding the required details and setting up your columns, you can submit the report and save it to the database. The Submit button will be activated once the required information was added.
You can select Submitto save your report.
| Tip |
|---|
A message will display upon submission to indicate if the record was saved successfully. |
Watch a walkthrough video
| Note |
|---|
The Rx-PDF Windows service must be running to use the export to PDF function. |
After running your report, you can export the results to a PDF file.
To export the results to PDF, follow these steps:
Select the Setup PDF button. The PDF Template dropdown field and a disabled Generate button will display.
Select the PDF template that you want to use for the export. This will enable the Generate button.
Select the Generate button. This will start the export process and a disabled Download button will display.
Once the PDF file is ready for download, the Download button gets enabled and you can download the PDF file.
Export to CSV
Another export format option available is CSV file format.
To export the results to CSV, follow these steps:
Select the Export (CSV) button. This will start the export process and a disabled Download CSV button will display.
Once the PDF file is ready for download, the Download CSV button gets enabled and you can download the CSVfile.
