Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Report while Rendering to EXCEL

Posted on 2014-02-11
1
Medium Priority
?
625 Views
Last Modified: 2014-02-12
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
Comment
Question by:SURESH0518
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 39852492
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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question