Reports 

Group-left reports are very useful for generating output reports from SQL statements with the group by clause. The Group-left report suppresses redundant printings of the same value in the leftmost column of the report. It is like making a control break in your report. You can use the �Group-left� report on a master-detail relationship as well.

Your client asks you to define a control break on their stocks symbol and company name from previous report and also to print only one company on a page.

See Figure 2.

Your tasks are:

1- Modify Hands-On report 01 to the �Group Left� style.

2- Apply template to the user report.

3- Run the report.

4- Test the repot.

You will learn how to: use report wizard, use report style �group left�, use template, use pre-viewer, use zoom in and out, use the body section in the layout model in the object navigator, and change repeating object�s property palette.

Figure 2

In the �Object Navigator� window, go to the Main menu and choose �File,� select �Open� to open an existing report (RPT01_STOCK_HISTORY) from your folder.

Click on the Run icon to run the report.

Maximize the window.

Notice that the stock symbol and company name are repeated. We are going to create a control break to eliminate the duplication.

In the Report Editor, click on the Report Wizard icon on the toolbar.

In the Style tab on the Report Wizard, checkmark the �group left� radio button, then click next.

Group-left reports are very useful for generating output reports from SQL statements with the group by clause. The Group-left report suppresses redundant printings of the same value in the leftmost column of the report. It is like making a control break in your report. You can use the �Group-left� report on a master-detail relationship as well.

In the Data tab on the Report Wizard, click �Next� again.

In the Groups tab on the Report Wizard, move the �symbol� and company name� item to the �group fields� box. Drag "company" to level 1, and then click �NEXT.�

In the Fields tab on the Report Wizard, don�t change any fields. Click �Next� again.

In the Totals in the Report Wizard, calculate the total, minimum, and maximum number of traded shares. Then click �Next.�

In the Labels tab in the Report Wizard, change the label, if needed. Click �Next.�

In the Template tab in the Report Wizard, use the default template and click �finish.�

Navigate through the report output. Notice that multiple companies are on each page.

Change the report to print company�s information on a separate page.

On the Object Navigator, expand �Layout Model,� �Main Section�, then �BODY.�

Right click on the first "Repeating Group" (R_G_1) to open its property palette.

In its property palette, change "Maximum Records Per Page" to 1 and press the enter key, then close the window.

Navigate through the report. Notice that each company is on a separate page.

After testing the output report, go to the object navigator window, select the report and save the changes.

Save the report as report number 2 (REPT02).

A note to remember:

In the Object Navigator, if you highlight the report and click on the �X� icon (Delete) on the vertical toolbar, the object will be remove from work area and still a copy of that exist on your disk.

Questions:

Q: What is a Group-Left report?

Q: How do you use the Report Wizard?

Q: How many styles are in the Report Style window?

Q: What is a template in the Report Builder?

Q: When do you use pre-viewer in the Report Builder?

Q: How do you zoon in and out in the Layout Editor?

Q: What is the body section in the layout model?

Q: How do you change the repeating object�s property palette?

Q: Your client asks you to define a control break on their stocks symbol and company name from previous report and also to print only one company on a page.

See Figure 2.

Your tasks are:

1- Modify Hands-On report 01 to the �Group Left� style.

2- Apply template to the user report.

3- Run the report.

4- Test the repot.