Practical – 15
UNIT 3: Database Management System
Session 4: Creating Reports Using Wizard
AIM: Create Report using Wizard option in LibreOffice
Database.
Procedure:
i) Click on the category Reports in Database pane and
select Use Wizard to create Report… Option in the
Task pane.
In the Report Wizard:
ii) From Tables or queries drop – down, select the desired
table or query (In our example, let us select Assets),
add the desired fields in report list and click Next.
iii) If you wish, change the labels of the fields into more
readable forms as shown here. Then click Next.
iv) Select the fields to group the records on it by selecting
the desired fields and clicking on > button. Click Next.
v) You can sort the report output on the basis of one or
more fields on which report data should be sorted in
ascending or descending order. Here, data is sorted in
ascending order of Assets ID and Vendor ID and
Product price. Click Next.
vi) Choose a report layout and page orientation. Then,
click Next.
vii) Specify the Title of report as shown here along with
Dynamic report option under which, select Create
report now option. Finally, click Finish.
Result: