Enhancement Points
Suppress Report line
Zero value before conditional formatting
Zero value after conditional formatting
Ignore Suppress Report line having Zero Value
Exclude column from formula calculation in Report Line
Ignore column conditional formatting for specific Report Line
Suppress report line line
Vienna Introduce two new column as a checkbox with the name "Suppress line (Zero value before conditional formatting)” and "Suppress line (Zero value after conditional formatting)” On Report Header tab as mentioned in below image
...
When the User will checked the checkbox “Suppress line (Zero value after conditional formatting)" then the system will check all the rows where all columns contain ZERO value after conditional formatting applies on the report line and suppress all those line from the report.
...
Ignore "Suppress Report Line having Zero value"
Vienna Introduce new column as a checkbox with the name "Ignore Suppress line" on Report Line tab as mentioned in below image:
...
When User want to show any report line where all the column contains Zero value then user can select the "Ignore Suppress Line" as true on report line, then system will ignore the setting "Suppress Line (Zero value before conditional formatting)” or "Suppress Line (Zero value after conditional formatting)" which is selected as true on report header.
...
Exclude Column from Report Line Formula Calculation
When the Report line is created with the Line type "Calculation" then system showed "Formula Grid". In Formula Grid, Vienna introduce a new column as "Exclude for Column" whose reference type is Multi-serach.
...
➤ Column 4 = (Row 1 + Row 2) * 2.00 + 500.00
...
View Formula :
System provide the functionality to view formula calculation.
...
When User click on “View Formula”, system will open the View Formula popup where user can see formula for respective column based on defined formula setting.
Ignore Conditional Formatting in Specific Report line for Columns
Vienna introduce a new column as "Ignore Column Conditional Formatting" whose reference type is Multi-serach on Report Line. In the Ignore Column Conditional Formatting field,system will show all the report columns.
...