Building and Maintaining Smart Reports

this functionality is intended to customize reports with the required functionality data customize reports with the required functionality data , without the need for new updates or additional software before getting started it is necessary to have access permission; to use the designer, it is necessary to define the name of the schema database from the parameter 32 (eg public ) it is necessary to have knowledge in standard query language ( sql ) to create or manipulate reports procedure access the functionality through the main menu reports > smart reports > smart report creator ; click on " new "; complete the necessary fields define the type sql sql create a sub report " sql " (this type allows you to create reports that return the database information through a query) when selecting this option, it is necessary to also inform the type of report to be created, the business rule concerning it, the report designer, the parameter, and the script; rhinoscript rhinoscript to create a report that returns the information of the database through a " script ", it's necessary to select the " rhinoscript " type it will be necessary to choose the report type, define the parameters and describe the script; jps jps create a report with dynamic content when opting for this type, you must inform the parameters and the " jsp " script; neuro neuro create a report of " neuro " type, simply link a previously registered " neuro " form ; 📌 important ! to create a sub report (drill), the " report type " should be " pie chart " or " bar chart " 4\ define the module (functionality) where the report is being created will be displayed n/a n/a select this option if you want the report not to be displayed in any module; general general select this option to display the report in one or more modules, where you want the report to be displayed (configuration, incidents/requests, incidents/requests (chart), release, change, problem); specific specific select a single module where you want the report to be displayed (configuration, incidents/requests, incidents/requests (chart), release, change, problem) 5\ click on " save "; 6\ there is the possibility to also import a " report " therefore, click on " import " and link the file containing the information you want ⚠️ attention ! the reports created here will be displayed in the " smart reports " screen, where you can view the relevant data for each report