SSRS 2008 R2 reports

Question

I developed a report in SQL Server 2008 r2 reporting services(Evaluation Version) using MySQL as a data source using ODBC Connection. Now I want to run this reports in SQL Server 2008 r2 reporting services(Express edition advanced) but it Is giving me below error.

"An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)"

When I am trying to create Data source for this report its is not having ODBC as Data source... If any body know solution for this please tell me.

Thanks in Advace.

     Parandam.

 

Answer 1

I developed a report in SQL Server 2008 r2 reporting services(Evaluation Version) using MySQL as a data source using ODBC Connection. Now I want to run this reports in SQL Server 2008 r2 reporting services(Express edition advanced) but it Is giving me below error.

"An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)"

When I am trying to create Data source for this report its is not having ODBC as Data source... If any body know solution for this please tell me.

Thanks in Advace.

     Parandam.

 

Answer 2

Express edition with Advanced Services has no support for other data sources.

Check MSDN (Allowed data source SQL Server edition)

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Remote and non SQL data source support in each edition:

http://msdn.microsoft.com/en-us/library/ms365156.aspx

Regards

Answer 3

Parandam,

Please refer Using SQL Server 2008 Reporting Services (SSRS) with MySQL

---

Thanks,
Sandip Shinde

---

Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Answer 4

Hi YPR,

In SQL Server Reporting Services 2008 R2 Express Edition, the report data sources must be SQL Server relational databases that run locally. I suggest you that refer to the article about “Features Supported by Reporting Services in SQL Server Express”, please see:
http://msdn.microsoft.com/en-us/library/cc281020.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support

Answer 5

Thak you Mr.Sandip.