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
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
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Figured it out on my own