Depending on the stored procedure you are using to generate a report, you’ll include the corresponding parameters from that stored procedure. If there are five parameters in your stored procedure, you’ll need to add five parameters to your report. Similarly, if there is only one parameter in the stored procedure, you’ll add one parameter to the report. 


The parameter names must match the names of those within the stored procedure. A default value can also be added for certain parameters. This can be useful when the value that is passed to the report is usually the same.  


Parameters are defined at the bottom of the report defintion form.


Report Parameter Definition




An example of created parameters can be viewed below. You see these by selecting the Parameters tab on the same form:


Viewing Report Parameters



The screenshot below shows a fully configured report with paramters.


Completed Report Configuration