How to get there
On the Home menu, under Reports, click (or tap) Power Reporting.
The Power Reporting page opens.
Click (or tap) the icon of a report whose name begins with "Interactive" and ends with "Report Builder" (to create a report from scratch). Or, click (or tap) a saved report (for only you or for all users) that was based on an interactive report builder.
The interactive report builder appears.
Click (or tap) the Toggle Edit link.
The interactive report builder options for that report appear.
The interactive report builder consists of the following areas to help you create, view, and export custom reports:
Data tab - Depending on the type of interactive report (for example, schedule), the items (data fields) that appear on the Data tab may vary. The data fields in the list correspond to information in your organisation's database. The data fields are grouped by category.
Note:The information for each data field in the list is updated automatically from data in your organisation's database every 15 minutes.
Filters box - The Filters box displays filters you have set up. From this box you can edit and remove filters.
Toolbar - You can perform various tasks, such as controlling the layout of the page and exporting the report, from the toolbar.
View area - The report appears in the View area according to the layout and filter options for the selected data fields.
Example: A custom report that displays the number of appointments with each of the specified statuses within the specified year. Also, the report is grouped by provider.
To use the interactive report builder to create a custom report
Double-click (or double-tap) the current report name ("Untitled" by default), and then enter a name for the report.
To create the layout of the report, drag data fields from the Data tab to the View area.
Do any of the following:
To create a column, double-click a data field, or drag a data field to the viewing area. Release the mouse button when the vertical guide appears in the desired location.
Tip: To add a column to the right of an existing column, drag a data field to the right side of the viewing area.
To group the columns on the report, drag a data field to the area directly above the column headers in the viewing area.
The data from your database syncs with the reporting system automatically and displays the time of the last sync on the Data as of button. Data entered in Dentrix Ascend after the time shown will not be available on the report until the next sync. To view the time when the next sync is expected to occur, click (or tap) the Data as of button.
Filter the report, and perform other tasks as needed.
Do any of the following:
Filter report - To filter the report, do the following:
Do either of the following:
Drag a data field (does not have to be part of the layout already) from the Data tab to the Filters box.
On the menu for a data field that is part of the layout already, click (or tap) Filter.
In the dialogue box that appears, select one of the following options (the available options depend on the data field), and then set up the filter:
Select from a list - Select items in the left list box and then click (or tap) the Add Selected button to add them to the right list box. To add all items at once, click (or tap) the Add All button. Select Included or Excluded from the Currently list (above the right list box) to specify that the items in the right list box will be included or excluded from the report.
Specify a condition - Specify the condition that has to be met (for example, equals 3, on 2014-11-11, or exactly matches "Brent").
Click (or tap) OK to apply the filter.
Filter by prompts - You can dynamically filter the report based on a selection that is associated with a data field. As you change your selection, the report is updated immediately. To filter by a prompt, do the following:
To add a prompt, do either of the following
Drag a data field (does not have to be part of the layout already) from the Data tab to the Prompts box.
On the menu for a data field that is part of the layout already, click (or tap) Prompt.
Make a selection from the list that appears.
Undo / redo changes - To undo any layout and filter changes, click (or tap) the Undo button . To redo any changes that were undone previously, click (or tap) the Redo button .
Change view - To make more room for viewing the report or to show areas that have been hidden previously, click (or tap) any of the following buttons:
Filters button (if there are filters being applied to the report, the button has a number on it).
Layout button .
Prompts button .
To save the report as a template for later use, click (or tap) Save. In the Save Report dialogue box that appears, enter a name for the report, select whether you want to save the report as one of your reports (available only to you) or as an organisation report (available to all users), and then click (or tap) OK.
To export the report to save or print it, from the Export button menu, click (or tap) the desired output file format (for example, PDF).