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 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 ...
    • 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 ...
    • Recent Articles

    • Microvellum Release Notes | Build 25.2.0206.641

      The following release notes apply to Microvellum build 25.2.0206.641. Item Number Fix An issue was reported regarding item numbers in composite drawings. Users who processed work orders with multiple products reported that the item numbers would ...
    • Microvellum Release Notes | Build 25.2.0204.641

      The following release notes apply to Microvellum build 25.2.0204.641. Toolbox Brand Retirement As part of Microvellum’s ongoing alignment with the values and catalog of INNERGY, and to improve user experience, clarity, and consistency, we have ...
    • MDF Door Profile Guide

      Door Wizard The Door Wizard is a Microvellum feature that enables users to interact with and control the specifics of door related variables, prompts, and available settings. The options available in the door wizard vary depending on the specific ...
    • Microvellum Foundation Library Release Notes | Build 26.0112

      Additions In accordance with Microvellum's new subscription changes, all Face Frame Expansion products and subassemblies, as well as the Range Hood Master product have been added to the full library install and library update zips (now included with ...
    • Toolbox Release Notes | Build 25.2.0114.641

      The following release notes apply to Toolbox build 25.2.0114.641 Processing Center Message Fix Fig. 1: An error message running in the background of the software. An issue was reported within the Processing Center. When processing an order, there ...