Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server?

How do I connect it to Reporting Services?

share|improve this question
    
In your comment below you mention Report Model, there is a good bit of difference between a Report Model project and a Report Server project. –  Larry Smithmier Jan 27 '11 at 17:20
add comment

2 Answers

up vote 2 down vote accepted

You can create a stored procedure which selects the desired data and call it from your report as you call any other procedure. If you want to avoid having stored procedure just put the query directly into the report. You do need to use Mysql provider, just use a sql provider.

share|improve this answer
add comment

I don't see any problems generating reports the usual way, as long as you use the 4 part name: 'select top 10 col1, col2 from server.database.schema.table' in the code used to get the data for your reports.

share|improve this answer
    
But, when I create a Report Model project, I don't seem to have the option to use my connection to MYSQL as a data source? I only seem to have two provider options - 'SQLClientDataProvider' and 'OracleClientDataProvider'. –  Jimmy C Jan 24 '11 at 12:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.