Danny Varghese: SQL Reporting Services 2005 Gotchya’s

[Blog bot]

Источник: http://varghesedanny.com/2011/06/20/...2005-gotchyas/
==============

I recently had to create a Microsoft SQL Server Reporting Services (SSRS) 2005 report for a client that was running CRM 4.0.  It’s been a few years since I’ve had to do that, and ran into different issues I want to document for future reference.  I didn’t run into these issues when using SSRS 2008, only 2005, so I thought it was worth noting.

1. SSRS 2005 reports must be created using Visual Studio 2005.  I found this strange, because I like Visual Studio BIDS 2008, but it’s not compatible to create reports for SRS 2005.  In fact, when the .rdl file is created there is a schema defined at the top which references which version of SRS you’re using and in VS 2008, it will not reference SRS 2005.
2. Datasets in the report can not use a shared datasource.  I created a report with two datasets using a shared datasource.  I then uploaded the report in CRM and received an error in CRM.  I then had to turn tracing on, and decipher the logs.  The logs showed a null pointer exception for a MS CRM method that was trying to initialize a datasource.  I then created a new datasource for each dataset and that worked.

This caused me some pain, so hopefully this helps someone out.




Источник: http://varghesedanny.com/2011/06/20/...2005-gotchyas/