SS Reporting Services FAQs
I've mentioned in the past that I am working in earnest on an FAQ for Reporting Services, but some of the most F'ed A'ed Q;s are something like this:
Q. We're a “classic” ASP only shop using Windows 2000. Do we have to upgrade to .NET to use Reporting Services?
A. Yes and No. No, you don't have to stop writing ASP to using Reporting Services. The two will happily co-exist on the same server if you want. However, Reporting Services itself is a .NET-based application so you do have to have at least version 1.1 of the framework installed on the Report Services host. And, while you can write the reports themselves in any tool that generates a Report Definition Language (RDL) file, the one most of us will start with is one that integrates with VS.NET 2003.
Q. Can I write a report in HTML format and how do I upload it to the server?
A. Reports are expected to be in the form of Report Definition Language (RDL) files, not HTML.