Forum Moderators: open
I'm a pretty experienced developer in the linux/unix world, but I'm totally lost when it comes to MS stuff, so please be gentle!
I was asked to take a look at a reporting tool built using the SQL Server SSRS tools and the Business Intelligence Development Studio. So far so good-- it's all pretty clear and I can work with it using the studio.
However-- one of the project requirements is "prettying up" the reports and adding some functionality. I think that the third party controls I need to use are all built for asp.net, and they don't appear to be usable in the toolbox in the bizdev studio (they are greyed out).
Is it possible (and if possible, difficult?) to move an SSRS project into the asp.net website framework? I assume a lot of the code should port right over, and the datasources etc. should work fine as well. Can I create a new website project and just copy the files from the SSRS project into the new website project?
I just don't really know how to start -- any basic tips/tutorials would be very appreciated.
Maybe this article will help?
[codeproject.com...]
As far as I can see, it is possible to open a Project created with Business Intelligence Development Studio in Visual Studio professional edition (I haven't tested with other versions)
You can download a trial (90 days) version of Visual Studio 2008 here:
[msdn.microsoft.com...]
It looks to me that you can indeed open an SSRS project in VS 08, but that in order to use the asp.net controls I want to use I will have to rewrite the data sources and parameter input controls as asp.net objects. I don't think there's a way to access the SSRS objects natively as asp.net-- unless you expose them via web services, which seems to be just about as much trouble as rebuilding the pages/reports as asp.net
Any other opinions on this very welcome
