Create CRM 2011 report using Microsoft Access database as data source

• Question

• 

  

  0

  Sign in to vote

  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.

  Friday, April 25, 2014 12:02 AM