Versions Compared

Version Old Version 2 New Version Current
Changes made by

Lakshminarayanan1 S CTOO

Lakshminarayanan1 S CTOO

Saved on

Key

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

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 amount values within brackets in reports. In the following sample report you can notice that the negative values in the TOTAL column are wrapped within brackets.



To enable the negative numbers amount values in reports 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: In the Sigma-amountformats.xml file on the SigmaResources.jar, present in your Sigma Application WAR (sigma.war\WEB-INF\lib\SigmaResources.jar), specify the negative sign position as “WRAP” for the required currency format. The following code segment of Sigma-amountformats.xml shows the negative sign position attribute as WRAP for the Indian Currency Format:

    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>




  2. Once you make save 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

    Only for the PDF, HTML and DOCX formats, the negative numbers The negative amount values can be wrapped within the brackets .in PDF, DOCX, and HTML reports only



  4. Access the Sigma Application and click the Preferences option (top-right corner) to select the relevant amount or currency format, e.g. Indian Currency Format.



    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.



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



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



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

...