Is it possible to return a background color from a SQL Query results? Currently we interpret a 1 or 0 to return the background color via an IF expression. Instead we would like to return the correct background color in the SQL query as an additional value.
We have tried returning LightRed(), ARGB(0,255,255,255), and ARGB(0,0,0,0) as both SQL results and a IF/Dual expression in the load statement. The background color doesn’t change.
How can we pre-load the background color for a field so it doesn’t happen during the User’s interaction with the data?
