CCNC/CCNC Module 5/Creating reports/Basic Reporting

---

The reporting wizard

Outcomes

Upon completion of this tutorial the learner will be able to: Create a report using the report wizard describe the differences between static and dynamic reports

Using the wizard to create a report

Figure 1. Reports dashboard

The OpenOffice Base toolbar has a button that can be used to view all the existing reports. Press the Reports button on the toolbar to have the Reports main screen appear.

Figure 2. Report wizard task

The Reports main screen has one task that will start the Reports Wizard. A feature of reporting that is different than other features of the OpenOffice Base is that Static and Dynamic reports can be created. The Static report captures the report for a given point in time. So every time you open a static report it displays the results based upon the data in the database when the report was first run. The Dynamic report displays the results based upon the data in the database at the time the report is run. With a dynamic report if the report data in the database changes daily so will the report.

Test your knowledge

Starting the report wizard

1. The OpenOffice 2.0 Base reporting has two available tasks? TRUE → Incorrect, only one task is available. Click here to review the topic. FALSE → Absolutely Correct! 2. A static report will display. (a) All the static data in the database → Incorrect, it reports the data when the report was first run. Click here to review the topic. (b) A list of the static query parameters → Incorrect, it reports the data when the report was first run. Click here to review the topic. (c) The data for a when the report was first run → Absolutely correct! (d) The data for each time the report is run → Incorrect, it reports the data when the report was first run. Click here to review the topic. (e) None of the above → Incorrect, it reports the data when the report was first run. Click here to review the topic. Your score is 0 / 0