Reporting Services

Reporting Services Exception

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).

SharePoint Reporting

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

Report Builder 2.0

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

Configuring SQL Server 2008 Reporting Services

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 Reporting Services with not default database name

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).

HowTo use the resource files from SharePoint

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.

Custom assemblies for the Reporting Services 2005

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.

Reporting Services and XML Datasource

Querying a XML Datasource Query: «/span>Query> «/span>SoapAction>http://ns.tld/MethodName</SoapAction> «/span>MethodNamespace="http://ns.tld/"Name=" MethodName" /> «/span>ElementPathIgnoreNamespaces="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>MethodNamespace="http://ns.tld/"Name="MethodName"> «/span>ParameterName="ParamName"> «/span>DefaultValue>ParamValue</DefaultValue> </Parameter>

Create VB.NET Code for Reporting Services

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

Reporting on SharePoint Lists

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

Websites, Sitecollection, Webapplikation

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.