.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

Dynamic Reporting in Sharepoint 2010

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

Hi, i have Windows Server 2008 SP2 and SQL server 2008 R2 setup and Sharepoint 2010 RTM trial on my machine. I want to use business intelligence Services in sharepoint. I wanted to know that Is Sharepoint 2010 gives us the power to generate dynamic reports from Cubes ?


View Complete Post

More Related Resource Links

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

SharePoint 2010 Reporting Services Integrated-mode Error

I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

Windows Sharepoint Foundation 2010 - Document Library Settings with Reporting Services 2008 R2 in in

I have a client who has recently upgraded their SharePoint system to Windows Sharepoint Foundation 2010 with Reporting Services 2008 R2 in integrated mode. I have configured reporting services and am able to deploy reports to SharePoint. The client created a document library before the upgrade to WSF 2010. I need to add Report Builder 3.0 to the New Document menu and found the following article. http://technet.microsoft.com/en-us/library/bb326289.aspx "Allow management of content types?" is set to yes under the advanced document library settings. The problem is that when I try to "add from existing site content types" the reporting services content types are not in the list. I appreciate any help you can give me.

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

SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

How to change SharePoint 2010 Web Analytics Reporting Schedule?


Hello Everyone,


In the Site Collection Web Analytics Reports, the Data Last Updated  time is always shown as 2.00 AM. We need to update usage data more frequently. Therefore, please let me know where to change this schedule.

Tried running following timer jobs, but no luck,


Health Analysis Job (Daily, Web Analytics Data Processing Service, Any Server) 

Microsoft SharePoint Foundation Usage Data Import  

Microsoft SharePoint Foundation Usage Data Processing  




SharePoint 2010 and Reporting Services 2008 R2 Integration Fail - Failed to establish connection wit


We have installed SQL Server 2008 R2 Standard Edition on a virtual server (C-SQL) and SharePoint Server 2010 on another virtual server (C-SPOINT), with the SQL Backend of the SharePoint database residing on C-SQL. This worked fine.

SQL Server was installed with the domain administrator account and SharePoint with an account called 'visi' that has domain administrator privileges.

SSRS on C-SQL was initially installed as a native database. I changed this to a SharePoint integrated database with all authentications done as the visi user. Report server url was set to the normal http://C-SQL:80/ReportServer/.

On the SharePoint central administration site under General Application Settings -> Reporting Services Integration I filled in the details as required:

  • Sharepoint Server 2010: Reporting Services Integration - 401: Unauthorized


    Hi everybody,

    I know - there are lot's of articels, posts, etc.. about configuring Reporting Services in Sharepoint 2010 and I feel like I read them all hundred times at least... but none of them helped me solving my problem.


    I have the following Scenario at a customer:

    Servername / Functionality

    db01 / MsSQL 2008 R2 server (also contains the ReportServer DB - of course it's type is Sharepoint Integrated)

    app01 / Sharepoint 2010 Server (Complete Installation) - used as Indexing Server and running some other Service, Central Administration, Reporting Server

    *fe01 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

    *fe02 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

    *member of Windows NLB


    I configured Reporting Services Integration in Central Admin and everything worked perfectly correct - no errors - strike!.

    But now comes the "funny" part:


    If I open a Report on a Sitecollection like http://app01:1234/ the report is getting rendered and presented - yeah!

    But if I open a Report on a Sitecollection like http://NLB-URL/ the report throws an error (damn!):

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    SharePoint 2010 & Sql 2008 Reporting Services Integration


    Need a little help.  Here is the error message I recieve when trying to add the Reporting Services URL in Central Administration

    Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages

    Here is the report from the Log.

    10/20/2010 14:31:56.58  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  Configuration Pages            aabe Medium   RS configuration object updated with RSServerUrl=http://sql2/ReportServer, AuthenticationType=Windows 58bcdd3b-13e9-4bd7-8008-718e5fd7202a
    10/20/2010 14:31:57.61  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  SOAP Client Proxy              0000 High     Exception encountered for SOAP method GetSystemProperties: System.

    Reporting services and Sharepoint Foundation 2010 + SQL Server 2008 R2 RTM - Express with Advanced S



    is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services Integration in Central Administration).

    Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...

    Thank you!

    Adding dynamic watermark to SharePoint 2010 document when open? (on browser view)


    hi all,

    In Sharepoint 2010, how to adding dynamic watermark to word 2010 when opening?

    I thinking,

    may be just need configure in sharepoint 2010?

    or need sharepoint develop?


    What you guys think? Any thoughts are welcome!

    Thank you!


    Report viewer webpart in sharepoint 2010 foundation with Reporting server in native mode, possible?



    We have a product on sharepoint 2010 whose major feature is with the reporting services, we are checking to see if our product can be deployed in a minimum environment of sharepoint 2010 foundation.
    we have a minimal test environment with the following :

    windows server 2008 R2
    SQL Server Express Advanced
    Reporting services configured in Native Mode
    Sharepoint 2010 Foundation.

    I would like to know if we can enable report viewer webpart on sharepoint foundation 2010 with the reporting services in native mode. our plan is that even if the reporting services are not in sharepoint integrated mode, we are thinking of using web services to get XML data and using the XML data in report builder 3.0 to generate reports? will the idea work in this environment? if so can anyone let us know how to get the report viewer web parts in this environment?

    Thanks for any help,

    - Asif

    Reporting Services 2008 and SharePoint 2010


    I have Reporting Services 2008 and it is not configurate yet, we will buy SharePoint 2010, but we need to begin to work now with Reporting, can I configurate Reporting before SharePoint and when we have SharePoint, I can reconfigurate Reporting? or we can wait for SharePoint



    SQL 2008 R2 Reporting Service SharePoint 2010 Add-in Installation problem - Interrupted


    WIN SERVER 2008


                                        http://myserverdomain/reportserver -- I can see my subsite, and at footer it shows SQL SERVER Reporting Services Version

    Sharepoint 2010   ---  Installed, before I install Sharepoint 2010, I run the "Install Software Prerequisites", since my server doesn't have Internet connection, I manually download all those components(hot fix KB976462, Filter Pack 2.0, etc.) and then copy to server then do the installation.

    I am trying to install the 'Reporting Services Add-In for SharePoint'.  (downloaded rsSharepoint_x64.msi), its rolling back the installation at the last step and showing me the message saying"Please Ensure Microsoft Sharepoint technologies is installed".



    Short Overview of SharePoint Features in Visual Studio 2010

    As you probably know, Visual Studio 2010 was announced earlier this week and it contains a lot of cool features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.

    How to get more information about the exceptions that can happen in SharePoint 2010 projects?

    In case there is an exception anywhere in the SharePoint 2010 project (most common place an exception would happen is during deployment of your SharePoint project, custom deployment configuration or custom deployment steps), there's a registry key EnableDiagnostics available for you to use.

    InfoPath 2010 cannot connect to SharePoint 2010

    You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error
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