Assume you need to create a new report, which will display information on contractors, industries and users responsible, on the Reports tab of ELMA Designer. The following objects will be used: Contractor, User and Industry.
The "User Responsible" will be used as a parameter (type: User, link: Single).
SQL solution
Add the request text to the SQL data source on the Data Sources tab (fig. 1).
Fig. 1. SQL request
The Contractor table contains information on contractors (name, industry and responsible), and the User table contains information on the system users. Each user in the table has a unique ID, stored in the Id field.
Link the User table with the Contractor table via the Responsible field of the Contractor table with the Id field of the User table. It is necessary, because we need the report to show the full name of the employee in the Responsible field, instead of their ID.
Link the ContractorIndustry table with the Contractor table via the Industry field of the Contractor table with the Id field of the ContractorIndustry table. It is necessary, because we need the report to show the industry name in the Industry field, instead of its ID.
Next, add the data to the layout on the Report Layout tab, rename the required columns and start debugging to preview the result.
To display the report in Web Application, save and publish it, and assign access permissions to users, if necessary. The system administrator assigns the permissions in Administration – Users – Access Settings – Reports.
