Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Conditional format....limitations?

Report design issues and solutions.
Post Reply
gazmoz17
User
User
Posts: 112
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Conditional format....limitations?

Post by gazmoz17 » 07 Jun 2024, 09:59

Hi,

Can you conditional format on anything?

Im trying to format colour background.

if COMPONENT.STOCK_CAT = 60 OR COMPONENT.STOCK_CAT = 30
then
begin
TextStyle->Italic := True;
TextStyle->FontName := "Sitka Text";
Background := Solid
Colour("Transparent");;
TextStyle->Size := 9;TextStyle->Color := NamedColor("Black");;
end

The above is my expression everything was working correctly until ive guessed the
synatx to add the border colour condition:

Background := Solid
Colour("Transparent");;

Thanks
Gareth

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4652
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Conditional format....limitations?

Post by brucedenney » 07 Jun 2024, 11:02

The border is not an option.

The available options are shown in the wizard.
Untitled.png
However, you could add a text box around the subject and then suppress printing with a conditional format to get the result you are looking for.
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

gazmoz17
User
User
Posts: 112
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: Conditional format....limitations?

Post by gazmoz17 » 07 Jun 2024, 11:21

Hi Bruce,

Thanks for the quick reply much appreciated 👍

So its literally only options below the expanded "Text Style" menu only?


if COMPONENT.STOCK_CAT = 60 OR COMPONENT.STOCK_CAT = 30 then
begin
TextStyle->Italic := True;
TextStyle->FontName := "Sitka Text";
TextStyle->Color := NamedColor("Gray");;
end
Current conditional formatting.PNG
That is my current conditional formatting. This is a BOM report (the source material/primary BOM is always component 1, later components are Packaging (Cat 60 Pails. Cat 30 Labels). I wanted the primary feedstock (component 1) to stand out with dark grey fill. By having standard formatting dark grey fill.
Extract.PNG
If cant be done with work around I'll just leave as is.

Many Thanks
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4652
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Conditional format....limitations?

Post by brucedenney » 07 Jun 2024, 11:30

No

You can use all the attributes exposed eg suppress print.

Background colour is one of the options, not sure what your issue is?

I thought you were wanting a border setting.
ive guessed the synatx to add the border colour condition:
The way to do that is to draw a box around the item set it as suppressed printing, then use conditional formatting to unsuppress it when you want it to show.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

gazmoz17
User
User
Posts: 112
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: Conditional format....limitations?

Post by gazmoz17 » 10 Jun 2024, 15:29

Hi bruce,

Typo by me 🤦‍♂️ was wondering why you kept mentioning border.
Typo...background colour not border.PNG
No it was background colour, dont know the syntax to specify in conditional formatting so was guessingt how to apply grey fill.
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4652
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Conditional format....limitations?

Post by brucedenney » 11 Jun 2024, 09:34

So just select grey and the job is done.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest