Report bottom and top borders without cube view grid lines

[FlorisvdPoel]

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

[JackLacava · Accepted solution]

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.

[FlorisvdPoel]

Jack,

That did the trick. Thanks so much.

Kind regards,

Floris