Post reply

Need to suppress export of a sub-report

  • February 28, 2012 at 7:14 am

    #251451

    Hi

    A colleague has a main report on the same page as text-based sub-report. We want the data to be exported, but not the sub-report (which is basically a help menu). Is there any way we can suppress the sub-report?

    At the moment when we export to Excel (this is specifically an Excel problem) the report doesn't render properly. This appears to be because the sub-report occupies a single row of data in Excel and causes the adjacent detail row of the the main report to expand to the same size as the sub-report. Result is that the report looks terrible in Excel.

    Any help would be much appreciated.

  • February 29, 2012 at 7:25 am

    #1453154

    I've found an answer.

    You can lay a rectangle over the report element you wish to suppress when exporting and add this expression to the Visibilty property of the rectangle:

    =IIF(Globals!RenderFormat.Name = "EXCEL", True, False)

    This will set the hidden property to True when exporting to Excel. Actually, so will this:

    =Globals!RenderFormat = “EXCEL”

    Hope that helps someone.

    Cheers

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply