Skip to Content
0
Former Member
Feb 16, 2011 at 11:27 PM

Crystal Reports refuses to take MSOLAP.4 provider

30 Views

Dear,

When basing a Crystal Reports on a MS SSAS 10 cube through OLE DB for MS Analysis Services 10, Crystal Reports always chooses MSOLAP as the provider, and not MSOLAP.4, no matter which OLE DB for MS SSAS I choose (same result with OLE for MS SSAS 9 for example) and all added connection properties are again deleted.

Furthermore, lot's of strange technical tables are displayed and it is not easy to see in which table the measures are included.

When previewing the crystal report with only 1 field in it to test and to see what data is in the tables, an error is displayed.

See http://img821.imageshack.us/i/problemyb.jpg/ for more details

I've set up an MSAS local database on my pc with a sample database (AdventureWorks)

Latest Crystal Reports version is used and latest OLE DB for MS SSAS driver

thank you in advance

Edited by: Toon Francx on Feb 17, 2011 12:28 AM

Edited by: Toon Francx on Feb 17, 2011 12:29 AM

Edited by: Toon Francx on Feb 17, 2011 12:29 AM