Querying SharePoint List from Reporting Services returns only “not null” columns

  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 for the 1st row, the column is not…

12

SSL configuration and Reporting Services

   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 Manager you receive the following error message:   “The underlying…

1

Reporting Services Internal Error

  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 Error An internal error occurred on the report server. See the error log…

2