.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

Sub report is not coming when Exporting it to Excel

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

Hi All,

I have one report in 2005, where I have used Sub Report in Table. When I am Exporting It to PDF It is showing Subreport Data, but When I am exporting it to Excel, Sub Report Data is not coming to Excel and it showing error (Subreports within table/matrix cells are ignored.)  in excel.

Please anyone can suggest how to resolve this issue.

Thanks Shiven:)

View Complete Post

More Related Resource Links

Exporting a PerformancePoint Excel Services Report to Excel


Have an Excel services PivotTable in a PPS 2010 dashboard.  When the user selects the "Export to Excel" option they receive this error.

I do not see any options in the webpart to show the old toolbar that used to show up in the Excel Services views.  (It had an option to open the pivottable in Excel or export a "snapshot" to Excel)

How do users export Excel Services reports to Excel?


The selected view does not support an export to the selected format.


Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: c189d209-c218-4606-aad4-2f280d5c6977

Date and Time: 9/20/2010 10:26:17 AM

Exporting in PDF or Excel for a main report and the related sub report



I have created a main SSRS 2005 report from what it is possible to call some subreports. Is it possible export in PDF or Excel also the subreports when I require the export inside the main report?

Many thanks

Exporting access report to excel use SQL


I am new to access can anyone tell how to Export access report to excel use SQL or VBA

Thanks Ron



Issue when report exporting to excel



I am having a report (using SSRS 2008). when I view in the Preview tab its renders great but when I am exporting to excel i have this problem, the row height for rows with multiple lines, does not expand . So the user has to manually increase the height of rows in excel.

This is one of the subreport in Master report as an individual report there are no issues when exporting to excel ( The cell height in excel increases dynamcially based on text) however the same report i'm using in Master report as a subreport the cell height doesn't increase and also i can see the only first line message, so i have to change cell height manually.

I really appreciate if some one has any work around to this issue.


How to rename excel worksheets after exporting report in SSRS 2008 R2



Is anyone aware of this new feature of 2008 R2. How to have the excel tabs renamed after the report will be exported to Excel. What properties I have to set to do the same.  ?


Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

VS2008 BIDS Report export to Excel not grouping the same as VS2005

I have a report that I created in VS2005 BIDS and got it to export to Excel to group/subtotal the same way it does in the BIDS report window.  Now I have copied the .rdl files to a VS2008 project, open it in VS2008 BIDS, made NO changes to the report format and the exported Excel file is combining what should be the 2nd and 3rd groups into 1 group.  In the BIDS window, the grouping is working correctly.  Does anyone have any ideas what has changed between 2005 & 2008 that may cause this problem?  Thanks in advance.    

SSRS report exort to excel wrap text proplem

When i am exporting the ssrs report to excel the wrap text is not working properly. the cell containing large data are cutoff how to resolve this issue. since the data size is not fixed so the cell should wrap the text while exporting to excel. I am using java to call the report Thanks , Kamal.

Exporting SharePoint list to excel.

Hi All,   We have a SharePoint list in which one column is "Person or Group" and it can take multiple values. When we export it to spread sheet this column contains some junk data.We are using MOSS 2007 and Office 2007. Previously asked question on the same issue http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/00cc338d-8201-4b8d-b2ea-5979ee58a464 Does any one know of a Microsoft published article for this issue as we need to provide it to our higher ups for this issue.   Thanks.

Howe to do :Excel export button in report viewer visible false...?

hi all,  How I can do avoid to display  Excel export in ReportViewer..? if I Use //-------------------------- reportViewer1.ShowExportButton = false; //---------------------------------------------------- Both the buttons will be disabled...for only Excel button How can I...?    

Report fine; PDF export fine; Excel export crashes - ArgumentOutOfRangeException

I use the Report Viewer Redistributable 2005 Service Pack 1 (version 8.0.50727.1843). On my ASP.NET page the report displays fine, in a ReportViewer control, using an rdlc file. Export to PDF works fine. Export to Excel crashes. Stack does not tell me much because it's all internal to the Report Viewer:[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index]   System.Collections.ArrayList.get_Item(Int32 index) +7483656   Microsoft.ReportingServices.Rendering.ExcelRenderer.DoubleList.get_Item(Int32 index) +5   Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(Image image, PageTableGrid pageTableGrid, PageReportItemInfo reportItemInfo, PageCell pageCell, Int32 row, Int32 col, Boolean addHeaderRows) +907   Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean addHeaderRows, ReportItem parentItem, Hashtable riReferenceTable) +1317   Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol, Int32 maxCol) +936   Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet

