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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS 2008 R2 and sharepoint 2007 report builder problems

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

View Complete Post

More Related Resource Links

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

SSRS 2008 R2 - Query builder freezes and needs to be shut down Report Builder 3 when attempting quie

Hi, In SSRS, using Report Builder 3.0 (SSRS R2), after choosing a Report Model as the report's embedded data source, launched "Query Deisinger…" from GUI to build data source in report.  First 1-2 attempts at querying underlying data source (Oracle back-end), are successful, but later attempts freeze application to the point where application freezes and overall Report Builder application needs to be forcibly shut-down. This system freeze has occurred when referencing tables containing a very small number of records as well as larger data sets.  Suspect that application freezing may be caused by timing-out of connection to back-end database. but I am not sure. Any suggestion to solve this issue? Thanks   Environment - Distributed deployment Server1(report_srv) --Windows server 2003R2 64bit, Installed sql server 2008R2 reporting service, configuration tools Server2 (report_db_srv) --windows server 2003r2 64bit, sql server 2005 for report server database

Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

Report Builder 3.0 Compatibility with SSRS and Sql Server 2008 (not R2)

I've built reports in Report Builder 3.0 (which I love!). I tried to deploy the reports to an instance of SSRS installed with SQL Server 2008 (not R2). I can't deploy the reports - it appears SSRS is not forward compatible with Report Builder 3.0 reports. Would SQL Server 2008 SP1 help? Is there anything I can do to use Report Builder 3.0 with SSRS 2008?

Unfortunately, I cannot install SQL Server 2008 R2 in the production environment (yet).

SSRS 2008 R2 report builder 3.0 map wizard bubble color not showing up


Some blog posts out there show an option for bubble color in the map wizard. Currently I only see an option for size.

Is this something that didn't make it out of beta?


SSRS 2008 R2 and Sharepoint 2010 - performance problems


Hi all,

I'm currently in a DWH project using SSRS 2008 R2 x64 in Sharepoint Integrated mode along with Sharepoint 2010, and we're seeing massive performance problems even though traffic on the server is at a bare minimum. We're in development with a maximum of a few users online at any given time and the server itself isn't doing a whole lot...cpu is usually < 20%. We have timed the database queries and 90% of them are taking less than a second to execute while reports takes anywhere from 5 to 30 seconds to load (some heavier reports can occasionally take a lot longer). I am simply unable to get anything to load in less than 5 seconds, even the simples grid from a SELECT TOP 5 * FROM table query takes this long.

The server setup is suboptimal as SQL Server, Reporting Services and Sharepoint are all running on the same virtual machine but with the minimal amount of traffic we have this shouldn't really be a problem. The server is a Win 2008 x64 Datacenter with 4 CPU's and 16GB RAM.

A standard sharepoint page that gets data from the database is returned in milliseconds...why doesn't reporting services do the same? What can I do to increase performance?


Issue with toolbar when loading the RDL (upgraded to ssrs 2008 R2) via report viewer in MOSS 2007 se

Our front end server is Office SharePoint Server 2007 and the RS is SSRS 2008 R2 (native mode).

The toolbar is different when loading the same RDL (upgraded to SSRS 2008 R2) through report viewer and report manager. In report manager, the toolbar is color blue while when displayed through report viewer the color of the toolbar is light brown/yellow. Color blue indicates it is using the latest version of SSRS while the other color for previos version. Aside from that, the font of several texts in a table has increased to one point when viewed via report viewer compare to when viewed via report manager.  Is there an existing fix for this?

Can't see any data after publish SSRS report to Sharepoint 2007



I'm using SSRS 2008 R2 , MOSS 2007 and report Builder 3.0 To generate cascading reports with sharepoint 2007 lists.

I'm able to filter and see the data correctly within report builder .

But if i upload the same RDL file to Sharepoint library and then tries to view the report,i'm not getting any data.(absolutely zero records) 

I'm using Report builder 3.0 and sharepoint list as connection string.

Interestingly, if i'm ising XML as a connection string to pull sharepoint list data and then publish the report to sharepoint, i'm able to see the data within sharepoint correctly and i'm able to use the cascading filter and can view the correct data.

Please advice on why i'm not able to see the data if i'm using the connection string" sharepoint list "

This issue is same even if i'm using BIDS 2008 and sharepoint list as connection string.

i would like to use sharepoint list as connection string because of the ease of using it.

Thanks in advance!!


Best Regards, Ashok Yadala | Senior SharePoint Consultant

Upgrade from SQL Server 2005 to SQL Server 2008 from SharePoint 2007 SSRS 2005 integrated mode


I"m attempting to upgrade from SQL Server 2005 to SQL Server 2008 R2 x64 Enterprise on a server running Windows Server 2003 x64 Enterprise, SharePoint 2007 Enterprise, and SQL Server 2005 and SSRS 2005 Enterprise running in integrated mode.

I installed the Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en.

When attempting to install Report Builder 2.0, I get the error "Reporting Services Add-in for SharePoint products and technologies is not installed."

When I try to run a report (existing 2005 reports already deployed), I get the error: "Operation is not valid due to the current state of the object." The log has repeating ReportingServicesService.exe errors: #20015: Cannot open "Resources.en-US.resx": no such file or folder, and: Localized resource for token 'ManageDatasetCaching_Desc' could not be found for file with path: "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Features\ReportServer\ItemCustomActions\ecbExtension.xml" among other things.

I've tried rec

SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

Report Builder in sharepoint is not working.



We are using below Topology in production
Topology is 3 servers:
Sever1: Sharepoint Form (wss3.0 no MOSS)
Sever2: Sql server 2008
Server3: Reporting Services 2008
Operating system on 3 servers: Windows server 2008.
Authentication mode: Form based authentication.

 SSRS reports are working success fully in SharePoint using above topology, The issue is through SharePoint library when i am trying to access report builder reports the client is installing, after enter the credentials it is not connecting to server and am getting the following error "Unable to connecting server at 'http://servername/Reports/Forms/AllItems.aspx'  please use different url

The above issue on production only.

But in local development box there is no problem (in my development box SharePoint t, database (sql) and reporting service sits on my box only)

Thanks for your he

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.




What is the best way to Create Ageing Report in SharePoint 2007?


Hi Experts,

I need your point of view about this and please advise,

My client have made a request to generate Ageing Report thru their SharePoint 2007, FYI all invoice was scan and upload to sharepoint and save as PDF file under Document Library. During the scan, certain information will capture automatically and save it into field that we defined inside the Web Form.   

Below is the basic input we capture:

Vendor Code, Vendor Name, Invoice Number, Invoice Date, Currency, Invoice Amount

Report Requirement (display list and group of:)

- Vendor Code, Vendor Name, No. Of Invoice, Total Payable, Ageing 0-30, Ageing 30-60, Ageing 60-90, Ageing>90 

So my question is, what is the best platform to create this Ageing Report??

because when i try to design the report thru Visual Studio (Reporting Services), i can't identified which database should i connect and which table is store all the invoice information in SharePoint.

Any idea guys?? anybody have implemented it before??


OpenSearch Location Builder Tool for SharePoint Server 2007

Download the tool and start using it to create an OpenSearch Description (.osdx) file to connect SharePoint Server 2007 sites to the Windows Client via the OpenSearch protocol.

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.
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