Selecting database queries
About selecting database queries
A key component of a report definition is the database queries that define the type of information presented in the report. ContentReporter has 45 pre-defined database queries that are available for most types of reports. The queries available for a report definition are listed on the Query tab of the Report Definition Properties window.
About the Query tab in the Report Definition Properties window
The Query tab contains a listing of all queries available to you for your report definition.
Note
You can only see the queries your account has permissions to access.
Selecting queries by categories
Use the following steps to assign a pre-defined category of queries to a report definition.
Step
|
Action
|
|---|
|
1 |
In the Report Definition Properties page, select the query tab. In the drop-down box at the top of the Available Queries column, select the query category you want to select individual queries from. In the example below, the Streaming Category is selected.
|
Selecting database queries
To attach a database query to your report definition, follow these steps.
Step
|
Action
|
|---|
|
1 |
In the Report Definition properties window, click on the Query tab.
|
|
2 |
In the Query tab, select the category of queries you want displayed in the Available Queries panel. You can view a different category by clicking on the drop-down box. As you select different categories in the upper field, the lower panel dynamically changes to display available queries.
|
|
3 |
To add one or more queries to a Report Definition, select the appropriate category from the upper Available Queries drop down list, select the query (or select multiple queries by holding down the Ctrl or Shift keys) from the Available Queries panel, and click the >>> (Select) button.
Result:
The query or queries appear in the right-hand Selected Queries panel.
|
|
4 |
To remove one or more queries from a Report Definition, select the query (or select multiple queries by holding down the Ctrl or Shift keys) from the right-hand Selected Queries panel, and click the <<< (Remove) button.
Result:
The query or queries no longer appear in the right-hand Selected Queries panel
|
|
5 |
Complete the report definition by clicking on the OK button at the bottom of the screen.
Result:
The report definition is completed and listed in the Report Definition tab.
|
About the Missing or Invalid Information dialog box
If you have not completed the schedule information correctly, a dialog displays listing the missing information.
About immediately processing (running) a report after you create a report definition
Once you have created a report definition to process a report, you can run it immediately by selecting the definition and pressing the run button.
Copyright © 1994-2001, Network Appliance, Inc. All rights
reserved.
Part No. 210-00067
File: cr30rgc7.htm
Last updated: 12/07/01 18:12:46