.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

Business Intelligence Issues SQL Server R2

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :SharePoint


I have an extensive Report library surfaced in SP2007, no problem at all. However, we have recently upgraded our systems, and Im now using SP2010. I've created a reports area as the repository, and opened the project in VSBIS 2008, changed the URLS and an error occurs. I can deploy the .rdl files no worries, but the .rds file throws the following error - collected from the eventlog

' The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.'

I have looked at the blocked file types and .rds isn't in there.

All in all im a bit confused by SP2010 and SSRS reports. Any pointers or help with this issue would be greatly appreciated.




View Complete Post

More Related Resource Links

Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

How to enable SSIS functions from MS SQL Server R2 Express Business Intelligence Studio Express


My MS SQL Server R2 Business Intelligence Studio Express can not support SSIS functions after I install MS SQL Server Full Evaluation instance and the SSIS service is running well on my Window 7 professional laptop. Is there anyway to enable the SSIS functionalities from the original Business Intelligence Studio Express? Thanks for your help.




Create and Deploy Charts using SQL Server Business Intelligence Development Studio 2005


Hi All,

Does any one have good blogs for creating different types of charts using SQL Server Business Intelligence Development Studio 2005 which pulls data from the sharepoint list and display in graphical format. iam new to SSRS.

Thanks in advance

Microsoft SQL Server Business Intelligence tool


May I know when will next version of SQL Server 2008 R2 be released?

Just wanted to see on VS 2010 compatible version.

SQL Server Business Intelligence Development Studio not found


I have installed the evaluation version of SQL Server. When i click on the Intelligence Development Studio link it starts looking for the file devenv.exe. The file is not on the pc. Repeated installation twice making sure that all components are selected. What is causing this file not to be available?



SQL Server Business Intelligence (MAPS)

Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)
The Spatial components for SQL Server are new to the 2008 release, they are a core part of the server product (excluding compact edition) rather then an extra add-on or product version. There are some great walk through''s of the full functionality available, I highly recommend David Lean's samples 1 through 9 for a run through of all the new functionality available.

Something very simple to visualise within the built-in spatial viewer of Management Studio are the countries of the World:



Business Intelligence Development Studio



            I installed Visual studio 2008. I want to open Reports. I want to install Business Intelligence development studio for that.

May I know how to install that one. Is Business Intelligence development studio comes with Visual studio 2008.

Please tell me, I m new to this concept.


Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

What is BPEL4WS?: Build Better Business Processes with Web Services in BizTalk Server 2004


In this article the author focuses on one critically important Web services specification that has been largely overlooked: the Business Process Execution Language for Web Services (BPEL4WS, or BPEL). He describes why BPEL is important and what it offers you if you are implementing Web services today or planning to in the future. Concrete examples using BizTalk Server 2004 are presented in the article.

Jon Fancey

MSDN Magazine March 2005

Migrating aspnet tables to dev server - having issues



We're trying to migrate a one of our apps to our dev server for testing and development, but we're having problems with the membership functionality. We can add users, but there seems to be a disconnect with roles. We can query the aspnet_users table and find the new user in there, but when we query the aspnet_usersinroles table, that user id is not present.

We're also unable to run the Roles.GetUsersInRole("somerole") method. It returns 0 records. When I run Roles.ApplicationName, it returns the correct name, so .NET should be passing the correct app name.

We're just a little baffled. If anyone could shed some light on what could be the issue, we would appreciate it.

Thanks! :)

Developer Training: Business Intelligence SharePoint 2010

SharePoint 2010 provides a flexible platform to expose business intelligence (BI) functionalities for end users by using platform capabilities, all through a familiar user interface. This training module shows how.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Video: What is Business Intelligence in SharePoint 2010?

Learn about the SharePoint 2010 Business Intelligence (BI) tools for bringing information together for analysis and collaboration to support business decisions. Available tools include status indicators; chart Web Parts, PerformancePoint Services, Excel Services, BI Search, and Visio Services. (Length: 11:51)

Video: SharePoint 2010 Business Intelligence (BI) Primer

If you are new to BI, this video will get you up to speed quickly. You will learn about some of the new BI features in SharePoint 2010, such as Excel Service and PerformancePoint Services. (Length: 11:51)

Video: Excel Services and SharePoint 2010 Business Intelligence

In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

Video: PerformancePoint Services and SharePoint 2010 Business Intelligence

PerformancePoint Services is all about surfacing data to users in a dashboard format to allow users to create business decisions based on the dashboard information. (Length: 11:51)
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