Using custom formulas in process reports

Using custom formulas in process reports

Sometimes when designing a process report you need field to show the value of a calculation, a specific option or a combination of options. In order to do this you must use specific syntax so that the report engine understands what you want it to do.

To add a column that displays a specific option value

  1. Click the [ ] button. This will add a new item called [option] to the bottom of the list of fields.
  2. Double-click on the new field and replace the "option" with the name of the option you want to dispaly. For example to show the mount you would change [option] to [mount].

To add a column that displays a combination of options

  1. Perform the same steps as above to add a new option column.
  2. At the beginning of the field add a ~. This tells the report engine to treat the rest of the text in this field like a formula.
  3. Build your combination of options. Use + to combine options and insert text using the " character.

Important

When using the ~ the option names must be enclosed with the " character. For example - [Width] must be added as "[Width]". To combine width and height use the formula: ~"[Width]" + " x " + "[Height]"

To add the value of a calculation of non-option fields

  1. Click the = button. This will add a new item called =CCur(UnitPrice) to the bottom of the list of fields.
  2. Double-click on the new field and edit the formula as needed.

Note

  • Make sure the formula starts with the = character.
  • Text fields must be in the format CStr(field).
  • Numeric fields must be in the format CCur(field) for currency option or CLng(field) for whole numbers.

Important

  • You cannot use options and non-option fields in the same formula.

Other notes

  • You can only use formulas and options in the line items section of a report.

Applies To: 

  • SalesPRO Software

    • Related Articles

    • Using the Reports Center

      Summary Solatech Focus and DOS users have the ability to run reports from their system. The types of reports available will vary by user type. In this knowledge base article, we will describe how to run, view and export reports that can be opened in ...
    • Running Reports

      More Information These navigation and entry instructions may not be the only way to complete the desired task.  For more in-depth explanations, any related articles will follow the instructions as links. Steps From the Reports tab on the main ...
    • Setting up Process Reports and Email Templates

      Summary Account Administrators can setup multiple versions of Process Reports that can be printed, previewed or emailed to customers or other users. This knowledge base article will describe how to setup and use process report templates Accessing and ...
    • How to Modify Process Reports in SalesPRO

      Summary This article will explain how to tailor delivered Process Reports for your company-specific information.  More Information There are common sections defined as tabs in the Modify Report Layout window.  Not all will apply for every report. ...
    • How to Add Sales Rep E-mail and Telephone Number to Process Reports

      Summary This article provides instructions on how to add individual sales representative's e-mail and telephone numbers to process reports (quotes, orders, etc.) More Information To add this data, you must be running SWCS version 4.2.0.456 or higher ...