Author: Paul Henriques in: Tutorials

Customize your Report Formatting

November 11, 2016
Customize your Report Formatting

One of OnRamp’s recently released features now allows users to customize and change the formatting within existing reports.

We will firstly look at Conditional Formatting using screen [S2305]. Conditional formatting gives users the option to add color to text and cells to highlight key data within the report.

With this tutorial, we want to know the extra inventory costs, below $5000, from the Inventory Detail Report [R1007].

1. To begin, open screen [S2305]and click the “Add” button in the bottom menu. From the drop down menu choose the report you would like to add the conditional formatting too.

Conditional Formatting using screen [S2305]

2. Enter a Sort number to determine the sequence, since you can add more than one item of formatting. Select the report column you wish to highlight, in this case, we are choosing the “Ext Cost” column.

Conditional Formatting Reports

3. Next select the formula you would like to use from the drop-down menu.

Conditional Formatting and Customization Reports

4. Enter the value in the Val.1 field. We have chosen the value of 5000.

5. Choose the color you wish to be used for the highlighting.

6. Next, choose if you would like the cell or the entire row to be highlighted.

7. In the last field, you can select if you would like the cell background to be highlighted or the text.

8. Now open the Inventory Detail report [R1007]. If you have it open already for reference, just click “Generate” to refresh the report view.

You will see that the formula and color you chose have now highlighted the data with a red background.

In our next issue, we will look at the “Report columns customization” feature of the Conditional Formatting and Customization Reports Screen.


  • Paul Henriques

    Paul Henriques is the current Manager for the Documentation and Training team at OnRamp Solutions Inc. Paul has over 15 years of experience in writing training material and documentation for various software companies. Having had to learn OnRamp ERP to better document it’s features and write training material; Paul is constantly stunned by the amount of thought that goes into each feature and the capabilities that are within the program, with features for all the various business units of a manufactory. Paul spends most of his free time keeping up to date on all the latest news and best practices for the manufacturing sector. Paul’s favorite manufacturing quote: “There is one rule for the industrialist and that is: Make the best quality of goods possible at the lowest cost possible, paying the highest wages possible.” – Henry Ford

Leave a Comment


Let Our Experts Answer Your Questions

For more information about how OnRamp ERP software can add value to your business fill in the contact form below. A member of our support team will contact you within 1 business day to discuss any questions you have.

    or call us now!
    +1 (905) 901-5020

    Start the collaboration with us while figuring out the best solution based on your needs.

    Head Office : 10114 ON-26 Unit 2, Collingwood, ON L9Y 3Z1 ,
    Location Icon
    View on Google map