How to put condition editor in Format like drawing line/or font colour

Created by Cheng Kah Poh, Modified on Thu, 4 Apr at 10:13 AM by Cheng Kah Poh

Scenario:


Expected Outcome:


Solution:


Step 1 - Press Detail1 > click Properties> Press 3 dot Button of Formatting Rule.


Step 2 - after Press 3 dot Button of Formatting Rule, below screen will prompt out > then Press Edit Rule Sheet.



Step 3 - After Press Edit Rule Sheet > Press green colour + button.



Step 4 - Follow Below Screen insert value


Condition : [Stock].[Stock #]=='SUBTOTAL'


Formatting : Borders = Top, Border Dash Style = Solid, Font = [Font: Name=Microsoft Sans Serif, Size=8.25, Units=3, GdiCharSet=0, GdiVerticalFont=False], Foreground Color = Black


Step 5 - then scroll down, give a name to this formatting rule, any name user like, then press close


Step 6 - after add new formatting rule, new rule will appear like below, at this screen, Press Cancel 1st.



Step 7 - Look for the column which you want to apply, Example for this case, we require draw line for Taxable Column, Tax, Amount, and Net Amount.


Step 8 - Press Taxable column 1st > then press 3 dot button of Formatting Rule.


Step 9 - Select the rule then Press move to right Button.


Before


After


Then Press OK.


Same Step apply to others Column which require Bold and Draw line


then Save the Format



Result



If User even wants to Color to Subtotal Wording.

like this:


User can add another New rule like above step


Condition: [Stock].[Stock #]=='SUBTOTAL'


Formatting: Foreground Color = Blue


Then may apply to Stock Code Column and Description Column


With Rule Apply Button to Stock Code Column and Description Column


Then Save the Format.

Thanks!


** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article