Tuesday, September 9, 2014

Crystal Report 2013 Combine Field Names In Report

---
Crystal Report 2013 Combine Field Names In Report

STEPS

1) Preparation.

Run Crystal Report 2013.
Instead of adding the Contact First Name and Contact Last Name fields as separate objects, you can insert both fields in a text object. This allows you to control the formatting of both fields by making changes to only one object. When you insert fields in a text object, the fields are automatically trimmed (they do not have any extra white space on either side). This is important because a field is a fixed size but the data in the fields can vary in size, leaving various amounts of unwanted white space.

2) Inserting Text Object Into Detail Section

2-1) Click Insert Text Object on the Insert Tools toolbar.
2-2) As you move the cursor over the report, an object frame appears next to it.
Insert the field to the right of the fields in the Details section.
As you drag the field, the Design tab automatically scrolls to the right, if necessary. When you click to place the object, a text object appears and the horizontal ruler of the Design tab changes to a ruler/tab selector that is used for editing the text object. If you click an empty area of the report or a field object, the standard Design tab ruler appears.
Info:
If you wrongly place the Text Object for your table field into the Page Header section, only the first record item for that page will appear in the Page Header section.

3) Drag Field Name into Text Object

3-1) Drag Contact Last Name into the Text Object.
3-2) Press ESC.

4) Resize Text Object

4-1) Right-Click the Text Object, select Size and Position.
4-2) Enter 2.5 Inches
Info:
If you want to change the Unit Of Measurement to CM, you have to do it through Windows Setting.
4-3) Type a comma and a space.

5) Drag the second Field Name into Text Object

5-1) Drag Contact First Name into the Text Object.
5-2) You may get like this.
5-3) Press Up Arrow Key to view the remaining parts of the Text Object.
5-4) Print Preview your report.

6) Insert Text Object into Page Header (PH)

6-1) Add a Text Object for the Field Header.
Type “Contact Name”.
Apply Underline format.
6-2) Outcome.
6-3) Move to page 2 and page 3 to check the Page Header texts.
---

No comments:

Post a Comment