Intro to the Data Source View

From NeoWiki

---

Revision as of 00:10, 1 November 2007

Reports and Forms are actually Writer documents stored within the odb file of your database. But you can also access the data in registered databases from Writer documents that are not stored within the odb file. This tutorial discusses some of the ways to access and use this data.

Registering The Database

In order to access data in from Writer, the database must be registered. When you create a new database, the Database Wizard asks if you want to register the new database. Under normal conditions, you want to check Yes. If you accidently checked No, or if you have received an odb file from someone else, here's how to register the database:

1. In the NeoOffice menu, choose Preferences
2. Double-click on NeoOffice Base to disclose the sub-categories
3. Click on Databases. You will see a list of registered databases.
4. Click the New... button. The Create Database Link window appears
5. Click the Browse... button and navigate to the database file you want to register.
6. If desired, you may give it a Registered name different than the file path.
7. Click OK in the Create Database Link window.
8. Click OK in the Options-NeoOffice Base-Databases window.

Accessing the Datasource

1. In an open Writer, document, click on the Data Sources button on the Standard Toolbar, or go to the View menu and select DataSources. The Data Source View opens just below the toolbars, above your document.
2. Make sure that the Table Data Toolbar is visible at the top of the Data Source View. It is the toobar that is circled in the image below: