Missing show/Add Data Source

Question

Any help will be appreciated,

I am using Visual studio 2010 and currently I am making a project in ASP.net mvc3. In this project I have .edmx data sets and want to use that for making .rdlc report. So fnally I couldn't get the show data source in the data menu of the report design. What is wrong? And what is the possible solution?

Answer 1

I went though the same problem than you and came up with a solution that may not be the best choice, but it's working.

First, it appear that you can't create DataSources in a MVC project. I don't know the reason for that, but I think it's linked to the fact that it must contain an unique connection in your application to a database (just a wild guess).

Anyway, the solution we came up here was that we created another project in the same solution of the MVC project, and created our Data Sources and Reports that were based on those data sources, in this new project.

I know it's not a pretty solution, but it did the trick for us.