Reporting

Crystaltrack REPORTING (Advanced and Dynamic Embedded Reporting):

Main Concept:

Query Builder which allow the user to create new User-Defined Queries on Crystaltrack Tables (Main Database or ODS Database).

Query Builder will have the list of all Entities (Tables).

When a table is selected => All fields are displayed.

The user will define a query with the following:

Select Fields to be displayed are columns of the query.

Add needed filters: conditions or fields to be filtered by the report.

Assign some features to columns as: Groupable, Aggregation to be applied, Alignment, Conditional Formatting.

Add Computed Fields to the Query based on the selected columns.

The user will define a report with the following:

Select the query of the report.

Select the module of the report.

Activate or Deactivate the report (Activation means that the users can access the report from other modules if they have required permissions).

Enter the name, title, headers, and footers.

The user can access to the User-Defined Reports with:

The Reporting Module with the Menu “My Reports”.

Other Modules with the Menu “Reports”.

The contents of Reporting