The following steps describe the creation of a simple report. The example uses the Visual Studio.NET 2003 Enterprise Architect IDE.
From the IDE, select
and add a new Crystal Report.Create a report using the wizard.
Define the data source. Access the Management Service reporting service database within data.
Using the connection definition wizard, define an OLEDB ADO connection to the Reporting Service database. Select
, then click .Select the Reporting server. Enter the User ID, password, and database name for the Reporting Service (see the ZENworks Endpoint Security Management 4.1 Installation Guide for more information). Click then click .
Select the desired source table or view for your report by expanding the tree nodes as shown below.
Under the
tab, select the table or view columns that you want to include within your report. Click to continue.If you are planning to group or summarize your data, click the
tab and select the columns you want to group. Click or select the tab.Title the report and select the style.
The Report Builder displays.
To set up a filter, right-click
in the field explorer, then click .The following filter allows you to select multiple users to filter by with the prompting text of "User Name:" displayed within the UI. The parameter is named the same as the column.
Right-click the report, then click
.Using the new parameter, specify only the records where the field equals the values selected in the parameter. Select the column, select a comparison (=), and then select the parameter. Press CTRL+S to save the filter
Repeat Step 10 to Step 13 for each filter. Edit the design of the report and the save the report.
After a custom report is generated, the report can be saved into the \Program Files\Novell\ESM Management Console\Reports\Reports\ directory on the Management Console machine. The new report displays in the reports list in the Reports tab of the Management Console (click to display the new reports).