Procedure:
Step 1 – Open Libre Office base
Step 2 – Create new database Database wizard → Create a new database → Next → Yes, register database for me → Open the database for editing → Click on Finish Button.
Step 3 – In save dialogue box, give the name Employee le. Select the location to save the database and click Save button. Now, the new database le Employeele.odb is created.
Step 4 – Create data tables From the left database pane, click on the icon Tables, and below the Tasks section, Click on Create Table in Design View. Database Pane → Tables → Create Tables in design view.
Step 5 – Enter the necessary field names and select appropriate Data Type. Save the Table in the name Tbl employee and close the window.
Step 6 – Create Report In the left Pane of the data base window, click on the Reports button and in right side, Under Tasks section click on Use Wizard to create a Report. This will open a Report wizard.
Step 7 – In Field selection step, under Tables Queries, Select the table Tblemployee. Then Press Add All buttons [>>] to all fields to report. Then click Next button.
Step 8 – Labelling fields (Skip this Step) → Next → Grouping Level (Skip this Step) → Next → In sort Option, Select Designation against sort by, and click Next button.
Step 9 – Choose Layout section, Select Tabular in the layout. → Click Next → In create Report Section → Give the tittle of Report as Report-Designation and select modify I Report Layout → Click Finish button.
Step 10 – Report Design window, click on Page Header area → Insert → Report controls → Label eld to insert a Header for the report
Step 11 – Double click on the Label Field inserted and in the property window edit the Label as “Designation List of Employees” and Press Enter.
Step 12 – Click on Execute Report button to view the Report.
