If your Report Server 2008 instance is configured as SharePoint integrated and you get an exception like this one, keep on reading.
Additionally to the exception in the browser, the Eventlog revealed two more exception which are relevant to the SSRS exception. One was about the SSRS process, which quit unexpected, the other one from ASP.NET.
“The SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. It has done this 6 time(s).
Did you know that the latest SSRS have a build-in support for SharePoint lists as DataSource?
So if you need arguments to update to SQL 2008 R2, this is one 🙂
CardioLog released a reporting add-on for SharePoint, which analyses the usage of your SharePoint sites.
There are several versions available. One of the – CardioLog Lite for SharePoint 2007 – is available at no charge.
Screenshots can be viewed here.Technorati Tags: SharePoint,Reporting,Usage,add-on
The Report Build 2.0 has been released. You can download it here. The Report View Webpart is not part of the download. Read this thread.
Reza Alirezaei has posted about installing and configuring the Reporting Services.Technorati Tags: Reporting Services,Report Builder
Reporting Services Configuration Wizard The SQL Server 2008 Reporting Services do not need an Internet Information Server anymore. You can host your Reports website from within Reporting Services only. If you have installed the IIS, you can still use Reporting Services, because it will register itself via HTTP.sys.
Because we configured the service account during the installation process, it is already configured.
Quote from the SQL Server 2008 Online Books:
Setting up the Reporting Services with a non default database name requires that you create a Script, and change the database names in this script, because otherwise the creation of the databases fails.
Before you can generate the Script, start up the Reporting Services Service in the first Dialog of the Wizard!
In the “Database Setup” Dialog of the Reporting Services Configuration Wizard hit the “Script” Button. (My Database Name is “ReportServer2005).
How about using the available resources from SharePoint to translate some basic words and sentences? Well, it is quite easy to use the available resources. You need the Microsoft.SharePoint.Intl.dll and some lines of code to use the already translated resources: // define yourself variables private readonly CultureInfo _Cult; private readonly Assembly _SharePoint_Intl_Assembly; private readonly ResourceManager _SharePoint_RM; private readonly ResourceManager _SharePoint_WebPartPage_RM; // initialize them in your constructor _SharePoint_Intl_Assembly = Assembly.Load("Microsoft.SharePoint.intl, Version=12.
Even if the Reporting Services are very powerfull, you might get to the point where you have to extend the building functionality. So why not write your own custom assembly with some additional code?
Create your assembly like this:
1: using System;<br> 2: using System.Security.Permissions;<br> 3: using Microsoft.SharePoint;<br> 4: <br> 5: public class MyNamespace<br> 6: {<br> 7: public class ReportingExtension<br> 8: {<br> 9: public ReportingExtension()<br> 10: {<br> 11: }<br> 12: <br> 13: public static string HelloWorld()<br> 14: {<br> 15: return "Hello World.
The Reporting Services shipped with the Express Edition do not support all features. Unfortunately you can only access a local SQL instance. You can not use XML as Datasource, so no SharePoint Reporting 🙁
A list of supported and unsupported features can be found here.
Querying a XML Datasource Query:
«/span>Query>
«/span>SoapAction> http://ns.tld/MethodName</SoapAction>
«/span>Method
Namespace=" http://ns.tld/"
Name="
MethodName" />
«/span>ElementPath
IgnoreNamespaces="True">*</ElementPath>
</Query>
Passing Parameters You only have to define your parameters in the parameter tab of your dataset. They are passed automatically to the Webservice Method. If you want to define your parameter yourself and not use a Reporting Services Parameter, just type
«/span>Query>
«/span>SoapAction> http://ns.tld/MethodName</SoapAction>
«/span>Method
Namespace=" http://ns.tld/"
Name=" MethodName">
«/span>Parameter
Name="ParamName">
«/span>DefaultValue>ParamValue</DefaultValue>
To use custom code in a Report, you can past VB.NET Code into the Report properties. But what if you can only write C# and not VB.NET?
Here is the answer: http://authors.aspalliance.com/aldotnet/examples/translate.aspx
This great .NET translator lets you translate C# into VB.NET J
You can do Reporting on SharePoint Lists with SQL Server Reporting Services 2005 quite easy.
Configure the Datasource with integrated Security
Define a query like </div> <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>SharePoint List Name</DefaultValue> </Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="True">*</ElementPath> </Query> Hit the “Field Refresh” Button to get the Field from your SharePoint List
Drag your Fields in the Report Use the Code to eliminate “ID;#” and “”,"" from your Fields
Mit diesem Diagramm möchte ich die Begriffe Web(site), Sitecollection und Webapplikation verdeutlichen.
<p> <strong>Name</strong> </p></td> <td style="padding-left:7px;padding-right:7px;border-top:solid #9bbb59 1.0pt;border-left:none;border-bottom:solid #9bbb59 2.25pt;border-right:solid #9bbb59 1.0pt"> <p> <strong>Gemeint ist</strong> </p> </td> <td style="padding-left:7px;padding-right:7px;border-top:solid #9bbb59 1.0pt;border-left:none;border-bottom:solid #9bbb59 2.25pt;border-right:solid #9bbb59 1.0pt"> <p> <strong>Objektmodell</strong> </p> </td> <p> <strong>Web</strong> </p></td> <td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid #9bbb59 1.0pt;border-right:solid #9bbb59 1.0pt"> <p> Website </p> </td> <td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid #9bbb59 1.0pt;border-right:solid #9bbb59 1.0pt"> <p> SPWeb </p> </td> <p> <strong>Webseite</strong> </p></td> <td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid #9bbb59 1.
