Forum Discussion

FlorisvdPoel's avatar
FlorisvdPoel
New Contributor III
3 years ago

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

  • 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.

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    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's avatar
      FlorisvdPoel
      New Contributor III

      Jack,

      That did the trick. Thanks so much.

      Kind regards,

      Floris