.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS Export to Excel Multiple Sheets empty First Row

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server

I have a report with four tables. There are page breaks in between each table (the Insert Page Break After this table option is selected on the first three tables). When I export this report to Excel, there are four sheets with the four tables of data on them. The 2nd, 3rd and 4th sheets all have the first row empty and its height is set to 0 so it looks like rwo 2 is the first one but row 1 is actually hidden. I need this row and would like the data to be populated in the first row and not the second. Has anyone come across this before?



View Complete Post

More Related Resource Links

How do you freeze the tablix header row in an Excel export file in SSRS 2008?

So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file.  The tablix is right at the top of the body and spans the entire width of the design area.  How in the world do you get it to freeze in the Excel export file?

How to merge sheets from multiple excel files into one .xls file?


 I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.

 How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?

 Thanks in advance.

Create dynamic dropdown list when we export data to excel using SSRS.


Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?



SSRS 2005: Export to Excel, Tiff, and web archive all fail


SSRS Export to Excel is popular in our office but has been failing a lot recently- at the beginning of the year there were a few occurances a month until June, then they steadily increased until now it is nearly every time (44% of the events happened this month.)  Few software changes (just MS and virus def updates) No configuration changes until troubleshooting this issue began.  Policy changes on both server and clients is possible as that is controled by contractors and we are not notified of changes.

Upon exploring I discovered export to tiff and web archive also fail, but csv, PDF, and xml seems to work most of the time.   Some of the reports failing have not had any design changes in months.  Reports are not particularly large- 2 to 4 tables with under 200 rows each.  No more than 6 pages and then mostly because of page breaks between tables.  no more than 5 levels of drill down- most have fewer than that.  The failure happens very fast- about 4 seconds.  If the data is filtered down to very small sets so that the export process can complete inside those 4 seconds then it succeeds.

I have seem many questions on lots of forums with similar issues with SSRS but no solutions that worked for me.  All the timeout values I know of (about 6?) are set to between 120 and 3600 seconds.  None of my reports sh

Not able to export a large SSRS report into Excel



I have a requirement to export a large SSRS report into Excel. The report has more than 52 columns and around 70000 lines. The requirement is to export the report into a single excel(different sheets also would do ). Can you suggest some help in this regards?

Thanks in advance!

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dynamically.So Please try to give me a solution.

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1



When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dyanamically.Sp Please try to give me a solution.

SSRS 2008 export to Excel margin problem

When rendering report from SSRS 2008 with custom margins (let's say 0.5in) into Excel, margins do not export correctly, or do not export at all, thus Excel sets its default margins.

I heard in SSRS 2005 it was not a problem.

Any ideas?

In SSRS 2008, after export to Excel report loses nested visibility groups


I have a report  created in SSRS 2005 which is running on our new SSRS 2008 box.  It has 3 nested levels of visibility so the recipient can click the twist tie to view different levels of detail.  Each Zone has many Districts and each District has many Stores.  The report renders displaying the summary of the Zones.  If you click on the twist tie on the Zone it opens up a list of Districts.  If you click on the twist tie on a district, it opens up a list of stores.  If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.

The report renders fine in report manager.  The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.  The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts and Stores.  The client is not happy about this.  This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.

I tried converting the report to SSRS 2008, but that did not solve my problem. 

Is there anyway to fix the export process to Excel? 


P.S. I tried to upload the code, but it caused my question to be too many characters

SSRS 2005 report export to excel - show text as number


When exports the report to excel, some columns are numbers(something like 00125987). We need these columns to be text,  but excel convert these columns in numbers and in result we received not "00125987" but "125987".  

How to fix that? 

We need all these columns to be text.



Export SSRS report to excel with data of pie chart



I am new to SSRS. I have a report with a pie chart . When I export the report in excel format, pie chart is displayed as picture. I want it to be displayed as editable pie chart with data. 

The requirement is, if user want to change the data in excel sheet after exporting, changes should reflect in pie chart of that excel sheet.

Please suggest me the way of achieving it.


Issue with Excel and Word Export - SSRS 2008


Hi there,

          I have created fairy simple report having a table in body section and Header, Footer. I have set the Report Properties

Orientation - Landscape

Paper Size - Custom

Width - 11in & Height - 8 in

Margins - Left 0.25 in , Right 0.25 in, Top 0.5 in, Botton 0.5 in

Issue NO 1: When i export the report to Excel, it takes margin as Left 0.75 in , Right 0.75 in, Top 1 in, Botton 1 in, because of this some part of my Report is cut. what should i do to keep margins of Excel as per margins set in RDL.

Issue No 2: In Footer excel shows Page 1 of 1 for all the pages

Expression used :



"Page" & Globals!PageNumber & " of " & Globals!TotalPages;

Issue No 3: when i export the Report to word, it does not consider landscape and show only middle part of report, cut rest of the report data.

Import List of Worksheet Names from Multiple Sheets Excel File

I am only interested in OPENROWSET/OPENQUERY or xp_cmdshell solutions. Thanks.
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

SSRS 2008 - Excel Export adding unwanted total columns to spreadsheet



I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)


Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Export Gridview data to Excel sheet


Hi ,

     I have a requirement where i need to export the gridview data to excel.My code export the data in excel that was fine.

But the enchancement needed now , I was exporting the 3 gridview in same excel sheet under the workbook.

Now i need to export the 3 grid view in 3 different sheet in the same workbook.

so can please tell or share the updated code in my below code ...

public void writeovrsummary()


        Response.Write("Overall Summary");
        //Response.Write("Report as of " + DateTime.Now.ToString("hh:mm ss tt"));

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);

        SqlCommand com = MyConnection.CreateCommand();
        com.CommandText = "useroverall_Report";
        SqlParameter[] par = new SqlParameter[1];
        par[0] = new

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend