When adding and/or moving objects in a report using the Report Editor, you may run into a situation where you see text that is overlapping or cut off in the preview.


Example 1: Text is cut off even when the object is the maximum width.



To apply the Stretch and Word Wrap property to a text object:

  1. In the Report Design Workspace, select the object(s) that need to Stretch. To select more than one object, hold the <Shift> key on your keyboard and click on each field to which you'd like to apply these properties.
  2. Right-click on the selected field(s) and select the "Stretch" option.
  3. Right click on the selected field(s) again and select the "Word Wrap" option.
  4. Click the [Preview] button to preview the changes you made and verify the issue has been resolved.
  5. Click the [Save] button to save your changes.


Example 2: Text overlapping due to Shift property not being set.

In this example, you can see the name is overlapping the street address line. The reason for the overlapping in this case is because the Shift property has not been set on the objects below the name. To fix this issue, we need to apply th eshift property



To apply the Shift property to a text object:

  1. In the Report Design Workspace, select the object(s) that need to shift. To select more than one object, hold the <Shift> key on your keyboard and click on each field to which you'd like to apply this property.
  2. Right-click on the selected field(s) and select the "Shift" option.
  3. Click the [Preview] button to preview the changes you made and verify the issue has been resolved.
  4. Click the [Save] button to save your changes.


Example 3: Fields overlapping even though the Shift property is set.

In this example, you can see the name is overlapping the address line, but all other objects are properly shifting position. In this example, all objects have the Shift property enabled. The reason only the street address field is overlapping is because of the object's position in the Report Design Workspace. In this case, the position of the address field is overlapping the name field. When this happens, the Report Editor will override the Shift property settings and assume the fields should overlap.


To move an overlapped object:

  1. Use the Zoom Slider in the bottom right corner of the Report Editor window to zoom in to the objects on the report. Using the zoom is important because it will allow you to easily see when there is a slight overlap in a field position. (In the example below, we zoomed in to 400% to see the Address field was overlapped with the Family Name field.)
  2. Click on the object and drag it down so it is no longer overlapping the field above it. If the object is in the middle of other objects, you may need to move the other objects as well. If needed, hold the <Ctrl> key on your keyboard as you use the keyboard's arrow keys for an incremental move of the selected object(s).
  3. Click the [Preview] button to preview the changes you made and verify the issue has been resolved.
  4. Click the [Save] button to save your changes.


Example 4: Text Overlapping or odd spacing due to the length of data in the object.

In this example, you can see that the city, due to its length, is overlapping the state information in one record and creating a huge space between the city and state on the other record. This issue is caused by using three separate text objects for City, State, and Zip Code. Due to the space constraints in the report, there is no room for the fields to widen and shift as needed. Additionally, though an object will only grow as needed, it will not shrink when there is more space than necessary. To fix this problem, we can combine all the data into one text object in the report.



To combine multiple text objects into one text object:

  1. In the Report Design Workspace, double-click on the field that is being overlapped by the field before it (or has odd spacing when the text is smaller than the text object before it). A Memo window will appear. In this example, we're double-clicking on the "[FamilyProfileData."STATE"]" object.
  2. Highlight the field name by clicking and dragging in the text box.
  3. Right-click and select the "Copy" option.
  4. Click the [Cancel] button to close the Memo window.
  5. In the Report Design Workspace, double-click on the field that is overlapping the field you just copied (e.g. "[FamilyProfileData."CITY"]"). A Memo window will appear.
  6. Click in the text area of the Memo window and press the <spacebar> on your keyboard.
  7. Right-click and select the "Paste" option, then click [OK].
  8. Repeat steps 1 - 7, as needed, until you have the fields you want in one text object. In this example, we pasted the "State" and "Zip Code" fields into the "City" object.
  9. Delete the text object for any of the fields you pasted into the main text object. In this example, we deleted the separate "State" and "Zip Code" fields.
  10. If needed, use the boundary boxes around the object to make the field longer.
  11. Right-click on the text object and make sure the "Word Wrap", "Stretch", and "Shift" properties are enabled.


Example 5: Blank space when there is no data for an object.

You may run into a situation where a record in a report does not have any data for one of the fields that has been selected to be in the report. When this happens, you may notice there is a blank line in the report preview. In this example, you can see the blank space in the "Notenough" family record is due to this family not having a phone number. This issue can be fixed by changing the "Height" and "StretchMode" properties in the Object Inspector panel.



To fix a blank line when a record does not have data for a field:

  1. In the Report Design Workspace, select the field that is causing the blank space to appear in the report.
  2. In the Object Inspector, change the "Height" to ".01" and press <Enter>. This will shrink the field size and basically hide the field so it does not take up space if there is not data available.
  3. In the Object Inspector, find the StretchMode property and change it to "smActualHeight". This option will enable the field height to grow as needed when data is available.
  4. Move any fields below the field up in the Report Design Workspace. Make sure the "Shift" property is enabled on those fields.
    Tip: When moving fields around, it is often helpful to use the zoom slider in the bottom right-hand corner of the Report Editor.
  5. Click the [Preview] button to preview the changes you made.
  6. Click the [Save] button to save your changes.


Example 6: Report has a lot of blank space at the bottom of the page.

There may be times when the report leaves a lot of blank space at the bottom of the pages. When the report is generated, the report engine fills the space of the page with the band. When the report engine finds there is not enough space left to display the next band, it will automatically create a new page and place the entire band on the next page. This process continues until all available records for the data set have been placed on the report. If you do not want the blank space at the bottom of the report, you can use the "Allow Split" property to force the report to split the information in the band allowing it to use the available space on each page.


To use the Allow Split property:

  1. In the Report Design Workspace, select the band that contains the data you wish to split across multiple pages.
  2. Right-click on the band and select the "Allow Split" property.
  3. Click the [Preview] button to view a preview of the changes made to the report.
  4. Click the [Save] button to save your changes.