Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS 2008 R2 Removing the + sign when report is exported to Excel

Posted on 2014-09-30
2
Medium Priority
?
360 Views
Last Modified: 2014-10-01
I have a report which has one drill down.  Is there a way to remove the drill down affect (the + sign toggle) when it is being exported to excel?  I basically only want the unformatted report to be exported to Excel.

Thanks!!
0
Comment
Question by:yanci1179
2 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 40354042
You can use the renderformat global to determine if the report is rendered for Excel. See:
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx

But I'm afraid the toggling isn't something you can swith on and off based on an expression. You might need a copy of your tablix without toggling. Then you can show the right tablix based on the rendering.
Not a simple solution unfortunately.
But I think it is possible to control the InitialToggleState. This way the report is collapsed in the browser but expanded in Excel.

You might find some hints in this article:
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx
0
 

Author Closing Comment

by:yanci1179
ID: 40354857
Thank you for the fast response.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

580 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