.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

REndering large single reports into Multiple reports

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :ASP.Net


I am using ssrs 2008.  My Report can genarate  5000 Record count , 10000 Records count or more than 10000 records count.

When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.

how can i avoid that exception..?

 i read through some forum can genarate one report into mulitiple reports by dividing the record count.

can nay one explain in detail..how best i can work on Rendering Large reports.


thanks in Advance.


View Complete Post

More Related Resource Links

How to add multiple reports in single parent pane with each report had its own pane and dropdown to


We had a report to create which should show multiple reports with each of them had there own pane and each of them had drop down to select the parameters to run this report. We had to create this report using SSRS, any ideas???



Crystal Reports can grow fields with large amounts of text layout problem


A can grow field in the details section of a crystal report may have so much text that the section will be larger than the remaining space available on the page (the space below the previous record).  The section has vertical lines on it with Extend to bottom of section when printing set to true.  The section starts on a new page (and may continue on the following one).  I want it to start on the page where the last record was laid out, and continue to the new page without leaving a gap with vertical lines on it.  I'm using Crystal Reports 9 and I can't work out how to do it. Has anyone got a solution?

how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help



I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help


Thanks in advance!

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

Multiple Reports in the same Viewer

Hi all, Is that possible to open three reports in the same window ? Can be using the group tree or the tabs beside the MainReport. If it is possible, how to do it ? The reports used to be open in excell and the file has three worksheet, now we want to change them for Crystal Reports, thats why were created three reports, but it must be open the same was the excell format, with three worksheets. Any work around for this will be appreciated. We are developing the asp.net in VS2010 with the CR2010. thanks !

One report >> Multiple Linked Reports in different folders?

I love Linked Reports in SSRS because of my ability to change one report in one project and post changes to one location on my SSRS server and then have those changes take effect in my linked report.  Today however I was asked to make one of those reports which is already liniked elsewhere to be linked to two locations and I was dismayed to find out that there is a chance that its limited to one linked report for any source report. Can someone tell me this isn't so and show me a way around this?  I don't want to have to post my RDL to multiple locations unless its absolutely necessary. I'm using SQL Server 2008, SSRS2008, Standard Edition. Thanks, Keith

Using ReportViewer for multiple reports by way of radio buttons

 Hi all, Thanks for taking the time to read over my scenario.  I am using one ReportViewer with already established SQL Stored Procedures connected to three report files (*.rdlc).  There are three radio buttons which are to be associated with each report that needs to be displayed in the ReportViewer.  Here is an example if a radio button is selected:ReportViewer1.Reset() Dim rds As Microsoft.Reporting.WebForms.ReportDataSource rds = New Microsoft.Reporting.WebForms.ReportDataSource ReportViewer1.LocalReport.DataSources.Clear() If RadioButtonList1.SelectedIndex = 0 Then rds.DataSourceId = ObjectDataSource1.ID rds.Name = "spEx1" rds.Value = ObjectDataSource1 ReportViewer1.LocalReport.DataSources.Add(rds) ReportViewer1.LocalReport.ReportPath = "Ex1Report.rdlc" ... The ReportViewer works for the first radio button selection but then for the other selection I get the following error: A data source instance has not been supplied for the data source 'spEx1' I'm not sure exactly what is going on or where it's still tied to the first data source.  Any help would be great!  Thank you.

Multiple reports

Hi, I want Display 9 Reports in single Report LayOut. plz let me know how can i create reports. thats very help full for me.

Multiple Reports

Hey All, I need to create a 5 page Report for each employee in our organisation based on some criteria and then i need to send that 5 page report to the related employee only. Similarly all the reports created that way will go to the related employee as an email. I've the idea of how to do it for single report at a time, But how to do this for all of the employees at one go i am not sure about that. Please give me some idea or solution to work it out. Please help me out. Thanks a lot Punu

Rendering reports in crystal report viewer

I am trying to put a crystal report viewer into MVC. When I point a report to the viewer, this is what I get.The report is able to display however there are these box surronding the textfield objects of the crystal report. The attached image is what is being displayed when I view my report on a view.

Two crystal reports in a single report viewer

hi...to alli want to generate the two crystal reports one is employee and another is project.now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer..can anybody help me.. plz

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users.   Thanks for your help in advance.

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control


MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.



Report Definition:



<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

Error while Rendering Reports(Reporting Services 2005) in .Net 1.1 web Application on IIS 6.0


I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or  something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

Multiple reports straight to pdf (SSRS 2008)

Hello, I have successfully written code to generate a server report straight to a pdf document. I did this using Report.Render(...) and then writing the result with Response.BinaryWrite. This works fine. The thing I would like to do now is this: On the webpage the user sees a tree with about 20-30 reports on it. I would like the user be able to select which reports he wants to see (using the tree check boxes) and then when he hits print one pdf document is generated with all the selected reports on it. Any suggestions? Thanks.

Programatically Exporting Multiple Reports


Hi currently I am programmatically exporting multiple reports to a pdf via the ssrs web services using C#.Net.  It exports a single report just fine, I was wondering if there was a way to export multiple reports?  I tried block copying the byte arrays from all the reports into a single byte array, but it only displays the last report.  Is there any solution for this?

How to display reports from multiple lists in SQL Server Reporting Services Report Viewer


Hi All,

  I want to generate report through SSRS from more than one sharepoint lists. To generate report from one list i am using below query:

   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
   <ElementPath IgnoreNamespaces="True">*</ElementPath>

Please suggest me a query to get results from more than one list like we use joins for SQL tables.

Thanks in advance,

Saurabh Kumar Singh

Mail: saurabhsinghmca@gmail.com

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