So that you can later work through this article in your environment, I am using some sample data from a database available from the Seagate Web site designed to optimize the native driver. This database (CRAZEV6.NSF) can be downloaded from the Seagate site at http://support.seagatesoftware.com.

We have two sales reports for this fictional company. One is a worldwide sales report, which is a simple pie chart with accompanying sales numbers. The other report utilizes Seagate's mapping capability and allows the end user to drill down, by country, by double clicking on its region on the map.

The first report, which is stored in my reports directory (under the Domino/Data directory), has the file name WWSALES.RPT. In my form, I have created a hotspot of type URL, with the following value: http://myserver/webreports/reports/WWSales.rpt.

When the end user clicks on this hotspot via a browser, the report is served up in the viewer, as seen in Figure H.

FIGURE H


When the end user clicks on this hotspot via a browser, the report is served up in the viewer. Roll over picture for a larger image.

I've also created another text with the hotspot, "Country Drill Down Report." whose type URL value is: http://myserver/webreports/reports/lotusmap.rpt.

When this notes form is displayed in a browser and the user clicks the hotspot, the report appears in the viewer as seen in Figure I.

FIGURE I


When this notes form is displayed and the user clicks the hotspot, the report appears in the viewer. Roll over picture for a larger image.

When the end user clicks on the hotspot text, the report viewer will generate the report, appearing exactly as it would if we were to generate it in the Crystal Reports Designer. This includes the drill down categories on the left, which a user can click on to view more data. In the example above, I am using Internet Explorer/Active X viewer.

Conclusion
In this article, I covered all the basics of configuring Seagate Crystal Reports Web Server 8 to run with Domino R5 and tested the configuration with some simple reports.

In part three of this series, I'll cover some more advanced techniques, including passing parameters, executing stored procedures, and exporting reports to other file formats. In addition, I'll offer tips on improving the performance of your Web Reporting Server within your organization.

Jennifer Regnault is a Senior Consultant with Casahl Technology. Casahl is a Lotus Premium Business Partner that provides leading software solutions for D2D and B2B integration challenges. She can be reached online at jregnault@yahoo.com.