Prevent Group Rendering in Excel

  • Hi all,

    SSRS 2008 R2

    When users export some of my reports to Excel they are doing it so they can perform additional analysis with the data. In this case header/footers and grouping just get in the way, e.g. the spreadsheet should look just like a 'data dump.

    I have removed header and footer details by using the Globals!RenderFormat.Name built-in field.

    I can't seem to get it to work with grouping though. What is irritating is I know I accomplished this at my old job, just can't remember how.

    I tried using the following in GroupExpression:

    =IIF(Globals!RenderFormat.Name="EXCEL",1,Fields!ColumnName.Value)

    The GroupExpression expression for the tablix ‘Tablix1’ refers to the global variable RenderFormat, which is not valid for this type of report item expression.

    Just to firm clarify, what I am looking for is:

    Run in Explorer

    GroupCol DetailCol

    1 1

    2

    2 1

    2

    Export to Excel

    GroupCol DetailCol

    1 1

    1 2

    2 1

    2 2

    Thanks

    Steve

  • Hi All,

    Since i haven't gotten any responses I am wondering if maybe I wasn't able to do this at my previous job. Memory does seem to be fading these days.

    I do have work around which is to add another Tablix with no groupings and using the Hidden Property of each tablix to show/hide based on Render Name. Though not ideal as it becomes unmanageble if the report is complex, it does make life easier for my users so the price must be paid. If I ever do find a better solution I will update here.

    Cheers,

    Steve

  • I don't know of a way to make groupings behave differently in SSRS vs. when exported to Excel. AFAIK, whichever grouping option you go with, that's what you'll get whether you run the report in your browser or export it.

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

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