Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 656
  • Last Modified:

SSRS Report while Rendering to EXCEL

I have a requirement while rendering into EXCEL.

While interactively I would like to show like this

Date                    Amount
2/1/2013              $100
                             $200
2/2/2013              $50
                             $75

When render into excel the I would like to show like this

Date                    Amount
2/1/2013              $100
2/1/2013              $200
2/2/2013              $50
2/2/2013              $75

Is this possible while rendering into excel.
0
SURESH0518
Asked:
SURESH0518
1 Solution
 
ValentinoVBI ConsultantCommented:
The easiest way to achieve that is to create two tablixes: one for interactive use with grouping on date and one for export to Excel without grouping.  You can use the Globals!RenderFormat.Name property to detect the render format.  For Excel it will be set to "EXCEL".

So an expression for the Hidden property of the tablix may look like this:

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

More details: Hide/Show Items Dependant On Export Format (SSRS)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now