Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Expression Error For Background Color in Paginated Report

I am creating a Accounts Receivable paginated report in report builder based off a Power BI Dataset from an already created Power BI Report.  I have a column called "Due_Date" that I need to conditi...
Need Help
GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi Anonymous 

 

Could you try the following

 

=IIf(Fields!Due_Date.Value < Now(), "Red"))
Anonymous's avatar
Anonymous
Not applicable
2 years ago

It did not work. Error message:

 

The 'Color' expression for the textrun 'Due_Date.Paragraphs[0].TextRuns[0]' contains an error: [BC30516] Overload resolution failed because no accessible 'IIf' accepts this number of arguments.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Anonymous 


    Could you make sure that both the Fields!Due_Date.Value and now() are both returning a date value?