Custom format?

danni

Hello,

When I try to make a custom format on a string nothing happens?

I have a string "xxxxxxxxxx" I want to change to "xxxxxx-xxxx". I right click on the reportobject and press format. Then Custom format.

AlexTZ

Hello,

Custom format uses String.Format() function to format a value. It cannot format string-type value.
You may use custom function to return a formatted value. Add the following code to the report script:

    private string FormatMask(string value, string mask)
    {
      MaskedTextProvider pro = new MaskedTextProvider(mask);
      pro.Add(value);
      return pro.ToString();
    }

Use in the Text object:
[FormatMask("1234567", "000-0000")]

StevenSun

AlexTZ wrote: »

Hello,

Custom format uses String.Format() function to format a value. It cannot format string-type value.
You may use custom function to return a formatted value. Add the following code to the report script:

    private string FormatMask(string value, string mask)
    {
      MaskedTextProvider pro = new MaskedTextProvider(mask);
      pro.Add(value);
      return pro.ToString();
    }

Use in the Text object:
[FormatMask("1234567", "000-0000")]

Can I pass a table field(Employees.FirstName) as the first parameter to the function FormatMask(value, mask) ?

AlexTZ

Hello,

Sure:
[FormatMask([Employees.FirstName], "000-0000")]

StevenSun

AlexTZ wrote: »

Hello,

Sure:
[FormatMask([Employees.FirstName], "000-0000")]

Thanks !
Your help is very useful.