Hi, I use BIDS 2008 R2 to create SSRS report, using Microsoft Access as data source. In Access database, I use tables and queries. The story is complicated if you ask why I use Access, not SQL Server. Anyway, I created Datasource, Dataset,
Table, Chart, etc in BIDS. I run report, it works fine. However, after I deployed the SSRS report to Dynamic CRM 2011, the report does not work any more. I pinpointed, and found that CRM 2011 does not like Access, because after I deleted
the Access dataset, the report looks fine in CRM 2011. Does anybody know how to make Access dataset work in CRM 2011? Thanks.