Using the string.Format Method in Report Designer

Using the string.Format Method in Report Designer

Most of the articles in this section of the Knowledge Base focus on using the Text Format tool, but the Text Format tool does have one drawback, which this article intends to remedy.

While the Text Format tool is beneficial in formatting an entire text object, it cannot format individual values within expressions. When formatting individual values within a text object is necessary, it is recommended to use the string.Format method. The string.Format method provides most of the same formatting options as the Text Format tool, but the string.Format method provides even more flexibility.

To use the string.Format method in a text component, select the text component for editing, and enter the expression in the text field.


Fig. 01 – string.Format Example

As an example, when the need to format a value as currency arises, use the C specifier:

Product Value: {string.Format(“{0:C}”, Value)}

In the case that Value is 100.00, then after formatting, the line prints as:

Product Value: $100.00

Formatting more than one parameter is permissible with the string.Format method.

Product Values: {string.Format(“value1 – {0:C}, value2 – {0:1}”, Value1, Value2)}

For more information about string.Format , see String.Format Method.


    • Related Articles

    • Understanding Text Formatting in the Report Designer

      The articles in this section of the Knowledge Base involve Text Formatting for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report from ...
    • Understanding Numerical Formatting in the Report Designer

      The articles in this section of the Knowledge Base involve Text Formatting for display in your reports. To learn more about Text Formatting and how to access this section within the Report Designer, see Understanding Text Formatting in the Report ...
    • Understanding Custom Formatting in Report Designer

      The articles in this section of the Knowledge Base involve Text Formatting for display in your reports. To learn more about Text Formatting and how to access this section within the Report Designer, see Understanding Text Formatting in the Report ...
    • Understanding Boolean Values Formatting in the Report Designer

      The articles in this section of the Knowledge Base involve Text Formatting for display in your reports. To learn more about Text Formatting and how to access this section within the Report Designer, see Understanding Text Formatting in the Report ...
    • Understanding Currency Formatting in the Report Designer

      The articles in this section of the Knowledge Base involve Text Formatting for display in your reports. To learn more about Text Formatting and how to access this section within the Report Designer, see Understanding Text Formatting in the Report ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.0430.641

      The following release notes apply to Toolbox build 24.1.0430.641. G-Code Path Fix An issue was discovered wherein G-code would sometimes not generate along the correct path, with files never being created in secondary folders, even in circumstances ...
    • Microvellum Foundation Library Release Notes | Build 24.0419

      Additions Added the new Blum SPACE STEP system. This can be activated within the “Toe Kick Assembly” construction option prompt in certain base & tall cabinet products. Added a new drawer system, the Harn Alunan T. Added 9 new Lamello Cabineo X ...
    • Toolbox Release Notes | Build 24.1.0416.641

      The following release notes apply to Toolbox build 24.1.0416.641. Maestro Toolfile Fix There was an issue with Maestro SCM Toolfiles reportedly experienced by some users, wherein the labels output by autolabeling would be in incorrect positions, an ...
    • Toolbox Release Notes | Build 24.1.0409.641

      The following release notes apply to Toolbox build 24.1.0409.641 Saw Delimited Processing Station Figure 1: The Saw Delimited option in a custom processing station. New options have been added to saw processing stations to allow for control over data ...
    • Toolbox Release Notes | Build 24.1.0328.641

      The following release notes apply to Toolbox Build 24.1.0328.641 Fillet Token Fixes Issues were discovered in the use of fillet tokens on products that also had the IRIB setting enabled: Some users processed work orders with rounded parts, which ...