Issue while exporting to Excel

Hi All, We are having report in SSRS 2005, everything is working fine while Running the report on BIDS as well as on Report Server, but as soon as we export the report to Excel it is creating issue(S) not just a issue. First - I'm not able to see "Footer" in Excel, although it does exist in BIDS as well as Report Server. It is visible while doing Print-Preview in Excel, why so is it a bug, is their any work around to make it visible without doing Print-Preview, please do let me know! Second - It is regarding "Header", I have couple of text boxes in my Report Header, as soon as I include text boxes in Report Header and when I export to excel, the rows & columns height as well as width is getting disturb (meaning some getting compressed and some getting expanded), so to make it look attractive we have to manually arrange in proper order before delivering to our end-user, Can anybody tell me why rows & columns are getting disturbed and also how to arrange with exact height & width without any manual interpection, please help me out, this is getting me crazy?   Thanks Regards, Kumar

Regarding about Excel Report

Hi to all,I have a data in Excel. but i want to show that data (as in Excel) in a button click event .Have a nice day to all !ThanksL.Lakshmana Perumal

Trouble importing strange column format report from Excel 2007 to SQL 08

Hi, I'm not sure whether this belongs in this section or the SSIS one so hopefully I've got it right!  Hoping someone will be able to help with a problem I'm having importing a report with header and detail rows from our antiquated POS system into SQL 2008 tables.  The reports export in Excel 2007 format and for each header row there can be one or more detail rows starting from column B.  As such I've tried several things such as openrowset, an Access 12.0 OLE DB source in SSIS and even COM automation of Excel to try and write a conditional split which will hold the header details in variables then write them to rows alongside the detail rows.  I've pasted a small sample of the data here as I wasn't able to attach it: 01/07/2010 @ 11:18 Page: 1 RECEIVING: Voucher Journal Sort: VC|Str|Vou Date|Vou #|Document SID Filter: Voucher Date: 01/06/2010@12:00a..30/06/2010@11:59p Include Item detail: DCS|Item#|Desc1|Attr|Material|Size|Qty VC Str Vou Date Vou # Qty ABC 001 15/06/2010 12345 38 E NN 66 200148 XXXXXXXX RED SHAD E NN 66 200149 YYYYYYYYY BLACK GO E PP 60 200154 ZZZZZZZZZ BLACK CDE 002 16/06/2010 13839 8 F SA 35 217500 XXXXXXXX Natural F SA FL 218674 YYYYYYYYY Chalk F SA WE 221462 ZZZZZZZZZ White FGH 001 21/06/2010 13905 3 F SH 85 126260 XXXXXXXX Navy IJK 001 23/06/2010 13914 3 E AA 61 250005 YYYYYY

Exporting multiple gridviews in multiple excel tabs

Hi All, I am able to export multiple gridviews in a single excel worksheet My question is can I separate these gridviews in multiple tabs under the same excel file ? This is my current method under the link buttonprotected void lnkExport_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition","attachement;filename=TrendAnalysisRpt"+StoreNum); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); HtmlForm frm = new HtmlForm(); this.grd_Inj.Parent.Controls.Add(frm); this.grdBody_1.Parent.Controls.Add(frm); frm.Attributes["runat"] = "server"; frm.Controls.Add(this.grd_Inj); frm.Controls.Add(this.grdBody_1); frm.Controls.Add(this.grdBody_2); frm.Controls.Add(this.grdBody_3); frm.Controls.Add(this.grdBody_4); frm.Controls.Add(this.grdMonth); frm.Controls.Add(this.grdDay); frm.Controls.Add(this.grdHours); frm.Controls.Add(this.grdLengthOS); frm.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); } Thanks again!    

Generate Report Excel from Client??

Hi all, is it possible to create an Excel report from client?i have a webform that uses the libraries Interop.Excel.dll, Interop.Office.dll, Interop.VBIDE.dll to create an excel report (with statistics graphics) but it do it using excel from server. By company policies we must uninstall office from the server. But the Excel's reports are still useful and i need a way to remake it. then, is possible use the client's Excel to make the reports? exists another tool that allow me make this reports without using excel???Thx in advance!!
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