Using an Intranet Application to Make Business Decisions

<% If InStr(Request.ServerVariables("HTTP_USER-AGENT"), "MSIE") Then MachPath = "../mm/iisctr4m.asp" Else MachPath = "iimmnscp.htm" End If %>

Goal: To provide managers with both high-level and detailed representations of up-to-date statistics.
Components: Windows NT Server 4.0; Internet Information Server (IIS) 4.0; Active Server Pages (ASP); ADO; Microsoft SQL Server; Internet Explorer version 3.02 with Authenticode 2 update, or later versions of Internet Explorer
Environment: Intranet, secured; Windows NT network

Using an Intranet Application to Make Business Decisions

Multimedia Demonstration

Basic Process

Use Visual Interdev to write ASP code in the scripting language of your choice, using Microsoft Data Access to generate the main statistics table. Each element in the table provides a link; the ASP code provides the substance behind the links, while the data itself comes from a Microsoft SQL Server database.

Result

Your management has access to vital, timely information at their desktops, enabling "management by exception."