Microsoft SQL Server 2000 Reporting SERVICES
.
[Keywords] Reporting Services, VB.Net .Bi (Business Intelligence)
N Reporting Services offers two programming modes: IDE and API
Microsoft's report can be created by dragging and filling some of the necessary information like VB. This feature may be more useful to non-professional users, but professional developers may prefer to use call APIs to implement, speech Microsoft's expert scene has written code with VB.NET, such as MyReportSystem.deleteItem (...) deletes the report.
N automatic transmission of reports with Outlook integration
Because Outlook is Microsoft's own products, it is reasonable to achieve the integration with Outlook, which is also a great advantage of Reporting Services, which is equivalent to the function of the workflow. For high-rise users, time is precious. Of course, it is not possible to always get reports in ERP, and Reporting Services can define the report rules in advance, then
Automatically send the report to the user's mailbox as a quarter.
n Provide permission control
Divided administrator / advanced user / ordinary user, etc., people who create reports can allocate permissions for the report
n Provide snapshots and historical recordings to reduce the load of report servers
Snapshot actually has a layer of cache between database servers and report services, that is, some reports can be used directly in the cache, do not have to query each time. The historical record is like the history record in IE, providing an index function
n Provide a convenient interface allows users to customize report rules
Non-professional users do not need to write SQL statements to implement report rules, only need to fill in rules in a list (for example> <=, etc.). This is also Microsoft's consistent style, Microsoft's software is "fool" type, this is also Many non-professional users like the importance of Microsoft software.
n With office integration, and can directly convert to PDF format
The resulting report was originally displayed in IE, or converted to Excel and other formats, and it can be converted to the PDF format to be understood, but it is unexpected that Microsoft now also begins to provide PDF format, PDF is Word's strong competitors, I think the PDF has a lot of free secondary development tools. The second is that Microsoft also recognizes that more and more users are using PDF format. The advantage of PDF is small, and the format is clear and beautiful. Strong confidentiality.
At the scene show, Microsoft experts only demonstrated the English PDF report, and the reporting services had bug when converting Chinese into PDF, but in the build version, it has been solved, and the REPORTING Services will be officially released next year.
n Reporting Services is a plugin in the .NET development environment,
Reporting Services must be installed after installing the .NET development environment, you can find the Reporting Services project in the BI (Business Intelligence) component library. You can then build a report according to step by step steps, generally want to drag from the control library. Table is placed in the interface, then specifies the row column and its respective corresponding fields.
