Forum Discussion

Jacky_C's avatar
Jacky_C
New Contributor III
2 years ago

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

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 Forma...
Cube View
Dashboards
  • matt515's avatar
    matt515
    2 years ago

    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

matt515's avatar
matt515
New Contributor III

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.

Jacky_C's avatar
Jacky_C
New Contributor III
2 years ago

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.


Output Report

Best,
Jacky