• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

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
0
sbalawajder
Asked:
sbalawajder
  • 3
1 Solution
 
ValentinoVBI ConsultantCommented:
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?
0
 
sbalawajderAuthor Commented:
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)
0
 
sbalawajderAuthor Commented:
OK, I about got this figured out.

I LEFT OUTER joined in the view, and I'm selecting on it via a new column

ISNULL(VIEW.CUSTID, 0)

I then put this expression in:

=IIf(Fields!ID.Value = 0, "Black","Red")

Seems to do the trick, just need to verify it's working properly.
0
 
sbalawajderAuthor Commented:
Figured it out on my own
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now