Versions Compared

Version Old Version 1 New Version 2
Changes made by

Lakshminarayanan1 S CTOO

Lakshminarayanan1 S CTOO

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Wrapping Negative Numbers in Reports

Sigma enables you to wrap the negative numbers, displayed as data sets in your functional reports. A sample screenshot of the report is provided as follows, in which the negative numbers are displayed within the wrapped brackets.
Anchor_GoBack
_GoBack Image Removed
Image Added

To enable the negative numbers to be displayed within the wrapped brackets for the data sets of your functional reports, perform the following steps:

  1. In the Sigma-amountformats.xml file on the SigmaResources.jar, present in your Sigma Application WAR folder (e.g. D:\Canvas\apache-tomcat-10.0.18\webapps\sigma\WEB-INF\lib\SigmaResources.jar), specify the negative sign position as "WRAP" for the relevant currency format of your choice, e.g. Indian Currency Format, as shown in the following sample code snippet and the screen shot:

...

  1. Code Block
    languagexml
    <?xml version="1.0" encoding="UTF-8"?>
<canvas-formats type="amount">
	<format Id = "SouthAfrica" description = "SouthAfrica Currency Format" negativeSignPosition = "PREFIX"
		groupSeparator = " " decimalSeparator = "," groupSize = "3" leadingGroupSize ="3" 
		formatter-class = "com.intellectdesign.modelhouse.pref.CustomerAmountFormatter" 
		canOverride = "true" isEnabled = "true"/>
	<format Id = "USA" description = "US Currency Format" isEnabled = "false"/>
	<format Id = "INDIA" description = "Indian Currency Format" isEnabled = "false"/>
	<format Id = "###,###,###,###,###.###" description = "US Currency Format"
		groupSeparator = "," decimalSeparator = "." groupSize = "3" negativeSignPosition = "PREFIX"
		leadingGroupSize = "3" isEnabled = "true"/>
	<format Id = "#,###.##" description = "Indian Currency Format"
		groupSeparator = "," decimalSeparator = "." groupSize = "3" negativeSignPosition = "WRAP"
		leadingGroupSize = "2" isEnabled = "true"/>
</canvas-formats>


    Image Added

  2. Once you make the appropriate changes to the Sigma-amountformats.xml file, proceed to restart your app server.

  3. Configure the report as per your needs and requirements in Sigma Studio.

    Note:

    Note

    Only for the PDF, HTML and DOCX formats, the negative numbers can be wrapped within the brackets.

...

  1. Image Added

  2. Access the Sigma Application and click the Preferences option to select the relevant amount or currency format, e.g. Indian Currency Format.

...


  1. Image Added

    1. Click the Amount drop-down list to select the relevant amount or currency format, e.g. Indian Currency Format.
    2. Proceed to click Update to update the Preferences in Sigma Application.

...


  1. Image Added

  2. Access the configured report and click the Run option to generate the report.

...


  1. Image Added

  2. Download the generated report in the selected PDF format.

...


  1. Image Added

    The fetched data of the downloaded PDF report displays the negative values for the numbers, within the wrapped brackets, as shown in the following screen shot:

Image RemovedImage Added