Example: Set Parameters for Reports

This example discusses creating a button on AP Transaction Entry that, when clicked, will open the AP Transactions by Vendor report parameter setup form (the Crystal Reports Launcher).

This setup will specify one vendor for the vendor range parameters.
  1. On the Info tab in VA Custom Form Buttons, create the custom form button. Make sure to specify AP Transaction Entry as the form you are placing the button on, and the AP Transactions by Vendor report in the Action field.
  2. On the Parameters tab, in the Parameter ID field, enter a + to create a new entry and have the system automatically assign the next available ID number.
  3. In the Name field, press F4, select the ?BegVendNumber parameter, and select OK.
  4. Select 3-Form Input value from the DefaultType dropdown.
  5. In the DefaultValue field, press F4, select the field name that contains the value that the report will default in its parameter field, and select OK. In this example, select Vendor from the F4 lookup.
 The system defaults the field’s sequence number in the DefaultValue field. In this example, the sequence is 15.
  6. Repeat steps 4 – 6 for the Ending vendor number. Select the ?EndVendNumber parameter in the Name field.
  7. Save the record.
  8. Open the AP Transaction Entry form and move the button to a new location, as necessary.
  9. In AP Transaction Entry, enter transaction details, including the vendor number.
  10. Click the custom form button.

The AP Transactions by Vendor report parameter setup form appears with the vendor specified in the Vendor field in AP Transaction Entry in the beginning and ending parameter fields.