Formatted Record Area
The Formatted Record Area element allows formatting data from a database field dynamically at runtime anywhere to the page in between text. It can be added to any sections of the report (i.e. Header, Detail or Footer). Simply specify the name of the field between #...# between normal text and it populates the value.
"Dear #FirstName# #LastName#, "
# symbol is a reserved character that is used to distinguish field names from static text. Hence, static content in FormattedRecordArea should not contain # symbols other than to specify field names. For example, the following string will cause an error because the first # symbol is a part of static content.
# of items in queue are #quantity#
Removing/replacing the first # symbol in static content as shown below will resolve the error.
Number of items in queue are #quantity#
In order to add a Formatted Record Area, select the Formatted Record Area element under the Toolbox, drag and drop it at the desired location on the page. The Formatted Record Area can be resized or repositioned using the mouse, manually changing the values in the properties window or by changing the values directly in the source.
To format the text in the Formatted Record Area, double click on the Formatted Record Area once you have added it to the Report/Page. This will activate the Text Toolbar and allow you to add the formatting directly.
The Formatted Record Area element has the following properties:
|Leading||A value indicating the leading of the text.|
|LeadingType||A value indicating how the leading is calculated.|
|Align||A value indicating the alignment of the Formatted Record Area.|
|CleanParagraphBreaks||A value indicating whether paragraphs in the Formatted Record Area will have clean paragraph breaks.|
|Indent||A value indicating the first line indentation of the paragraph.|
|LeftIndent||A value indicating the left indentation of the paragraph.|
|PreserveWhiteSpace||A value indicating if white space should be preserved.|
|RightIndent||A value indicating the right indentation of the paragraph.|
|SpacingAfter||A value indicating the spacing after the paragraph.|
|SpacingBefore||A value indicating the spacing before the paragraph.|
|Color||A value indicating the color to be used for the font.|
|Face||A value indicating the font family to be used.|
|Size||A value indicating size of the font to be used.|
|Text||A value indicating the text of the Formatted Record Area.|
|VAlign||A value indicating the vertical alignment of the Formatted Record Area.|
|Id||A value indicating the programmatic identifier of the Formatted Record Area.|
|Angle||A value indicating the number of degrees to rotate the Formatted Record Area.|
|Expandable||A value indicating whether the Formatted Text Area is expandable or not.|
|Height||A value indicating the height of the Formatted Record Area.|
|Splittable||A value indicating whether the Formatted Record Area can be split between pages.|
|Width||A value indicating the width of the Formatted Record Area.|
|X||A value indicating the X coordinate of the Formatted Record Area.|
|Y||A value indicating the Y coordinate of the Formatted Record Area.|
Note on CleanParagraphBreaks
The CleanParagraphBreaks property being set to True will only have any affect on the Formatted Record Area if the Splittable property is also set to True. In other words the paragraph will not break at all (and therefore never needs to consider the type of break) if the Splittable property is set to false. If however CleanParagraphBreaks is set to True and Splittable is also set to True then LayoutEngine will take care to make sure that any splitting performed on the Formatted Record Area will always result in at least two lines of the paragraph being kept together (no orphaned lines). The only exception to this is if the paragraph itself is only one line then that one-lined paragraph will appear by itself.