.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

Report Builder in sharepoint is not working.

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


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

View Complete Post

More Related Resource Links

SSRS 2008 R2 and sharepoint 2007 report builder problems


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

Report Builder 3 report preview error in SharePoint integrated mode

Hello folks! I've faced some strange error with RB 3.  My environment is: Win 2008R2+SQL2008R2 CU3+Sharepoint Foundation services 2010 SharePoint services integrated with Reporting Services.  When I try to run RB3 from SharePoint library and built some report I get strange error at the previw screen : Failed to preview report. The item 'http://myserver/cd6409dc-1089-4e8a..' cannot be found. Details: System.Web.Services.Protocols.SoapException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found.    at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)    at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)  The most intresting thing, that my test environment with Win 2008R2 CTP+SQL2008R@ Nov CTP is working properly without any error. Could you please advise how to resole this problem? Thanks in advance, Andre.  

Use Report Builder 3.0 with SharePoint site using a port number

We are currently working with SSRS R2 and SharePoint 2010.  SharePoint 2010 has been deployed a multitenant solution.  SharePoint and SSRS are on separate servers.  We have successfully integrated the two products but are experiencing some anomolies.  The SharePoint site we are deploying to uses a port number (e.g. http://mysharepointsvr:2222).  When you launch Report Builder from this site, it does not open connected to a Report Server.  When you try to connect to a Report Server the obvious choice is to put in http://mysharepointsvr:2222 for the Report Server service.  However, this does not work.  We are getting the following error: Connection Failed.  Unable to connect to the server that is specified in the URL, 'http://mysharepointsvr:2222'.  Make sure the server is running, the URL is correct, and you have permission to use the server. However, if we use the SharePoint address without the port number it will connect.  This does not work as the SharePoint port determines which site we are directed to for resources.  In our case, we need to be able to browse the folders on port 2222 not port 80 (default).  As far as the error above is concerned, we are able to browse to the report server (http://sql101/reportserver) and see all of the SharePoint sites.  In all cases, identical credentials are being u

Sharepoint 2010 Standard Edition Custom List Reporting Using Report Builder 3.0


hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

i tried to run the report, the parameters were shown as expected

but the problem is when i create a query in the dataset.

i'm using caml query builder for the query expression. it goes like this :

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>IT Helpdesk</ListName>
    <FieldRef Name="Employee_x0020_Number" />
    <FieldRef Name="Title" />
    <FieldRef Name="Department" />
    <FieldRef Name="Category" />
    <FieldRef Name="Time_x0020_Spent" />
    <FieldRef Name="INT_x0020_Time_x0020_Spent" />
    <FieldRef Name="Severity_x0020_Level" />
    <FieldRef Name="Ticket_x0020_Source" />

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server


I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

Sharepoint 2010 Audit Logs with Report Builder 3.0



I'm trying to create a report using Report builder of a sharepoint 2010 list's custom audit log, is there a way to create a report using report builder 3.0 without directly using sharepoint's Database tables?


Report Manager URL http:///Reports is not working in SharePoint Integrated Mode


Hello Friends,

I am ali, I am so confused why the Report manager URL(http://<servername>/Reports is not working in sharpoint integrated mode. 

In my local system

1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.
2  In Reporting service config manager tool http://<serverName>/Reports URL is working in Native mode. Here i am able to create New Roles.
3. In Reporting service config tool When i create a new database in sharepoint integrated mode, the the Report Manager URL http://<ServerName>/Reports not working, gettig this error "This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)"
4 . From both databases(In native mode and sharepointmode) the the webservice URL http://<servername>/ReportServer working fine.

Reporting Services Config manager :

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. 

Report Builder returning #Error value in empty fields and working with Date field


Hey guys,

I am trying to build a report using the date field from CRM and only wanting to return the date I am using this expression "=Fields!new_date.Value.ToShortDateString()" but when there is an empty fiel I get #Error. How do I solve this?

Also is there anyway to return the date field with the actual month showing instead of the numerical value? i.e. instead of 1/31/2010 Have it show January 31, 2010 (Doesn't have to be exactly in that format, but want the name value for the month.)

Connectiong String For SharePoint List Using with Report Builder 3.0 ?


Hai Friends,

     I am Ali, I need to retrive the all lists in to Report Builder and need to prepare Report and need to deploy in Sharepoint Library.

1. I Configured Reporting Services in Sharepoint Integrated mode and Credentials are in Windows Integrated Mode not in Trusted acount. 

2. In Report Builder 3.0 Connection Type "Microsoft Sharepoint List"

3. Connection String 'http://<server name>/sites/<site name>' like this, when i test the connectinons getting this error (The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.)

Please anybody help me to proceed next steps.



MD.Liakath ali

Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

Email this Post in SharePoint Blog is not working for Lotus Notes 6.5


I have tried "Email this Post" in a SharePoint blog. I got the email as desired, but the doesnot resolve the post.

Here are the link examples:

I got the link in email as mentioned below:


But i should get as below to resolve the link:


Any ideas?


In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Sharepoint 2007 Search Not Working


I am pulling my hair out guys. I have tried everything i could find from this site and all other sites but have not been successful. No matter what i do I cannot get the search to work. We are using SharePoint 2007 and the search had been fine but our security team performed some patches and now I’m stuck with a dead search feature.

Any help would be immensely appreciated.

Things I have tried but did not resolve the problem:

1. Check all accounts and passwords

2. Run the SharePoint Products and Technologies Configuration Wizard

3. Reboot server reset IIS

4. Try to rebuild the index but that also fails

5. Check the Content Access Account

Office Sharepoint Server Search not working but Windows Server Search is.

I am having an annoying Issue with the Sharepoint 2007 Enterprise search functionality. I cannot get the Search Centre to work, the out of the box webparts crash the page except the Searchbox when the others are closed. The event viewer shows up numerous Errors (Office Sharepoint Server - EventID 7080) returns with and the same when trying to add a search related web part (e.g. core.results, federated etc). EventID 6398 - Timer is a regular as is 7080. Details below.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

Remote connections are connected, I am not 100% on the Instance name, (how would I go about checking this?)

Also I cannot access the link to SharedServices1 - Open Shared Services Admin site (not clickable), guess it's permissions but I seem to have full site permissions, I think I need SSP-Admin to make more edits to the Search, maybe this is related :s

Both Search Servers are runnig, I have tried everything I can think of to fix this and allow the Search Centre to work.

I am running Sharepoint 2007 on SQL Server 2008.

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

Item cannot be found.(rsItemNotFound) when executing a report from a sharepoint Website

I have managed to integrate Report server with Sharepoint .
I created a report with it's data connection with microsoft Visual Studio 2005 , tested it , than deployed it to the specified document libraries in sharepoint.
Everything works fine till now.But when i try to execute the report from the document library in sharepoint the Message :
  • The item 'Reports/Report1.rdl' cannot be found. (rsItemNotFound) '. Even though the report1.rdl is inside the website and is returned when i do the search. Regards.

  • Categories: 
    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