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.