Reports Builder

Inbuilt reports builder for Admiro

Admiro provides an inbuilt reports builder for your project that enables you to setup quick and basic reports for your project

You will see a list of all your Appgini tables on the left. If you click on any of the tables you will be able to see the reports associated with the table and you can be able to edit any of the desired reports

Creating A Report

Once you click create reports button, you will be presented with a modal to start creating a report.

Here are the important report parameters to note:

Report name- The name of the report you are creating
Label Field- The field which you want to create a summary upon
Label Field Alias- The name that will be shown on the report table for the label Field
Label Field Summary Title- The name that will shown on the report table for the summary/value of the Label field
Label field is a lookup field? - This prompts you to confirm if the label field you selected is a lookup field. If YES, then you will be prompted to select the parent table and the parent field that we will perform summary on.
Label field is a date? - This prompts you to confirm if the selected label field is a date, if YES, then you will be prompted to select the date format to be used the the report. eg: Month Name, Year, Full Date
Summary - This is the type of summary you want to be performed on the label field. Values: Count, Sum, Maximum, Minimum
Label Field operator- This is the operator to be used in the report generation
Groups that can access the report. You can enter * for all groups or, provide a comma separated list of groups to access this report
Include date filter, If YES, then you will be prompted to select the date field to be used for this report.
Include Bar chart- If selected then a bar chart summary will also be included in the report.
Include Donut chart- If selected then a donut chart will be included in the report
Include pie chart- If selected then a pie chart will be included in the report
Report card size- provided the bootstrap size class of the report card on the reports home page
Report card color- The color for the report card on the reports home page
Data table records per page- specifies the total number of records to be displayed per page on the report data table
Custom where- You can provide your custom condition to customize your report outcome further.
Show records based on user permissions- This limits records displayed based on roles and permissions specified in your app.

PreviousCustom Page Builder NextTranslation Tool For Admiro

Last updated 2 months ago

Creating A Report

Once you click create reports button, you will be presented with a modal to start creating a report.

Here are the important report parameters to note:

Report name- The name of the report you are creating

Label Field- The field which you want to create a summary upon

Label Field Alias- The name that will be shown on the report table for the label Field

Label Field Summary Title- The name that will shown on the report table for the summary/value of the Label field

Label field is a lookup field? - This prompts you to confirm if the label field you selected is a lookup field. If YES, then you will be prompted to select the parent table and the parent field that we will perform summary on.

Label field is a date? - This prompts you to confirm if the selected label field is a date, if YES, then you will be prompted to select the date format to be used the the report. eg: Month Name, Year, Full Date

Summary - This is the type of summary you want to be performed on the label field. Values: Count, Sum, Maximum, Minimum

Label Field operator- This is the operator to be used in the report generation

Groups that can access the report. You can enter * for all groups or, provide a comma separated list of groups to access this report

Include date filter, If YES, then you will be prompted to select the date field to be used for this report.

Include Bar chart- If selected then a bar chart summary will also be included in the report.

Include Donut chart- If selected then a donut chart will be included in the report

Include pie chart- If selected then a pie chart will be included in the report

Report card size- provided the bootstrap size class of the report card on the reports home page

Report card color- The color for the report card on the reports home page

Data table records per page- specifies the total number of records to be displayed per page on the report data table

Custom where- You can provide your custom condition to customize your report outcome further.

Show records based on user permissions- This limits records displayed based on roles and permissions specified in your app.