Wednesday, March 21, 2012

Report Builder Processing Error

Hi all,

Am having a problem processing reports using Report Builder. Have created the Data Source, DSV and Report Model and deployed them (following Report Builder walkthrough instructions in BOL). Building the report through the Report Builder app is also no problem. However when I try and process the report I always get the same error:

Report Execution Error
The Report might not be valid or the server could not process the data

Keyword not supported: 'provider'.
-
Cannot create a connection to data source 'dataSource'. (rsErrorOpeningConnection)
-
An error has occurred during report processing. (rsProcessingAborted)


Have tried building reports using several different models off several different DBs with the same results. Has anyone else seen the same?

I know that in the April CTP Report Builder was not fully functional. Just want to know if this is just a CTP glitch or something I am missing. Either way I am very impressed with what RB is going to offer the ad-hoc reporting world. Really happy that MS will be including it with Standard as well as Enterprise.

Cheers,Please ignore - my fault! Error was being thrown because I used '.' as the server name (lazy way of saying localhost) in my data source.

Everything worked as soon as I typed the full name of the server and redeployed all objects.

Apologies for time wasting.

Cheers,sql

No comments:

Post a Comment