How to: |
A structured ad hoc form (SAF) is a parameterized report that allows you to select fields and options that participate in a report at run time. Fields and options that have been added to the SAF are displayed in controls and are available for selection. Selecting fields from controls and running the report will display the data that correlates to the field values. You must add a parameter to a report to make it a valid SAF.
These procedures assume that you know how to create a parameterized report using HTML Canvas or HTML Composer. For more information on how to create a parameterized report refer to the App Studio Help or Developer Studio documentation.
WebFOCUS App Studio enables you to create structured ad hoc forms using the HTML canvas.
If this is a new work session or if you are required to sign in on every attempt to access the server, the local host sign in dialog box opens. Enter the User ID and Password for the WebFOCUS server.
If this is a new work session or if you are required to sign in on every attempt to access the Reporting Server, the Reporting Server sign in dialog box opens. Enter the required User ID and Password.
The Environments Tree pane resembles the following image.
The wizard closes, and HTML canvas opens, as shown in the following image.
Your report appears in the container on the HTML canvas, as shown in the following image.
For more information on how to create reports, see Creating Report Queries With InfoAssist.
The Filter Options dialog box opens, as shown in the following image.
The New Parameters dialog box opens, as shown in the following image.
A dialog box for the new parameter appears above the report on the HTML canvas, as shown in the following image.
The Save As dialog box opens.
The name of the new report appears on the HTML canvas.
The Style Composer dialog box opens.
When your selections are complete, the Style Composer dialog box will resemble the following image.
The frame is now hidden. You can make it visible by using the Visibility command, on the Utilities tab, in the Miscellaneous group, as shown in the following image.
Note: It is recommended to keep the frame hidden when running an HTML form in Excel through the Quick Data add-in, to avoid displaying a prompt with an empty frame alongside an active Excel workbook.
Note: If you want to use an existing procedure with the Quick Data add-in, you must set the format in the procedure to Excel.
WebFOCUS Developer Studio enables you to create structured ad hoc forms using its HTML Composer pane.
The Select Template window closes, and the HTML Composer opens, as shown in the following image.
The Get Source file dialog box opens, as shown in the following image.
Your report appears in the container on the HTML Composer, as shown in the following image.
The Filter Options dialog box opens, as shown in the following image.
The New Parameters dialog box opens, as shown in the following image.
A dialog box for the new parameter appears above the report on the HTML Composer, as shown in the following image.
The Report Frame disappears, as shown in the following image.
Once you hide a frame, you can make it visible on the HTML Composer toolbar by clicking the Visibility toggle button, as shown in the following image.
WebFOCUS |