.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

Is SSRS 2008 capable enough to be a solution for generating really huge reports?

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

Hi All,


I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though I wanted to use it). Please go through my points and share your views on this.


Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)

View Complete Post

More Related Resource Links

Schedule reports with integrated authentication SSRS 2008

Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only  in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1.       View Reports 2.       Manage reports 3.       View Folders 4.       Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

Where are the 2008 SSRS sample reports?

All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?

SSRS 2008- redirect to /Reports virtual directory?

We have just configured a new SQL Server Reporting Services 2008 server. So far, everything is going well, with the exception of one thing: we want anyone who hits the root of the webserver to be redirected to the /Reports virtual directory. So, if the user enters http://servername.domain.com/ it would redirect to http://servername.domain.com/reports. In SSRS 2005, it was easy to configure IIS to do this, but with SSRS 2008, I cannot figure out how to make this change. Help?

Are there workarounds for SSRS 2008 Reports that have issues in SSRS 2008 R2

We have some SSRS 2008 reports which have a few issues in SSRS 2008 R2: - Page Numbering: Our reports use [PageNumber] of [TotalPages] however, in R2 [Total Pages] only relates to a particular section.  Do we really need to update every single report in design mode to use [OverallTotalPages]?  Is there a workaround? - Report Rendering: Each page of a report is only rendered when each new page of the report is requested.  How do we prevent this is R2? - Missing Data: If we run a report that should have 50 pages of data, not all pages are shown when viewing the report.  For example, only 2 pages might show.  However, if we export to PDF the whole 50 pages are exported.  Does anyone know why this is happening? Looking for patches, workarounds, etc.  Hoping that we don't need to upgrade desktops to R2 and edit hundreds of reports to fix these issues. Thanks, Howie999

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.

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

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

SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

Strange issue with a huge SSRS 2008 report (supposed to return 3 million records)



NOTE: The strange part (as mentioned in title) will come in the end.

I am running a SSRS 2008 report which fetches 3 million records from a remote server. After around 1 hour the report processing stops and I see an error icon on the lft bottom of the browser window. When I click on that to see the error details it shows some PageRequestManagerSQLErrorException with an unknown error message with code 12029 (sometimes 12002).

When I see the reportserver logs there is an error message logged in it which says "Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached."

The <DatabaseQueryTimeOut> value in the report server configuration file is already having a value set to 7200 seconds(2 hours).<

SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than


We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.


It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)


So I quer

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

SSRS 2008 crashng when running a report with huge amount of data


We have a huge amount data that is loaded (using flat files, upto 80GB in size) from the mainframe on a daily basis after which our users use SSRS to view the results using predeployed reports. One of the report query brings back a huge amount of data but when rendering the reports, it dies and restarts the service.

library!ReportServer_0-12!1310!10/14/2010-17:49:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database., ;
session!ReportServer_0-12!1310!10/14/2010-17:49:45:: e ERROR: Sql Error in GetSnapshotData: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
ui!ReportManager_0-11!1b34!10/14/2010-17:49:45:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the dat

ssrs 2008 reports Datasource error in Test server..


Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.


Why? Can anyone give me some idea...?


Unable to deploy reports from VS 2008 to SSRS 2008

I have a server that has SQL 2005 and SQL 2008 installed.  At one point, I was able to deploy reports from VS 2008 to SQL 2008, but can no longer do so.  Any ideas what could have changed that prevents the deployment?  Should I remove SQL 2005, as it's not being used on this particular server?

merging reports ssrs 2008




how can i display barchart and linechart in a single report by using ssrs 2008

Reports referencing .NET Framework 4.0 fail to upload to SSRS 2008


We are running SSRS 2008 on a 64-bit Windows Server 2008 SP2

When attempting to deploy a report containing a reference to a .NET Framework 4.0 assembly via the Report Manager, we get an error.

For example, when deploying a report referencing System.Xml, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089, we get the following error:

Error while loading code module: ‘System.Xml, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089’. Details: Could not load file or assembly 'System.Xml, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingCodeModule)

The same report deploys correctly in a development environment (Windows 7 64-bit, SSRS 2008).

The Win2k8 server has .NET Framework 4.0 installed and is fully patched.

Is there a strategy for troubleshooting this issue?



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