Create pdf reports from Sql Server in ASP.NET MVC 2 application?

I want to be able to somehow get reports out of my Sql Server database in an MVC application. I could have developed a way to do that using xml and then transform it to fo and rendered it via an fo processor to pdf. But that would require being able to have the fo processor installed on the web server, and I'm using a web host, so that's probably not going to work.

So I've seen Reporting Services mentioned here and there. Does that include the possibility to create pdfs? And if so, how do you use it in an MVC application? I tried before to mix webforms into MVC application (if that's necessary as I've seen implied) but couldn't make it work. The routing didn't seem to recognize the web form page...

Or is there any other easier way to create pdf reports from Sql Server data? I should also mention that I only use Linq (and the Entity Framework) t开发者_StackOverflow中文版o access data, so hopefully there is a solution that doesn't require me to know Sql stored procedures etc...

Any help appreciated!

Take a look at http://sourceforge.net/projects/itextsharp/ a c# port of the iText open source java library for PDF generation. It is relatively straightforward to create simple PDFs using these libraries