Reporting Services – Knowledgebase

How to collapse / expand a specific row group in a tablix in Microsoft Reporting Services 2008 / Report Builder 3.0

17 November, 2011 Roel van Lisdonk 2 Comments 1 category

Let’s say you want to show costs on a parent child hierarchy in a Microsoft SQL Server Reporting Service 2008 R2 report and you want only to expand the children of parent "John":

Add a 1000 separator to a number in a column of a Microsoft Reporting Services tablix

15 November, 2011 Roel van Lisdonk 0 Comments 1 category

If you want to format the numbers in a column of a tablix in Microsoft Reporting Services, you can use formatting. Just select the tablix cell in the designer and in the properties adjust the

Solving: Access to the path "…..\*.rptproj.user" is denied in SQL Server Reporting Services 2008 R2

3 November, 2011 Roel van Lisdonk 4 Comments 1 category

Solving: Access to the path "…..\*.rptproj.user" is denied. In some cases the *.rptproj.user will be created read-only, uncheck “read-only” on the file and the error will be resolved.

Solving: Error : rsAccessDenied (The permissions granted to user ‘MyDomain\Administrator’ are insufficient for performing this operation.)

11 April, 2011 Roel van Lisdonk 4 Comments 1 category

When deploying reports by using the rs.exe you can get the error: "Error : rsAccessDenied (The permissions granted to user ‘MyDomain\Administrator’ are insufficient for performing this operation.)". Solution Go to the ReportManager [http://YoureServerName/Reports/Pages/Folder.aspx] Site

Install a development Microsoft SharePoint 2010 RTM Server with PowerPivot and Microsoft SQL Server R2 Reporting Services integration

6 May, 2010 Roel van Lisdonk 5 Comments 1 category

These are the steps I followed to install a development Microsoft SharePoint 2010 server with PowerPivot and Reporting Services integration. I installed Microsoft SharePoint Server 2010 by following the steps on: http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint Then

How to deploy a report (*.rdl) file to SQL Server Reporting Services using PowerShell

30 March, 2010 Roel van Lisdonk 7 Comments 1 category

If you want to deploy a report (*.rdl) file to SQL Server Reporting Services in PowerShell, use the following script: PowerShell script "Set execution policy to [Unrestricted]" Set-ExecutionPolicy Unrestricted "Load assembly" [System.Reflection.Assembly]::LoadFrom("C:\Temp\Ada.Cdf.dll") "Create report"

How to deploy a datasource in SQL Server Reporting Services with PowerShell

30 March, 2010 Roel van Lisdonk 3 Comments 1 category

If you want to use PowerShell to deploy a datasource in SQL Server Reporting Services use the following script: PowerShell script "Set execution policy to [Unrestricted]" Set-ExecutionPolicy Unrestricted "Load assembly" [System.Reflection.Assembly]::LoadFrom("C:\Temp\Ada.Cdf.dll") $datasource = New-Object

How to create a folder in SQL Server Reporting Services with PowerShell

30 March, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to use PowerShell to create a folder in SQL Server Reporting Services use the following script: PowerShell script "Set execution policy to [Unrestricted]" Set-ExecutionPolicy Unrestricted "Load assembly" [System.Reflection.Assembly]::LoadFrom("C:\Temp\Ada.Cdf.dll") $folder = New-Object Ada.Cdf.Deployment.SSRS.Folder

Explaining SSRS datasource options “Use as Windows credentials when connecting to the datasource” and “Impersonate the authenticated user after a connection has been made to the datasource”

30 March, 2010 Roel van Lisdonk 2 Comments 1 category

In SSRS ther are two options you can set, when the credentials of the datasource are stored securely in the report server: Use as Windows crendentials when connecting to the datasource This option must be

ReportViewer control does not show default images on IIS7

19 February, 2010 Roel van Lisdonk 3 Comments 0 categories

If you use the ReportViewer control in you’re C# web application and the ReportViewer does not show the default images (refresh button etc) then you can check you’re web.config if it contains the correct axd

Tag: Reporting Services