When using Microsoft Dynamics CRM to run reports from a Reporting Services server that is installed on a separate machine, and windows integrated security, you have either of the two following possibilities: 1. Enabling Kerberos In this configuration...

I would like to share with you an issue I had running reports from CRM 4.0 and getting the error “The 'CRM_FullName' parameter is missing a value” In case you find yourselves in the same situation, doing a lot of troubleshotting on parameters...

The long waited Cumulative Update 7 for Reporting Services 2008 R2 is finally out. The product team has worked very hard to include some performance fixes related to the new inclusion of Ajax functionality in this version. Some of the fixes bellow...

We get many cases trying to configure Reporting Services with SharePoint. I am creating this post because some of the errors on the configuration can be avoided by choosing the right versions of the Add in (and service packs) depending on the versions...

Short time ago we found the following error when running Reports randomly in a web farm: Validation of view state mac failed, this application is hosted by a web farm or cluster, ensure that machine key configuration specifies the same validation...

Due to the great confusion I perceive about this error and its possible causes and solutions, I decided to remove my 3 old posts that talked about this error and create a single and more complete posts that I hope helps you resolve all the possible causes...

Before Service Pack 3, fonts weren´t embedded in the PDF file after when rendering the report to this format. The side effect is that the size of the file might be bigger. Some people have asked if it is possible to revert back to the old behavior...

If you ever find the following error in Reporting Services after uploading a file or creating a new subscription: “Maximum request length exceeded" There is a simple reason for that: The default value of the property MaxRequestLength...

Yes, as long as: 1. It is not Windows XP 32 2. They are using different urls to connect to the RS 2005 and RS 2008. Reporting Services 2008 and Reporting Services 2005 (IIS 6 or higher) can coexist in the same machine under most Operating...

The way that email subscriptions are processed is that the reports are sent to the pickup directory and then it is the SMTP server the one that finishes the process of sending it to the final user. When your email (subscription) doesn´t arrive to...

Working with reports in Reporting Services, you can face timeout errors. This situation might happen when using very heavy reports. I will show bellow a list of different timeouts that could be affecting reports execution in Reporting Services and how...

I am sure it has happen to all of us in some situations that we decided to uninstall Reporting Services and install it again. Sometimes we make this decision because the state of Reporting Services is very unstable that it would take too long to troubleshoot...

In order to monitor the response times of the reports executed in Reporting Services, you need to understand how Reporting Services works concerning performance. You should know that there are 3 phases in the execution or a report: “data retrieval” (time...

I found many people asking what the recommendations from Microsoft to make Reporting Services resilience are and if there is any plans for the future to make Reporting Services cluster aware. As you can see from the following link, the installation...

You might find yourself in a situation in which you want to use the API of Reporting Services to render reports to Excel or PDF in a multi language environment. If that is the case, you will want to display the date and number formats depending where...

Before making the decision of migrating your Reporting Services 2000 or 2005 to 2008 (reports, models, data sources…) it is useful to consider the different scenarios that we might find, and understand the way Reporting Services upgrades the reports....

If you install MS08-040 or MS08-052 and you find that the Report Server cannot start any more, you might be facing a known issue with KB954606 and KB948109 which is preventing the SQL Reporting Services service from starting. The security update is the...

Have you ever been in a situation that you installed Reporting Services in a 64 bits machine and then, after a while, you realized that you should have installed the 32 bits version instead? Or wanted to change from 64 bits version to 32 bits because...

Querying to a Sharepoint List from a report in Reporting Services 2005 returns only the columns that contain data. If any of the columns is NULL, they are not returned. This behavior is due to the Auto derivation the XMLDP: When there is an empty value...

When installing Reporting Services 2005 with Secured Socket Layer (SSL), it is a common mistake not to install the CA certificate in the trusted root for the local computer. This will lead to the following error trying to access to access the Report...

Over the last months I have bumped into many occurrences of the following error in machines that are Running Reporting Services 2005, and in most of the cases when displaying reports through CRM. The error seems to occur RAMDOMLY : Reporting Services...