Viewing Inventory Reports Using a Web Browser
Novell Cool Solutions: Feature
By Jagannathan Somakala
Digg This -
Posted: 15 Jan 2003
This document provides information on the integration of Inventory reports with the Crystal Reports' web reporting framework. Follow these instructions and you'll be able to access Inventory reports using a web browser.
You can run reports to gather inventory information from the Inventory database. The Inventory reports are designed using Crystal Reports. You can select from a predefined set of report forms to generate a report. The inventory report is displayed in the Crystal Viewer window.
Crystal Reports provides a web-based framework for reporting. Using the Crystal Reports' Seagate page server (integrated into a web server on a Windows NT or Windows 2000 server), you can access the reports from any browser.
The web server can be an IIS 2.0 and above, or a Netscape server.
For more information on the system requirements, see the Crystal Reports' Web Reporting Administrators guide (WEB.PDF) located on the Crystal Reports 8.0 product CD.
We have worked on the integration of Inventory reports with the Crystal Reports' web reporting framework on the Windows 2000 server with Microsoft Internet Information Server (IIS) 2.0 installed.
To integrate the Inventory reports with the Crystal Reports' web reporting framework, proceed in the following sequence:
- I - Setup the Crystal Reports' web server
- II - Configure Windows NT/2000 server
- III - Configure the ODBC connection
- IV - Configure the web server
- V - View Inventory Reports
- VI - Create a web site to view the Inventory report
You can install the Crystal Reports' web server by installing Crystal Reports 8.0. For more information on installing the web server, see the Web Reporting Administrator's guide.
If you want to install the web server of Crystal Reports 8.5, you need Crystal Enterprise Server Edition.
To configure a Windows NT/2000 server that has a printer driver installed, you must create a user account by following the steps below:
(A) Create a User
- Login as a Windows NT administrator.
- Open the User Manager for Domains application.
For more information on how to access the User Manager for Domains application, see the Microsoft Windows NT/2000 documentation.
- Add a new user.
- On a Windows NT server: In the User menu, click New User.
- On a Windows 2000 server:
- In the Computer Management window, double-click Local Users and Groups.
- Right-click Users > click New User.
- Enter a new user name to be used by the Web Component Server.
For example, CRWEBUSER.
- Enter a password.
- Deselect the User Must Change Password at Next Logon check box.
- Select the User Cannot Change Password check box.
- Select the Password Never Expires check box.
- Make this user a member of the Administrators group.
- On a Windows NT server, click the Groups button and select the Administrators group.
- On a Windows 2000 server:
- In the Computer Management window, right-click CRWEBUSER > click Properties.
- Click the Member Of tab.
- Click the Add button.
- Select the Administrators group > click OK.
- Click OK.
- Close the User Manager for Domains application.
(B) Change the Services
- Open the Services window. For more information on how to access the Services window, see the Microsoft Windows NT/2000 documentation.
- Select the Seagate Page Server from the Services list.
- On a Windows NT server, click Startup.
- On a Windows 2000 sever, right-click Seagate Page Server > click Properties.
- Ensure Automatic is selected as the Startup Type.
- In Log On As area, do the following:
- Click This Account.
- Click the Browse button next to the This Account field to browse for and select the user you just created (CRWEBUSER).
- Click Add > OK.
- Enter the correct password for the user in the appropriate text boxes.
- Restart the Seagate Page server.
After creating the user and changing the services, ensure that the web server has been successfully installed. From the Seagate Crystal Reports Programs Group, select Web Samples or open a browser (such as Internet Explorer or Netscape Navigator), and enter the following URL address:
where <local_host> is the IP address of the web server.
The Seagate Crystal Reports Web Samples and Utilities Page appear in the browser.
Before running the inventory reports you must make sure that the appropriate ODBC client for Sybase, Oracle, or MS SQL is installed on the machine running ConsoleOne. The ODBC driver will be automatically configured on the machine when you invoke the Inventory report.
You can install the Sybase ODBC driver from the ZENworks for Desktops 4 Companion CD. To install the Sybase ODBC driver, copy the \ODBC\SYBASE\SYBASEODBC.ZIP from the ZENworks for Desktops Companion CD to a drive. For installation instructions, refer to the ODBC\SYBASE\ODBCREADME.TXT on the ZENworks for Desktops Companion CD.
After installing the appropriate ODBC client, configure the ODBC DSN on the web server. On the machine where the web server resides, configure the ODBC DSN name to ZenInventory.
To configure the ODBC DSN name:
- Click Start > Settings > Control Panel.
- Double-click Administrative Tools > Data Sources (ODBC).
- Click the System DSN tab.
- Click the Add button.
- Select the ODBC driver for the database you want to connect to.
- Click Finish.
- Specify the Data Source name as ZenInventory.
- Provide the database specific details.
- If the database is running Sybase:
- Click the Login tab.
- Click the Supply User ID and Password option and enter a user ID and password as follows:
User ID: MW_READER
- Click the Database tab.
- Enter the following details.
Server Name: IP address of the server on which Sybase is running.
Database Name: Database Name: mgmtdb.
- Click the Network tab > click the TCP/IP option.
- Specify the host name or IP Address of the server.
The format should be host=IP_address where IP_address is the IP address or host name of the server on which Sybase is running.
- Click ODBC tab > Test Connection.
The message Connection Successful should be displayed.
- If the database is running Oracle, enter the service name and the user ID as follows:
Service Name: Service name specified during Oracle Client installation.
User ID: MWO_READER
- If the database is running MS SQL:
- Enter the IP address of the server on which MS SQL is running.
- Click Next.
- Select the With SQL Server authentication using a login ID and password entered by the user option.
- Ensure that the Connect to SQL server to obtain default settings for the additional configuration options check box is selected.
- Enter the login ID and password as follows:
Login ID: MW_READER
- Click the Client Configuration button.
- In Network libraries, select TCP/IP > click OK.
- Click Next.
- If the database is up and running, and the database parameters that have been set correctly, the final page will be displayed. Click Finish.
The following steps explain in detail how to configure the web server installed using Crystal Reports 8.0. Detailed information for this can be obtained from the Web Reporting Administrator's Guide of Crystal Reports.
To determine whether the Web Component Server is configured correctly in Microsoft IIS version 2.0, follow these steps:
- Start the Internet Service Manager.
- Under Console Root, expand the Internet Information Server folder to expose the machine you are using as the server.
- Right-click on the machine icon and click Properties from the shortcut menu. The Properties dialog box appears with the Internet Information Server tab active.
- Select WWW from the Master Properties drop-down list.
- Click Edit.
The Service Master Properties dialog box appears.
- Click the Home Directory tab.
- Click Configuration.
- Locate the extension .RPT and ensure that it points to the correct path for the wcsinsapi.dll.
The default path is: C:\Program Files\Seagate Software\WCS\wcsinsapi.dll.
- Verify that the .CRI extension also points to the same place.
To view Inventory reports using the web-framework of Crystal Reports, ensure that the Inventory reports has been invoked at least once using ConsoleOne, because ConsoleOne makes the database compatible to view the Inventory reports using the Crystal Reports.
Note: On the web server, do not run the ConsoleOne and the web browser to simultaneously access the Inventory reports from different databases.
You must create a web page that contains report links.
- 1. Decide on a location for your new web page, and then create a virtual directory for the site that points to the new directory.
- 2. Create a directory where you want to store your reports.
- 3. Copy the Inventory reports from ConsoleOne\1.2\reporting\Canned\Novell Reporting\ZenInventory\
into the directory.
Where locale can be "EN" for English language reports, "FR" for French language reports, "PT_BR" for Portugese-Brazilian language reports, "DE" for German language reports, and "ES" for Spanish language reports. The non-English reports will be displayed based on the respective locale of the machine.
Download and copy the sample HTML page provided with this article to the web server's root directory (c:\inetpub\wwwroot).
This sample HTML page lists all Inventory reports.
Note: For information on the location of your web server's root directory, refer to your web server software documentation. The directory shown here is intended only as an example.
- 4. Use your web server administration software to create a virtual directory to point to the physical directory you have just created. You will probably need to give this virtual directory "execute" permission. For example, create a virtual directory with name "myreports".
- 5. Open the sample HTML page in a text editor and change the following:
- IP address to point to the web server's IP address.
- Virtual directory name that contains the .RPT files. In the sample HTML page, the virtual directory name is "myreports".
- (Optional) Password, if the password of the database is other than the default password (novell). For more information, see the Web Reporting Administrator's guide.
- 6. Save the file as reports.htm in the c:\inetpub\wwwroot directory.
- 7. Open your web browser, and enter the following URL:
where <local_host> is the IP address of the web server.
- 8. Click any link in your new web page to generate and display the report inside your browser.
- 9. You will be prompted to enter the selection criteria for the selected Inventory report. For more details, see the ZENworks for Desktops 4 (http://www.novell.com/documentation/lg/zdpr/index.html) or ZENworks for Servers 3 SP1 documentation (http://www.novell.com/documentation/lg/zfsi/index.html).
Note: You must enter any one of the following integer values for the "Role" selection criterion:
Integer Value Information Displayed in the Inventory Report 2 Inventory information of all the managed servers only 3 Inventory information of all the managed workstations only 5 Inventory information of both the managed servers and the managed workstations
- Crystal Reports version 8.0 does not allow you to enter multiple values for the "Suppress" selection criterion of the following Inventory reports: Asset Management Report, Storage Devices Inventory Report, System Internal Hardware Inventory Report, and System Software Inventory Report. For more information, see http://support.crystaldecisions.com/library/kbase.asp and in http://support.crystaldecisions.com/forums/, click Web Components.
- Currently we are having issues accessing Hardware Summary Report and Networking Information Report using the browser. We are working on this issue. When this is resolved, this document will be updated to include the reports. These reports are not included in the sample HTML page.
In the sample HTML page, we have specified the .RPT files using standard URL addresses.
The .RPT extension is analyzed by your web server, and is determined to be an extension that should be handled by the Web Component Server application.
The URL is handed off, and the Web Component Server determines how to handle the requested . RPT. When the report is displayed inside your browser, the Web Component Server analyzes the type of browser you are using and delivers the report using a Report Viewer it determines is appropriate.
For example, if you are using Internet Explorer 4.0, you will see the report inside the Report Viewer for ActiveX. If you are using Netscape Navigator 4.0, you will see the report inside the Report Viewer for Java.
reports.html is a sample HTML file containing the list of Inventory reports, which you can modify to meet your needs.
Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com