Solved

Header and Cell formatting missing top/bottom line when using "show report" function

Forum|Forum|2 years ago
September 22, 2023
2 replies
0 views

Hello, I am seeking for assistance on header and cell format with conditional formatting. I am trying to add a top and bottom line to specific accounts in the "Show Report" function.

Header Format used

However, in the report, only the bold formatting is applied while the top and bottom line do not appear.

Any guidance on resolving this would be greatly appreciated. Thank you.

Thanks,

Jacky

Best answer by matt515

HI - Sorry I just noticed I didn't use the same formatting and then the color isn't necessary.

If (HeaderDisplayText = 'Account 3') Then Bold = True, ReportUseTopBorder = True, ReportUseBottomBorder = True
End If

I used ReportUseTopBorder and ReportUseBottomBorder

M

matt515

Hi - What happens when you add this formatting ReportTopLine1Color = Black. I wasn't getting a top line to show either replicating your logic above and then I changed it from Default to Black and now see a line.

J

Jacky_CAuthor

Hi Matt, thanks for your reply. I tried your solution at my end, but it does not work as expected. If possible, can you share a screenshot of how it is look like at your side? Thanks.

I tested your solution with the following two versions of code; however, I am not able to see top/bottom lines in the report.