Operation Manual

Step 3: Grouping
Since we are grouping by the date, use the > button to move the Date field to the Groupings list.
Click Next.
Figure 262: Selecting fields for grouping data
Step 4: Sort options
We do not want to do any additional sorting.
• Click Next.
Step 5: Choose layout
Use Columnar, three columns for the layout.
1) Select Columnar, three columns for the Layout of data.
2) Layout of headers and footers has no possible selections.
3) Select Landscape as the Orientation for the page layout.
4) Click Next.
Figure 263: Report Builder template determined by the Report Wizard
Step 6: Create report
1) Label the report: Vacation Expenses.
2) Select Dynamic report.
3) Select Create report now.
4) Click Finish.
The report (Figure 264) has been created, but it needs some editing. The date could be formatted
better, and all the numbers need to be formatted as currency. It could use a heading that includes
its name, its author, and the date it was prepared. If the report had more than one page, the page
numbers could be put in a footer of each page, perhaps including the total number of pages. But to
do these things, you must use Report Builder.
264 | Getting Started with LibreOffice 5.1