SQL Server 2000 Reporting Services

1
SQL Server 2000Reporting Services

• Maisy Wong
• Business Planning Manager
• Services Procurement
• Hewlett-Packard Company
• Littleton, MA
• maisy.wong_at_hp.com

2
Reporting Services 2000

• SQL Server 2000 Business Intelligence.
• Create, manage, deliver real-time reports.
• Integrates with Visual Studio .Net 2003 (.Net
  1.1).
• Reports available through web browser, file
  share, applications.

3
Reporting Services 2000

• Two databases got created after the installation
  
• ReportServer
• ReportServerTempDB
• Two web sites got created
• Reports
• ReportServer

4
Reporting Services 2000

• Demo

5
Reporting Services 2000
6
Reporting Services 2000
7
Reporting Services 2000

• Screen shot - Display of the report is removed
  due to privacy data.

8
.Net Framework 1.1 Hot Fix

• If you have the compile error with error code
  -1073741819, you need the hot fix.
• Link for more info to KB832597
• http//support.microsoft.com/default.aspx?scidkb
  en-us832597
• Had compile error in production server. Problem
  went away a few days later and could come back.