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

Top 5 Contributors of the Month
Post New Web Links

Drill through report is slow when calling it directly, not through another report.

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

I have a main report (2008R2) with several drill throrugh reports in it. These drillthorugh reports render very quickly with parametervalues set from the main report.

Calling the same reports but directly (all of them show the same symptoms) - not through the main report - is very slow: Showing the parameters and possible values is quick. Efter picking my parameter value and opening the report, it is very very slow. Reportloading starts and then stops and the green symbol freezes for several seconds, then loading continues and finishes.

Why is that and can I do anything to overcome this issue, when I call the reports directly.

The report server is in native mode and data is on the same server as Reporting services (SQL Server 2008 R2)

View Complete Post

More Related Resource Links

JavaScript Error while calling a drill through report in a report viewer from a asp.net web page.


I am calling a report in a web page which is getting displayed in report viewer. This report comes fine but when I click on it to see the drill through report for this parent report the drill through report does not get displayed and I see a JScript error instead.

The error I get is something like,

parent.document.GetElementByID(...).ClientController is not null or not an object

The aspx page that contains the report viewer inherits from a master page that contains an Update Panel.

I tested the report separately in SSRS and the drill through is working fine there.

Can some one please provide any inputs on this one?



How can I export the crystal report to PDF directly?


I am developing web application using csharp on visual studio 2008.I am able to generate  reports, but I want just to export or generate reports in pdf only. How can I achieve this?
The code I am using is below. But it is not working. Please help

     myClass = new Dbcon();

        this.conn = new System.Data.OracleClient.OracleConnection();
        this.conn.ConnectionString = "user id=HRddd;data source=XE;password=cfvvv";
        //Database Connection
        ConnectionInfo ConnInfo = new ConnectionInfo();
            ConnInfo.ServerName = "";
            ConnInfo.DatabaseName = "XE";
            ConnInfo.UserID = "HRddd";
            ConnInfo.Password = "cfvvv";
        // For Each  Logon  parameters
        foreach (TableLogOnInfo cnInfo in this.CrystalReportViewer1.LogOnInfo)
            cnInfo.ConnectionInfo = ConnInfo;


        //CrystalReportViewer1.ReportSource = oRpt;
        if (bool.Parse(myClass.table_exists("COUNTVIEWDE", conn).ToString()) == true)
            myClass.DbNonQuery("DROP VIEW COUNTVIEWDE", conn);
         sql = "CREATE VIEW COUNTVIEWDE AS " +

Drill down report with recursiveness

Hi all, I am trying to develop a report that list a hierarcgy of individuals with corresponding assignments. The datasource looks like: Id   Name reportsTO Assignments 1    ABC    NULL         xyz 1   ABC     NULL         vcf 9   JHK      1              NULL 50 GTH     9              vcf 50 GTH     9              lop What I am trying to accomplish is for the report to initially provide me with: Name      Assignments +ABC         xyz                  vcf     And when I expand all the drill down will be:   Name                 Assignment -ABC                     xyz           

Export report directly to PDF


I have a report that is generated directly as a pdf report using the System.Web.Services.Protocols.SoapHttpClientProtocol. When the report renders as a pdf document soem of the cells that have TextAlign set to Right are actually showing with the TextAlign as Left. Is there something in the rdl file that is causing this or is this a bug when rendering directly as pdf?

Report using Stored Proc calling multiple Stored Procs


Hi guys,

I am new to SSRS. I have to create a report from a Stored Proc. Thi Stored Proc excepts just one parameter 'ErecNo'. This parameter is passed to fetch the columns from table1. This result set contains OrderID. The OrderId is further passes to 5 SP's in to fetch 5 more result sets. Output of the main stored proc contains 6 result sets.

Now I have to create a report using this SP to show all the Result sets in a Single report. But When I pass the Parameter in SP in SSRS. It ends up showing just one result set with Order ID. 

Can you please guide me how can I show all the result set in a Single report? 



Report performance slow


The below query is taking about 30 sec to execute in the management studio. I tried to visualize the Estimated execution plan and everything is a clustered index scan. The number of rows in the fact_dailycost table are 384962 and all the dimension tables have less than 1000 rows.

Please let me know how should I start tuning this query. This I'm creating a view and in the SSRS Report, I have a parameter Contract Number that is applied on the top of this view. For the report to display the results it is approximately taking 21/2 minutes.




