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
- - - - - - - - - - - - - - - - - - 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?
Conditional format....limitations?
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
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
- brucedenney
- Site Admin
- Posts: 4652
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Conditional format....limitations?
The border is not an option.
The available options are shown in the wizard.
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.
The available options are shown in the wizard.
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.
Re: Conditional format....limitations?
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
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.
If cant be done with work around I'll just leave as is.
Many Thanks
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
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.
If cant be done with work around I'll just leave as is.
Many Thanks
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4652
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Conditional format....limitations?
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.
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.
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.ive guessed the synatx to add the border colour condition:
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.
Re: Conditional format....limitations?
Hi bruce,
Typo by me was wondering why you kept mentioning border.
No it was background colour, dont know the syntax to specify in conditional formatting so was guessingt how to apply grey fill.
Typo by me was wondering why you kept mentioning border.
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.
- brucedenney
- Site Admin
- Posts: 4652
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Conditional format....limitations?
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.
Who is online
Users browsing this forum: No registered users and 1 guest