Solved

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

Posted on 2014-09-30
2
297 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 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL QUERY 3 33
Linked Server - SP with Param to VIew 7 19
Connect remotely to SQL Server DB without TCP/IP enabled? 2 28
SSRS Page Header from Group Data 2 21
I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

685 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