New features of SQL Server BI step through step SSRS 1-reporting Service 2008

Today we start another important part of SQL SERVER bi--reporting service, relative to integration service and analysis service,reporing Service in the domestic users should be a lot more. On the one hand, because the reporing service cost is lower, directly attached to SQL Server, on the other hand, in fact, SSRS to a large extent, or to meet the needs of our report. In SQL Server 2008, SSRS has stepped up in a number of ways, "if Microsoft invests 10 dollars in 2008 of BI, 8 of them are invested in reporing Servce". Let's just take a look, SSRS 2008. What new features and changes are available:

1. Out of IIS

SSRS 2008 no longer relies on IIS, which has built-in functionality to handle user requests. When you start SSRS, you have direct access to reports and ReportServer, and security and performance enhancements. There are a lot of friends the reaction of the experience is, "after using SSRS 2008, can not implement anonymous access report?"

2. New export to Word options, export CSV enhancements

Based on previous formats such as Export xml,pdf, Excel, added support for exporting Word format files. Also exported CSV format data enhancements.

3. Changes in the way reports are developed.

The document outline and report data are listed on the left, and the report parameters can be set directly in the report data to manage the dataset. The primary area is designed and has only two tabs. The design interface lets you set the row and column groups below.

4. New charting tools

Thanks to Microsoft's takeover, Dundas,ssrs has finally stepped up in this area. Added charting and instrumentation features, including a variety of bar charts, line charts, pie charts, bar charts, and so on, the instrument may also be very powerful, in addition to the R2 version also added maps, direct visual design, and Bing Maps integration.

5.Tablix

Tablix = table + Matrix,tablix combines the functions of a table and a matrix data area to allow merging of multiple column combinations and row combinations. Ability to support both dynamic rows and dynamic columns.