SMS Web Reporting Tool

This page details problems and issues relating to the SMS Web Reporting Tool.

Can I use the SMS 2003 Beta Web Reporting Tool with SMS 2.0? [28/3/03]
Can’t View Information with the Web Reporting Tool [14/5/03]
Discrepancies between Web Reports and the SMS Console [26/2/03]
How do I change the Web Reports default URL name? [23/2/01]
IE 5 required for Microsoft Web Reports? [26/2/01]
Problem Exporting Web Reports to CSV file [18/2/03]
Syntax Errors when Drilling Down Columns with Commas or Apostrophes in the Text [30/10/01]
Web Reporting Tools Running Slowly [15/4/03]

Can I use the SMS 2003 Beta Web Reporting Tool with SMS 2.0?

From the microsoft.public.sms.admin newsgroup
If you’re wondering whether you can use the new SMS Reporting Tool that ships with the SMS 2003 beta then read on… [Go to article]

Can’t View Information with the Web Reporting Tool

Contributed By: Hans Schefske [MVP SMS]
If when you’re trying to view information with the Web Reporting tool you’re getting errors then it could be a problem with your Stored Procedures… [Go to article]

Discrepancies between Web Reports and the SMS Console

Contributed By: Cliff Hobbs [MVP SMS]
If you’re seeing discrepancies between the figures in reports generated by Web Reports and the SMS Console then the answer could lie here… [Go to article]

How do I change the Web Reports default URL name?

I've run through a Web Report installation, accepting everything at default values. How do I go back and change something? I specifically want to get a more meaningful 'name' for the IIS root folder (defaults to 'http://<server_Name>/sitedb_sms'). Must I remove and reinstall? I like the idea of the convention used in the release notes under 'Installable Configurations' (../SMSReportingXYZ).

You should be able to just rename it in the IIS MMC Console which is an MMC snap-in. You'll need to at least install the Personal Web Server (PWS) on your computer to get the complete file set for the snap-in.

Depending on which version of IIS you have will determine where you install the MMC snap-in from:

If its IIS 4.x, install it from the NT Option Pack.
If its IIS 5.0, and you have a Windows 2000 Professional workstation, just pop the Windows 2000 Server CD in your drive and choose IIS 5.0 as an add-on component. PWS is installed automatically, as well as the IIS snap-in.

IE 5 required for Microsoft Web Reports?

Does Microsoft Web Reports require IE 5.x?

Contributed By: Cliff Hobbs [MVP SMS]
Yes - the requirements for MS Web Reports are:

SMS 2.0 Server
IIS 4.x or better (preferably 5.x)
IE 5.x or better
Windows NT 4.0 SP5a or better (preferably Windows 2000)