.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

SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

View Complete Post

More Related Resource Links

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

How to set the IP addresses for teh report server on sql server 2008 reporting services

How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

SP2010 + Reporting 2008 R2 + Analysis Services 2008 R2

I want to create a solution based on sp2010 in which the users can create their own reports with Report Builder and have an Analysis Services cube as the data source I did is the following : i have activated the Site collection features for reporting, i have created a data source which is the cube, i've created the model and also added the reporting document types to a document library and now i am ready to create reports The problems comes when i want to create this from a location outside the server. It doesn't work and gives me the following error : Semantic query execution failed.  (rsSemanticQueryEngineError) ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted) The location from where i want to access is a computer from another domain but i log in with a SP2010 user and also pertaining to the SP2010 domain. This user has Member Site rights for the Report Model, dataset, report. DataSet1 is the default name assigned by the Report Builder. The issues appears if I define the dataset before the report or during the report creation with the Report Builder. The authentication for the data source is windows authentication, the permissions for the model are inherited from the site, and the dataset credentials are set to Use

Selecting ODP.NET (provider for Oracle) in Reporting Services 2008 R2 x64, Report Builder 3.0, Busin

We have a requirement to connect Reporting Services 2008 R2 x64 + Report Builder 3.0 to Oracle database and also to build a web application which connects to Oracle. I installed ODAC (Oracle Data Access Components) which contains ODP.NET (Oracle Data Provider for .NET) and Instant Client (required by the provider). Now the problem is how to make Report Designer, Reporting Services and Report Builder 3.0 to add ODP.NET as an Oracle provider in the drop down list contained by the Data Source Wizard? I found out that Reporting Services and Report Builder work based on Data Extensions so I added Oracle.DataAccess as extension to RsReportServer.config and RsReportDesigner.config as shown in: http://www.bigresource.com/Tracker/Track-ms_sql-aIXqXMEE/. By changing RsReportDesigner the ODP.NET appeared in the list for Report Designer (Business Intelligence Studio) but it couldn't be used because an error was thrown as soon as Test Connection was pressed stating that the provider is not registered with the application. With these changes ODP.NET does not appear in the list of providers for Reporting Services and Report Builder 3.0. For now I managed to connect to Oracle through .NET Provider for Oracle (provided by default) but this seems to be deprecated and in Report Builder 3.0 I can't select tables to be added to the query, I'm prompted only with a blank textbox and one excla

SQL Server 2008 R2 Reporting Services - How to I run a report and save the output as a .pdf on the s


I have the source code for doing what I want to do using a previous version of SSRS.  Since the new release, the service seems to work differently as I can't find any of the methods in the WSDL:

//Validate txtEmail for inputting

lblPrompt.Text="You must enter a valid email address!"

lblPrompt.Text="You must enter a valid email address!"

//Get report

TimeSheet.wdsg_svr003.ReportingService rs=new


Reporting Services 2008: "HTTP status 401: Unauthorized" Issue


I'm getting the error "The request failed with HTTP status 401: Unauthorized" whenever I try to list the reports on my reporting server. The weird thing is, it works when I run the asp.net application on my dev machine hitting the server reporting services web service url (http://www.example.com/reports/reportservice2005.asmx?wsdl) but when the asp.net app is installed on the server (running iis 7) hitting the same url I get the error. Here's my set up:


SQL Server Reporting services 2008 (not R2)

Web service url: http://www.example.com/reports/reportservice2005.asmx?wsdl


Created a proxy ReportingServices2005.cs

Web.config has <identity impersonate="true"/>

Code to list reports:

<asp:ListView ID="lvReportList" runat="server">
            <asp:PlaceHolder runat="server" ID="itemPlaceholder"></asp:PlaceHolder>
            <asp:HyperLink runat="server" ID="hpReportLink" NavigateUrl='<%#Eval("Url")%>'><%#Eval("Name")%></asp:HyperLin

upgrade Reporting Services from 2008 to 2008 R2


Hello to all, 

I am a new to Reporting services so if anyone can help, I would be very grateful.

I have a task of updating SSRS 2008 to SSRS 2008 R2 and am currently researching what needs to be done.


The reporting server instance/database resides on a node of a 2 node active/active cluster. 

Do I need to run the setup.exe for R2 on each node ? Or only the node that contains the Reporting server instance/database ?


Is there anything else I need to install or is there any conversion to take place on the reports? 


thank you in advance 


Reporting Services 2008 report integration in a gadget


Hello everybody,

I would like to distribute a small report I have made in Reporting Services which contains only one graph by using a Windows 7 Gadget. Does anybody know how to integrate a MS SQL Reporting Services 2008-report in a gadget?

Your answers are greatly apreciated.


Kind regards,


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!

SSRS Reporting Services issue with Rendering Report.


I have created a report that has a tablix with a single cell.  The tablix is set to a dataset that has multiple records, and for each record I am running another subreport inside the tablix cell.  I have the subreport creating a page break for each record, and when printed out the report is perfect, but in the interactive rendering mode with the SSRS Web Viewer, one of my pages comes out blank except for the header being present.

It is not adding an extra page, because in the print out that particular page is rendered with the correct data, but in the interactive mode it is completly missing. 

I would appriciate any advice someone might have.

Thanks in advance.

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP


Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003

Excessive Deadlocking Reporting Services 2008 Integrated.

Hi, we have a major issue with deadlocking on our reporting Server TEMPDB (REPORTSERVERTEMPDB). The platform is a Sharepoint Integrated platform allong the following lines 2 WFE Servers (NLB) 2 Sharepoint application servers 2 SQL Reporting Services (NLB) Cluster hosting Sharepoint DB's Cluster hosting Reporting Services DB's and the Data. This error is occuring for both manually running reports via sharepoint and load testing, and is happening on our testing platform as well which is slightly different in configuration. Reported back to the users is "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database" Running a profile with 1224 set, we are finding deadlocks on the REPORTSERVERTEMPDB on PK_SNAPSHOTDATA. We have tried the following 1. Dropping the PK - The deadlock was then showing an OBJID which we could not identify. 2. Change the database properties to READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to ON 3. Re-create and change the PK to ALLOW_PAGE_LOCKS OFF None have these have had an impact on the issue This has become apparent since the following actions were taken 1. The setting of caching has been enabled by the developers 2. The Report Server DB's were moved from the Sharepoint Cluster to the Data Cluster. I do have an XDL file from Profiler but it is to

SQL Server 2008 Install failure - Reporting Services Rule Failures

I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

Coloring sql reporting services report depending on the change of value of a certain field

Hey guys, I have an SSRS report that looks something like this: Column1 Column2 Row1 2 A Row2 2 B Row3 2 C Row4 6 A Row5 11 E How can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color, then I'd go back to Row1's color for Row5? note: I don't know in advance the numbers returned in Column1. I query for them and then I hide them from the user so Column1 shouldn't show on the report, but I want to use it for the coloring only.
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