Report exported to Excel 2007 is EXTREMELY slow once a filter is applied.


I am exporting a 12,000 row, 20 column report to Excel from SSRS 2008.  Once opened in Excel, everything is fine.  If I further filter the data through Excel (no external data connections) performance degrades.  If I filter down to say 20 rows, it nearly completely bogs down my entire PC.  I've emailed this spreadsheet to several others, who then experience the same issue.

If I export this same set of data from a different BI tool, such as Microstrategy, there are no performance issues what so ever.

Passing Authentication to drill through report


Ok I have a report that has authentication that I pass through reportviewer.   I have a link in this report a drill through report, problem is when I click on the link in the report viewer won't let me authenticate.  I pass credentials through onDrillThrough event, but it still doesn't work.  I would rather pass these network credentials from this reprot that were enterd to the drill through report.  Their has to be a simple way to access the already authenticated login information and pass to the drill through report like I do with the other parameters in the jump to report action of the textbox.  Any ideas I can't use a url because I am passing sensitive data that can't be seen or accessed by the user. 

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


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?

Calling different report parameters in a data-driven subscription


is it possible to change specific report parameters in a data-driven subscription on a per subscriber basis?

For instance I have a report with 3 parameters, when scheduling Joe I would like to select value A for parameter 1, User harry should have value B for parameter 2

I'm using sql server 2005 enterprise, when reading the MS data-driven subscription example I can only enter users and export format

Business Intelligence professional

Multiple Drill Through Issue when using Report Viewer in SharePoint



I have a report that has a Pie chart and Bar Chart on it.  This report has default parameters on it.  Both the Pie Chart and Bar Chart Drill through to different reports. Looking at the paramater panel of this report all looks fine.

When I drill through on the Pie chart this works OK and the drill through reports this has another parameter on it.  The parameter panel updates correctly.  I then click the return to parent report and this returns correctly but does not update the parameter panel.

I then try to drill through on the Bar Chart (the report is showing the incorrect paramater panel) I get the following error.

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)
Timestamp: Mon, 26 Jul 2010 20:47:20 UTC

Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near '
<!DOCTYPE html PUB'.
Line: 5
Char: 62099
Code: 0

Navigate directly to report



How can you navigate directly to a report when you click on a folder?
Let's say you click on the folder Purchase, then you should get forwarded to SummaryPurchase in stead of the list with reports provided by the report server.
The purpose : this way the users can't view all the reports, only those who are visible in the SummaryPurchase report.


directly exporting report through custom button

Hi All,

I am having a custom report in crm for case. To export this report to word format we have to run the report and export.
to avoid the number of clicks, we created a custom button to export this report directly without running the report.

We took the report url from reportserver and made the click event in button to export the report.
This function is working fine in On-Premise environment. This same functionality is not working in IFD configured environment.
In IFD environment i am not able to export the report directly.

Thanks in advance,

Report - Drill down/Expand details? - how do I create this report in SSRS


I'm having trouble making this drilldown/expand details report. It is probably simple - but is beyound the basic drill down examples that I have found.

My data has multiple rows per product because 2 of the columns are joined with tables that include multiple rows per product. This is related products and prices for quantity intervals.

Is it possible to use grouping so that I could have these show as 1 row per product and then be able to expand the information

Any solution will do – it could be like this:

Disable drill through in excel rendered report


There is a drill through report. when this report is rendered on excel, and clicking on that drill throught text box is throwing an error. How can we disable the drillthrpugh link on excel rendered report?

Please suggest..



Reporting Services 2008 R2 - slow response on first report and after a certain timeout period


We are using Reporting Services 2008 R2.

We have a Windows Forms client with a main form using a webbrowser control to display the report Home page provided by Reporting Services.

We are finding that the loading of this page is very inconsistent. The first time we load the Windows Forms client at the start of the day the page takes too long, more than 10 seconds. After the first access, the Home Page displays in less than a second. If we don't access the Reporting Services for 20 minutes (estimate), we are back to the 10 seconds for initial load. Can someone explain what is going on?

We have tried to create a subscription to a simple report, this didn't help. We tried to create a console app to make a web request to the reporting services url every 10 minutes, this didn't help. We have looked at the rsreportserver.config and the RecycleTime entry put that doesn't really make sense why this would need to be increased considering it's at 12 hours by default. The issue that we seem to be having is happening on a shorter interval.

Does anyone have any suggestions?

Thank you!

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