How to set a color out of database values?[Answered] RSS

• • Reply
  Joerg Pauly

  Member

  2 Points

  9 Posts

  How to set a color out of database values?

  Jul 15, 2017 03:38 PM|Joerg Pauly|LINK

  Hello, everyone,

  I'm searching for a good hint for the following:

  In a LocalReport (rdlc) a duty roster shall appear. It's a pivot table; so no big thing.

  According to the kind of duty the cell shall set it's background color to a value that is stored in the database as HTML color value.

  I can't find any hint on how to set the so described color. I was appreciated about any help.

  Regards
  Joerg Pauly

• • Reply
  Deepak Panch...

  Contributor

  2990 Points

  1210 Posts

  Re: How to set a color out of database values?

  Jul 17, 2017 08:58 AM|Deepak Panchal|LINK

  Hi Joerg Pauly,

  you can try to write expression like below.

  =iif(me.value<10,"Red","Green")
  

  it is just for an example, you can ty to change it according to your requirement.

  Reference:

  Changing Background colour in RDLC Files Cell dynamically

  Regards

  Deepak

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
• • Reply
  Joerg Pauly

  Member

  2 Points

  9 Posts

  Re: How to set a color out of database values?

  Jul 17, 2017 04:32 PM|Joerg Pauly|LINK

  Hello,

  I found it myself:

  Color is written as a 24 bit hex value in a string column.
  I just need to Trim() the value, put a leading "#" to it and give it to the BackgroundColor property like that:

  = "#" + Trim(Fields!Color.Value)