Тема
:
Danny Varghese: SQL Reporting Services 2005 Gotchya’s
Показать сообщение отдельно
21.06.2011, 05:21
#
1
Blog bot
Участник
25,644
/
848
(
80
)
Регистрация: 28.10.2006
Danny Varghese: SQL Reporting Services 2005 Gotchya’s
Источник:
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.
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.
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/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите
личное сообщение
администратору.
Blog bot
Посмотреть профиль
Найти ещё сообщения от Blog bot