Skip to main content
Contributor
Sep 21, 2022 8:44 AM UTC
Solved

Report bottom and top borders without cube view grid lines

Hi everyone,

I would like to add a top and bottom border to a specific row in the report when I export the cube view. 

I know this is done by setting the GridLinesColor to a specific color and ReportUseTopBorder = True and ReportUseBottomBorder = False.

Even though my client will not use the cube view but is only interested in the report view (which will be exported to PPT), I would like to know if I can have the top and bottom border in the report view but not show the grid lines when viewing the cube view.

Thanks for any help in advance.

Kind regards,

Floris van der Poel

Employee - Sage
Sep 21, 2022 11:00 AM UTC

Hey Floris,

If I understand your question, I think you want the ReportTopLine1Color and ReportUseTopLine1 properties (and the equivalent Bottom ones), applied to the Cell Format property of that specific row.

2 replies

Employee - Sage
Sep 21, 2022 11:00 AM UTC

Hey Floris,

If I understand your question, I think you want the ReportTopLine1Color and ReportUseTopLine1 properties (and the equivalent Bottom ones), applied to the Cell Format property of that specific row.

Contributor
Sep 21, 2022 12:23 PM UTC

Jack,

That did the trick. Thanks so much.

Kind regards,

Floris