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

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

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

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server


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

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 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



Sub report is not coming when Exporting it to Excel


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:)

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.  ?


How to display related tables in one crystal report and how to link this report with combobox?


Hi! I want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Now if I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names. How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box? Help me friends. An example would be appreciable.

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.

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

Formula on Main Report Using a Field from Subreport

Hi, I try to use a value coming from a cell which contain a subreport. I need to create a formula using this value. So I tried : =Code.CalcPct(CountDistinct(Fields!s_contactsvisited.Value), Globals!CALL_SubReport) But I've an error: [rsRuntimeErrorInExpression] The Value expression for the textbox textbox9 contains an error: Specified argument was out of the range of valid values. Thanks for you help,      

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

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!!

How to pass value from main report to sub report

I need pass sub report calculated  value in main report  using crystal report please help me

Predefined excel report sheet

Hi, I am trying to export data from DB to excel sheet. I have to use a predefined excel sheet. My questions here are 1. How do i use a predefined excel sheet. That predefiend excel sheet has some formats my data should be exactly placed in that location only. Is it possible to achieve. If yes how can i do that? 2. I want to place the row count on the top of the excel . say in row 1 i need count, name from DB should be in row 2, address in row 3. How can i achieve this. Pls throw some light on this. Thanks and Regards, Dumbi dooooo

SSRS Report Problem while Exporting into PDF

We are trying to generate a report in SSRS 2005 with Landscape  layout. The report if fine but when we export it into PDF format the result comes in 2 pages that is fine but there is an image in the footer which is only displaying in the last page of the report footer the text fileds are fine only image is not displaying in every page while exporting. Please guide.............
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