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

Report column color change based on condition

Like (0) Share

Report

Posted on 24 Jan 2022 20:47:12 by Indira88

908

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

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,005 Moderator on 26 Jan 2022 at 07:30:32

Like (0)

Report

RE: Report column color change based on condition

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
Indira88 908 on 25 Jan 2022 at 18:50:29

Like (0)

Report

RE: Report column color change based on condition

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
Suggested answer

YUN ZHU 80,640 Super User 2025 Season 1 on 25 Jan 2022 at 00:24:19

Like (0)

Report

RE: Report column color change based on condition

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

Thanks.

ZHU
Suggested answer

MahGah 15,437 on 24 Jan 2022 at 21:09:27

Like (0)

Report

RE: Report column color change based on condition

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
Suggested answer

Inge M. Bruvik 1,005 Moderator on 24 Jan 2022 at 20:58:30

Like (0)

Report

RE: Report column color change based on condition

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-