.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 report not able to show any data in ie6 and ie7 although found working in ie8 and firefox

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

we have a SSRS report which was working till few weeks backs on all the ie and started to show Diagnose the Internet connection error on ie6 and permission denied on ie7. although the report is running fine on ie8 and firefox with same security settings. There has been no recent changes done to the report. tried it through fiddler but gives a 200 status for http. IS also connecting to URL and is making connect to the DB. HAve tried to check the script and activex settings also and found nothing absurd which can stop the functionality.I have tried reducing the security to low also but with success. Can someone please help.

View Complete Post

More Related Resource Links

Data source not found issue in subscribed report (subscribed in ssrs 2005) , with shared data source


Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.

 1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.

2) The reports use a shared data source with name ‘Test Center’

3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!

4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.

5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.

6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.

- Thanks & Regards, RaSuHe

show part of the Cube data in SSRS report prompts



I have generated one report in SSRS 2008 report designer, and one prompt was added in it. when I am running this report, selecting the data from prompts, it shows all the Cube data for this field.

But I want only a small part from cube data, how can I make this? Thanks!


Connie Zhu

SSRS Report based on SSAS Cubes doesn't show NULL values correctly

I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?  

what kind of a report to be created in SSRS when the requirement is to show the Summary and Details

I have some reports to be developed where I need to show the Summary and the details of Students/Particular Product, Please advice what kind of Report format/ drill down or is there a way that on clicking on the summary it would show Details in a child report using SSRS 2008. it would be helpful if there are some tutorial links too thanks in advance for response.

SSRS 2008 - Data Source cannot be found in Preview

Hello; Something weird is happening to me - Never happened before on 100's of reports using Shared Data Sources. I have a Shared data source defined and when I try to preview a new report, I get a message saying that "The data source 'ProjectList' cannot be found" When I created the dataset, I pointed it to the shared data source. I can preview the data when I run my query from query designer, so it's obviously seeing my shared data source. If I use an embedded data source, the report renders just fine. I'm using SSRS 2008R2 BIDS to develop the report - the data source is hosted from a SQL Server 2008R1 database. Anyone ever seens this? How'd you get out of it? ThanksThanks Ron...

SSRS report, doesnt show default value in paramaters when viewed in reportserver

Hi   We have a problem where we have a report that we have deployed to the production SSRS server, when I view the paramater list on the production reporting srver the particular report has the HAS Default paramater ticked, but the default value drop down selected value is blank yet the values are available in the drop down.   When looking at this in system test the default value is loaded.   When comparing the two RDL's they are identical and when loading the report files in Development tools the default value is selected, has anyone come accross this before ?   Ben

hide gridview column using javascript. working in ie and firefox but In firefox, gridview data is sh


function EnableDisableGridViewColumn() {
               var AdvanceSearch = document.getElementById('<%= chkboxlist1.ClientID %>');
               var chkList = AdvanceSearch.getElementsByTagName("input");
               var dgTest = document.getElementById("gridview1")
               if (dgTest != null)
                   for (var i = 1; i < dgTest.rows.length; i++) {

                       if (chkList[0].checked == true && chkList[1].checked == true) {
                           dgTest.rows[0].cells[0].style.display = "block";

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

How to show varbinary data on the report builder normally?


Hi everyone,

The varbinary column type data will show #error on the report builder, is there a way to show it correctly? convert or other?


Where there is great love, there are always miracles.

SSAS Calculated Member not working as expected in a SSRS report


Dear forum guys, I have a simple cube to analyze my customer's sales. I have a Time Dimension, a Product Dimension (with a few hierarchys) and a couple measures (sales and purchase amounts).


I also have defined a few Calculated Members, in particular the average sales and purchase amount over the last 12 months from the selected month.


I need to show the results in a SSRS Report: the user must select a month and the report needs to show the sales and purchase amount of the selected month and the average of the previous 12 months (both for sales and purchases).


Everything works perfectly if I test the cube using the Cube Browser or Excel 2007 as a client.


When I define the SSRS Report I cannot get to work with the calculated members (the average): I get strange numbers which are much higher than the real numbers.


I've tried both Matrix and Table reports.


Can anyone suggest me what I'm doing wrong: I think this should be a very common mistake.


Best regards



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?

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 2005 report export to excel - show text as number


When exports the report to excel, some columns are numbers(something like 00125987). We need these columns to be text,  but excel convert these columns in numbers and in result we received not "00125987" but "125987".  

How to fix that? 

We need all these columns to be text.



Export SSRS report to excel with data of pie chart



I am new to SSRS. I have a report with a pie chart . When I export the report in excel format, pie chart is displayed as picture. I want it to be displayed as editable pie chart with data. 

The requirement is, if user want to change the data in excel sheet after exporting, changes should reflect in pie chart of that excel sheet.

Please suggest me the way of achieving it.


Generating SSRS report by taking data both from sql server and web service.



In my report, i need join data from both sql server and web service and display that on ssrs report.

is this possible in ssrs ?


SSRS 2005 Report Writer Limitation- 128 Max Length for Query Strings Constructed in Data Tab???!!!


I'm trying to construct a SELECT query within the Report Writer 2005 Data Tab as follows- ="SELECT blah..." & SomeFunctionToConstructWhereClause() " ORDER BY 1"

When the length exceeds 128 characters, I get the following error (works otherwise)- Microsoft Report Designer Incorrect syntax near '='. <QUERY TEXT> The identifier that starts with is too long. Maximum length is 128.

Say it isn't so or that there is a reasonable workaround for this. 128 characters isn't that much when you're talking about complex query strings. Thanks in advance.

SSRS working fine in Report builder and manager but not in Report viewer


HI I have a report that worked fine until we upgraded the SQL server from 2008 to 2008 R2 and the report viewer to latest version as well.
This report has a pie display, NOW instead of showing one pie, it is showing 20 pies!

I am trrying to learn how to resolve and what is causing this. 

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