How to Format Decimal Values in Bold Reports

Bold Reports is a powerful reporting tool that allows users to create and customize reports for a variety of purposes. One common use case involves formatting decimal values in reports. For instance, users may want to show decimal values as whole numbers without extra zeros. This article provides a step-by-step guide on how to achieve this formatting requirement in Bold Reports using expressions within your report dataset fields.

1. Identify the target cell
   Identify and select the tablix cell to which you want to apply the formatting. This cell should be bound to the dataset field containing the decimal values.
   
   
2. Define the Expression
   Click on the expressions menu to open the expression builder. In the expression editor, enter the following expression to define the field value.
   
   

=IIF(Fields!YourDecimalField.Value = Floor(Fields!YourDecimalField.Value), Format(Fields!YourDecimalField.Value, "0"), Format(Fields!YourDecimalField.Value, "0.00"))

3. Save and Preview the Report
   After applying the expression and formatting, preview the report to ensure that decimal values are formatted as expected.
   
   

By utilizing expressions, formatting decimal values in Bold Reports is a simple process. These formatting options can enhance the visual presentation and efficiency of reports, ensuring that numeric data is displayed clearly and effectively.