To prompt the user for values, click Layout | Report Parameters... Once Clicked, Data Access Studio will open the Report Parameter Designer as follows:
The Data Access Studio shows the Designer in the region above your Layout grid. You can resize the height of the Report Parameter Designer by clicking the splitter line between the Designer and the Layout grid.
|
To |
Do this |
|
Add a filter parameter from your Layout Grid |
Click on the Column Header of any column in your grid. Drag the column to the Report Parameter Designer window. Drop the column on the Report Parameter Designer. |
|
Add a parameter manually |
Click an empty cell beneath the Name column. Enter the name for your parameter. Tab out of the Name column. Select an editor that is appropriate for your parameter. If you have a Date parameter, select a Date editor, etc. For each type of editor you select, modify the properties of the editor to best match your parameter. |
|
Organize the top-down order of your parameters |
Click the Grip Bar for any parameter row. Drag the row to the desired location. Drop the row on the desired location. |
|
Delete a parameter |
Highlight one or more parameters. Click
|
|
Close the Designer and show the Prompt screen |
Click |
Once you design your parameters, you can also connect the parameters to certain calculations. See Connect a Report Parameter to a Calculation for more information.
