In Bold Reports, data bars offer a powerful way to visually represent data values within report cells, enabling quick insights into trends and comparisons. Configuring the maximum and minimum values of data bars is essential for accurate scaling and meaningful data representation. By using expressions in the Bold Report Designer, you can dynamically adjust these values to align with your dataset’s range and context, ensuring clear and effective visualizations.

This guide offers step-by-step instructions to help you set up data bar maximum and minimum values for enhanced report clarity and precision.

Steps to Adjust Maximum and Minimum Values for Data Bars

1. Open Bold Report Designer

   • Launch the Bold Report Designer and open the report that contains the data bar you want to configure.
     
     

2. Access the Properties Panel:

   • Access the Properties panel to modify the settings of the selected data bar.
   • Navigate to the Horizontal Axis section in the Properties panel.
   • Here, you will find the options for Maximum Value and Minimum Value.
     
     

3. Set Expressions for Positive-Valued Data Bars (e.g., Gains):
   To dynamically scale the data bar based on your dataset:

   • Click the small square next to the Maximum Value and Minimum Value fields to use expressions that dynamically scale based on your data.

   • Use the following expression for Maximum Value:
     

     

     =Max(Abs(Fields!YourFieldName.Value), "YourDatasetName")
     

   • This ensures the maximum value reflects the largest absolute value in the specified field.

4. Set Expressions for Negative-Valued Data Bars (e.g., Losses):
   To properly scale negative values:

   • Use the following expression for Minimum Value:
     
     

     =-Max(Abs(Fields!YourFieldName.Value), "YourDatasetName")
     

   • This sets the minimum value to the negative of the largest absolute value, ensuring proper scaling for negative values.

5. Save and Preview the Report
   

   

You can download the above sample report from here.

See Also

• Finding the Maximum Value from a LookupSet in Bold Reports using Custom Code