Link to home
Start Free TrialLog in
Avatar of sbalawajder
sbalawajder

asked on

Changing color in a SSRS Field using expression

We currently have a report called Inventory Planning.  It basically lists all current inventory, out of stock inventory with open sales orders, and out of stock inventory with open Purchase Orders.

What our buyers face is when they purchase goods  for orders that do not have inventory, the customer will cancel the order (for whatever reasons) ad then we are stuck with inventory we may not necessarily want.  They have told me 98% of the time these orders get cancelled are with brand new customers.

Their question- can we change the font color of the customer if they have never done business with us,

Request seemed simple enough.  I wrote a view of current active customers that have never had been invoiced.

Now the fun part- how do I get SSRS to compare the customer field in the report to my view to change colors?

Any and all help will be appreciated.

Thanks
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Is it an option to (LEFT OUTER) join your view in the query that fetches the data for the report?  Or does it reside in another database?
Avatar of sbalawajder
sbalawajder

ASKER

I used a left outer join to bring it into the query. The only problem is comparing it to the customer the order happens to be written up to (which can vary by inventory id)
ASKER CERTIFIED SOLUTION
Avatar of sbalawajder
sbalawajder

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Figured it out on my own