Report Parameter Forms

See Also

Report parameter forms are html screens that allow the user to set parameters to restrict the report that is being printed.  Parameter forms are optional, and can be set up at the report template level if a standard parameter form is desired.

Fields on parameter forms have many of the same options and properties as the fields set up for screens in that they can be set up as buttons, checkboxes, images, etc. They are used to restrict the output of the report.  There are two ways in which this is accomplished.  

The Target Column property for the field can be set to a specific column for a database block on the report.  When the report is run, if a value was entered in the field, that block will be restricted by the value entered.

Fields without target columns can be defined to set global values by which the report will be restricted.  These global values are set when the Run Report button is pressed by the user.  In order for the report to be restricted by the values, the where clause of the database block on the report must be set up to restrict the data by the global values.

Fields on parameter forms should always be set up with the From Database field set to false.  

Report parameter forms should also always have one button on the block that will run the report.  This button should be set up with the Type of Text, and in the On Mouse Click property, ExecuteReport(); should be entered.  When this button is pressed, the restrictions for the fields on the parameter form are set, and the report is generated.