In this section: How to: |
Reporting Objects are stored in folders in the Repository at any level except the root. They can include selection criteria (WHEREs), JOINs, virtual fields (DEFINEs), filters, and other WebFOCUS statements, as well as reports or graphs supplied as templates.
The New Folder dialog box appears, as shown in the following image.
Note: If you do not select a server or an application path, each will be set to the default server and application paths for your Developer Studio client. For more information, see the Managed Reporting manual.
The New Reporting Object dialog box appears, as shown in the following image.
The Look in location is set to the folder you selected, although you can change it to another location.
The WebFOCUS Table List dialog box appears, as shown in the following image.
Note: Depending on your environment, you may be prompted for WebFOCUS Server credentials when you click the File button.
The Data Server tab allows you to manage the data server and the application path settings from which the Reporting Object retrieves information.
The Reporting Object tool appears, as shown in the following image.
Note: Depending on your environment, you may be prompted for WebFOCUS Server credentials when you select the Create button.
By default, the data server, which defines the Reporting Object, is the same data server from which it is accessed by users. However, you may wish to create a Reporting Object, which draws upon limited information from another data source, for example, to allow Sales managers to combine inventory information with personnel information to determine personnel performance.
To set a different data server for a Reporting Object:
If the Reporting Object already exists, right-click the object and select Properties, then click the Data Server tab on the dialog box that appears.
To view or edit the properties of a Reporting Object, right-click the object and select Properties. The Reporting Object Properties dialog box opens, as shown in the following image.
In the Properties dialog box, the General tab displays the parent folder (location), file name, size, status, and run option of the object, along with the user and date of the creation, last access, and last modification of the object. You can also edit the object description and name and enable the following options:
Prompt for Parameters determines whether or not users will be prompted for parameters (values) when they create reports or graphs. This is selected by default.
If prompting is enabled globally, then, even when this option is not selected, you will still be prompted for any unresolved variables. These unresolved variables can be resolved by using the defaults or by passing them on.
Note: If you create a graph with an optional parameter, you must clear the Prompt for Parameters option. If you do not clear the Prompt for Parameters option, you will be prompted, at run time, to select the optional parameter.
The Data Server tab allows you to manage the data server and the application path settings from which the Reporting Object retrieves information. The Data Server tab is shown in the following image.
To change the server, check Server and select one of the available servers. Move application paths from the Available box to the Selected box by double-clicking them or by selecting them and using the movement arrows. Use the up and down arrows to change the preferred order of the application paths.
The Summary tab, as shown in the following image, allows you to enter a brief description of the Reporting Object.
WebFOCUS |