Example report

Once the Report Designer application is installed, to check whether everything is OK and to acquaint yourself with its interface and features, it is recommended to install example report definitions DEPARTMENT. To do so, open the application, click the toolbar button Report definition actions > Import

and select file Report Definition - DEPARTMENT.xlsx

Then select Report Code = DEPARTMENT, click on tab Report Templates, and for the Component with name “word template” click the link Upload new. In opened dialog select file department.docx and click Upload:

Now try to create a report by clicking the toolbar button Generate & Download, entering Department Id = 90 as the first report parameter, and clicking Download Report:

If

• you have successfully installed Report Designer
• owner of Report Designer schema has access to HR schema tables. The access can be granted by SQL*Plus commands:

  grant select on hr.departments to report_designer;

  grant select on hr.employees to report_designer;

• HR schema contains tables DEPARTMENTS and EMPLOYEES with preinstalled demo data from Oracle

then file “department & employees.docx” will be generated and downloaded with content as below: