.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 2000 reports when upgraded to 2005 report with subreport really really slow

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

We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.

The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.

Both in the BIDS environment as well as the report site the report is very slow.

We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.

Can anyone please help me here?

View Complete Post

More Related Resource Links

SSRS 2005 reports - Parameters slow to take input from user

I have SSRS 2005 reports with two parameters, StartDate and EndDate. When I run the report in the internet explorer, the report takes 30 to 40 seconds to respond to the user control. I mean the calendar picker appears only if I click after 30-40 seconds from the time the report loaded. I'd appreciate your thoughts to resolve this issue.


SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

ssrs 2005 default value generates report

Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

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.

Error with Scheduling a Report to run in SSRS 2000


Getting the below error when trying to schedule the report to run.

I can run the report just fine as a stand-alone and not thru the scheduler.

I have several others that run just fine in the same way.

ReportingServicesService!processing!5d4!8/24/2010-01:15:02:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DataSource1'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [01004] [AcuCorp, Inc.][AcuODBC Driver][ISAM]Unable to open xfd file
  at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
  at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
  at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.Odbc.OdbcCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
  at Microsoft.ReportingServices.ReportProcessing.a1.v()
  --- End of inner exception stack trace ---

SSRS 2005 Report with 7 subreports


I've SSRS 2005 Report with 7 subreports.
Toplevel report runs the query and returns recordset.

RegionID  CustID orderID  OBID     State      City       Name
69            1230    4565      75855    NY         NYC       Sam

Now i need to pass these values in subreports's query as parameter
something like
select * from Region where regionID = @RegionId (in my case it shud get 69 from upper record set.)
Likewise there are 6 more subreports where i need to pass above values as parameter.

Any suggestions would be very helpful.

Thank you,

I'm getting exception while running Report builder 2.0 for SSRS Reports

I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.


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

Report conversion from SSRS 2005 to SSRS 2008


I am converting reports developed in SSRS 2005 into SSRS 2008. In the report design interface I have several rows and columans of data that calculate count or rate. In addition to rows and columns, I have around ten hidden tablixes in which report expression calls hidden codes inside tablix to perform calculation with main report. My problem is when I set hidden tablix propert into hide, I am not getting correct calculation in my report.  when I change tablix property from hidden to show I will get correct calculation but I do not want to see those hidden tablixes in my report page. Is there any way  you can still call expressions inside hidden tablixes without turning on tablix property show in SSRS 2008? Is it a bug in SSRS 2008 reporting system? Please help me out!!

My operating system is windows vista.



SSRS 2005 Error after uploading new reports


I have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.

These reports can be called succesfully from both the report manager and my asp.net website.

Everything has been working fine.

Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.

Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.

The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"

I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.

I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.

So I'm at a complete standstill and haven't a clue what to try next.

Has anyone come across this issue and if so how did you resolve it?


YTD Variance on Matrix Report - SSRS 2005


I am trying to set up a report that pulls how many patients were referred to our physicians by other physicians in town.  I have a matrix report set up with parameters so that at the end of each month users can select the month and year and it will pull data year to date for the selected year and the year prior to the selected year.  The report ends up looking a little something like this

           CurrentYear     PrevYear

Phys1  3                      4

Phys2  5                      2

Phys2  6                      1


We need to have at least one column to calculate teh variance between the two years and possible a second for % variance.  I have been scouring the web and most answers seem to apply to 2008 but unfortunately this is a 2005 server.  Any help or pointers in the right direction are appreciated.

SSRS report runs slow


I developed a report with BIDS  which uses a stored procedure on MS SQL 2008 Database to populate its dataset used as Datasource. The report runs very slow (10 mins) and if the stored procedure is executed separately on MS Server Management Studio (SMS) it takes only a few seconds with the same parameters. Appreciate if anyone could help on this issue.

Thanks. VisaAde

SSRS 2005 Report Printing Additional Blank Page



New to SSRS 2005 and having some problems printing. I have a report that has only 7 columns and while in layout mode, the body of the report only has a width of not even 7 inches. I have made my left margin 0.2 in, RM at 0 in, TM at 0 in and BM at 0 in as well and yet when I print, I get an additional blank page. All my records print in the first page just fine but I get the additional blank page. This also happens to me on a different report when I change the settings for landscape printing. I am able to fit all the columns in one page using landscape but get an additional blank page for every page that is printed. So instead of printing just two pages of records, I get 2 additional blank pages.

Any help will be greatly appreciated.



SSRS 2005 Matrix results affected by defaulting being set on report parameter?


We discovered some very odd matrix behavior a couple days ago and just today found out what in the RDL seems to be causing the issue.  The issue is that certain cells in the matrix will not be populated if a certain report parameter is defaulted.

The basics:  A matrix report with 6 report parms two of which are passed to the underlying procedure call.  There are 6 datasets behind the report.  4 are related to getting date and timespan information to allow for parameter defaulting.  1 gets a list of customers to populate a selection drop down and the last gets the data.

The data query takes a customer name and an end date.   Via the report parameters the end date parm is defaulted based on a dataset which is chained through the other parms and associated datasets.

The matrix is used to show a months worth of activity by day.  There are two int32 data points in each matrix cell one is a total and one is a failure count.  The data as returned by the reporting proc is already summarized so no aggregate is needed in the matrix.  However, using SUM or not in the matrix cell makes no difference to the strange outcome.

When the report is run with the end date parameter being defaulted one of the rows will incorrectly show 16 cells.  The cells appear as if there is no data.  However, if the proc

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