Small and medium business | Business Central, N...

Report column color change based on condition

(0) Share

Report

Posted on by Indira88

1,015

Hi All,

I just created a report depicted as follows, now the numbers in the first row shoe the dates of the month and year shown in the file.

The requirement is that the date which falls on a weekend ,that column has to be colored differently. How can this be achieved:

Indira

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,187 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use this function to find the day of the week and add conditional formatting according to that:

docs.microsoft.com/.../date2dwy-function--date-

Was this reply helpful? Yes No
Suggested answer

MahGah 15,613 on at

Like (0)

Report
Copy link

Link copied!

Based on Inge's suggestion you can get the day of the week. Then you can use one of these suggestions for conditional formation

https://social.msdn.microsoft.com/Forums/en-US/756b45f2-517a-4429-97cc-3d95822a8944/how-to-apply-conditional-formatting-on-a-rdlc-report?forum=vsreportcontrols

social.msdn.microsoft.com/.../change-the-background-color-for-tablix-based-on-date

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,126 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, adding to two experts' reply, please note that formulas for different colors are only valid in RDLC, not in Word.

Thanks.

ZHU

Was this reply helpful? Yes No
Indira88 1,015 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response.

the first query in this is since the report has the numbers as static how do i form the date in the column and then check for weekday.

The column headers are static ,

if there is no way of doing it in mcros

regards,

Indira

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,187 Moderator on at

Like (0)

Report
Copy link

Link copied!

Then you must first build a date based on day,month and year. For that you can use the dmy2date method as described here:

docs.microsoft.com/.../system-dmy2date-method

Was this reply helpful? Yes No