Start To Finish Guide to Microsoft Web Reporting (ebook)

The Start to Finish Guide to Customizing SMS Web Reporting is a compilation of many experiences and hours, if not days, of trial-and-error and self-learning. The book's intent is to help SMS administrators, both novice and experienced, in understanding SMS Web Reporting on a more personal level. The book is a logical journey, beginning by outlining the basics of SMS Web Reporting, and then leading through the knowledge required to become completely proficient with customizing SMS Web Reporting product to meet the needs of the organization. The basic understanding of the SMS database, SQL, and HTML is not required, but it can be useful when you are ready to create your own customizations.

Summary

Chapter Breakout

Chapter 2: File Structure and Security
The second chapter provides information on the file structure of Web Reporting. Every file and directory is given with an explanation of its function. An example of creating another instance of Web Reporting is also provided with guidance on security issues.

Chapter 3: Changing the Look
This chapter provides guidance on changing the appearance of Web Reporting. Changing colors, graphics, and text are all covered to make Web Reporting fit in to any organization?s intranet.

Chapter 4: XML in Web Reporting
Chapter Four covers the basics of XML that are used with the Web Reporting schema. This chapter contains the information and tools necessary to customize the reporting structure and provides a jump start into the ever-growing popularity of XML.

Chapter 5: SQL in Web Reporting
This chapter provides information on using the SQL Enterprise Manager and how to use the Query Analyzer and Query Builder. How to create queries, views, and stored procedures are also covered, as well as the use of aliases and joins.

Chapter 6: SQL Extras
This chapter steps through creating a database and using correlation tables. SQL server linking is also covered along with its alternative of DTS packaging.

Chapter 7: Modifying the Dashboards
Chapter Seven provides the information required to modify the existing dashboards and create alternative dashboards from the ones provided with Web Reporting. The composition of the dashboards is discussed as well.

Chapter 8: Web Reporting Modifications
The final chapter is a compilation of modifications to Web Reporting. Hiding trees, reverse DNS lookups, and passing multiple variables are a few examples covered in this chapter.