248 Project 1 CREATING A CUSTOMER MAINTENANCE PROJECT

Table 11-2 Buttons in the Toolbar of the Windows Forms Viewer Control

(continued)

The following section discusses creating a Windows Forms Viewer control to display a crystal report.

Creating the Windows Forms Viewer Control

As discussed earlier, a Windows Forms Viewer control is used to host and display a crystal report. Perform the following steps to create a Windows Forms Viewer control.

1.In the Solution Explorer window, right-click on the project name, Customer Maintenance Project.

Team-Fly®

2.In the displayed list , point to Add and click on the Add New Item option.

The Add New Item dialog box is displayed.

3.In the Templates: pane, select the Windows Form option.

4.In the Name: text box, type the name of the form as ConsumableForm and click on the Open button.

Visual Studio .NET creates a new form for you.

From the Windows Forms toolbox, drag the CrystalReportViewer and Button controls to the form.

TIP

In the Windows Forms toolbox, a Windows Forms Viewer control is called CrystalReportViewer.

Resize the CrystalReportViewer control to occupy maximum area on the form. Figure 11-4 shows ConsumableForm with the Cr ystalReportViewer control.

FIGURE 11-4 ConsumableForm with the CrystalReportViewer control

FIGURE 11-6 Consumable Report at run time

To enable a user to return to the Reports form after viewing the report, you can make the Exit button functional. To do so, add the following code to the Click event of the Exit button.

private void btnExit_Click(object sender, System.EventArgs e)

{

Reports newForm = new Reports(); newForm.Show();

this.Hide();

}

After creating the Monthly Consumable report, you can similarly create the Monthly Customer Visit, Monthly Balancing and Alignment, and Monthly Worker reports.

Creating the Monthly

Customer Visit Report

The Monthly Customer Visit report is created to track the number of visits of a customer in a particular month. The procedure for creating the Monthly Customer

252 Project 1 CREATING A CUSTOMER MAINTENANCE PROJECT

Visit report is similar to the one you used to create the Monthly Consumable report. However, while creating the Monthly Customer Visit report, you need to make a few changes, such as changes in the table name, field names, Group By: field, and so on.

Similar to the Monthly Consumable report, you can use Standard Report Expert to create the Monthly Customer Visit report.However, if you want, you can select any other expert.The following list will discuss the changes that you need to make while creating the Monthly Customer Visit report.

1.In the Data tab of Standard Report Expert, select the tblCustomer and tblJobDetails tables to display data from both these tables. After clicking on the Next button, the Links tab is displayed.

The Links tab displays the link between the tblCustomer and tblJobDe-

tails tables. By default, the common field name, CarNo, is selected as the link. However, if required, you can clear the link by clicking on the Clear Links button and then create a new link by dragging the field name from one table to another. Figure 11-7 displays the Links tab of Standard Report Expert.

FIGURE 11-7 The Links tab of Standard Report Expert

FIGURE 11-10 Monthly Balancing and Alignment report in the design view

You can make changes to the layout of the Monthly Balancing and Alignment report in the design view. However, to display the report at run time, you need to create a new form, AlignmentForm, and then include a CrystalReportViewer control. Figure 11-11 shows the Monthly Balancing and Alignment report at run time.

FIGURE 11-11 Monthly Balancing and Alignment report at run time