Have been using the "vanilla" SQL Express for some time now and feel that I kind of know what I'm doing.
However, I have no idea what can be acheived with the Reporting Services that come with the "advanced" SQL Express.
Can someone please explain what I can do with Reporting Services?
Reporting Services is a web server that allows you to provide a reporting exerience for your database that can be accessed on a web site rather than requring people to open up a specific application. Think about things like summary or rollup reports; there is no need to have everyone install a specialized application, you just create reports and Deploy them to RS and then folks can look at them.
Like any access to SQL, you can use either Windows or SQL Auth, depending on how your SQL Server is configured, and then use that to control access to the data.
RS Express provides some limited Export capability (PDF & XLS) and can only access local, relational data. There is more information in BOL and a whole series of webcasts you can view to learn more at http://msdn.microsoft.com/sql/bi/reporting/default.aspx.
Regards,
Mike Wachal
SQL Express team
-
Please mark your thread as Answered when you get your solution.
No comments:
Post a Comment