Next, we place the DB Label objects opposite the corresponding text object. The CustomerID and CustomerLastName objects are placed on the same line. First, we place and resize the CustomerID object, and then we place the rest of the DB Label objects.
To place the CustomerID DB Label object:
| 1. | In the "Report Designer" window, and with one of the Label objects still selected, choose the "DB Label" button from the Database Controls toolbar (the first button on the left, with the "A" and a picture of a database cylinder in the bottom left corner). |
| 2. | Position the cursor immediately to the right of the "ID/Last Name" text object and click the left mouse button. |
The DB Label object will appear in the section with the text "DBText1". Take note that the Edit toolbar will become enabled with the "Table Name:" and "Data Field:" drop down boxes. The number next to the DB Label object will increase as more DB Label objects are added to the report. Also, with one of the existing Label objects selected while adding the DB Label, the Verdana font and size is automatically applied.
| 3. | From the edit toolbar, select "FlightView" from the "Table Name:" drop down box, and select select "CustomerID" from the "Data Field:" drop down box. |
We will make the CustomerID DB Label object's width smaller. DB Label objects are automatically placed as a default size. We want to resize the object to accommodate the size of the actual data.
To resize the CustomerID DB Label object:
The CustomerID DB Label object is still the selected object. Drag the middle right handlebar of the CustomerID object to the left until the width is approximately 1/2 of the original size.
Now we're ready to place the rest of the DB Label objects in the Detail section.
To place DB Label objects:
| 1. | In the Report Designer with the CustomerID DB Label object still selected, choose the "DB Label" button from the Database Controls toolbar. |
| 2. | Position the cursor immediately to the right of the CustomerID column object and click the left mouse button. |
The DB Label object will appear in the section with the text "DBText2" as well as the Edit toolbar will become enabled with the "Table Name:" and "Data Field:" drop down boxes.
| 3. | Select "CustomerLastName" from the drop down box. |
| 4. | Select the "Left Justify" option for justification. |
Place the rest of the DB Label objects to be printed in the Detail section of the report. Each of the objects is placed immediately to the right of its corresponding text object. The DB Label objects to be placed are: CustomerCompany, Slogan, and TotalCharge. Select the CustomerLastName field before adding the DB Label objects to assign the same font, size, and justification.
