Adding Data Columns from Data Model Tab

Follow the steps below to add data columns (from the Data Model tab) to the report:

Select the Data Model tab on the Design Panel located on the right side of the window.
Left click the Data Model folder, and then click the appropriate sub folder, such as Fields, to expand it.
Drag and drop the desired object from the expanded folder to the Report Data section of the Designer canvas.
Result: The object now displays in the Report Data section in its own column.

Click the object just placed in the Report Data section of the canvas.
Result: The Properties dialog for the object is displayed in the Design panel located on the right side of the window.

Set any other applicable properties.
Save the report by selecting Report > Save from the main menu.

The following table provides descriptions for the report data column property settings available for reports:

Property	Description	Grouping
Data Member	Determines the table or view used for the data column.	Data
Data Field	Determines the field or expression used to generate the data column. Choices are: Parent or child nodes of the selected data member Expressions can be used to define the data column	Data
Label	The name of the data column (if other than the data field selected above). Choices are: Enter the text for the label Expressions can be used to determine when a label is applied or changed when viewing the report	Data
Translate Label	Determines if the label will be translated when a report is run by a user. NOTE: Translations must exist in the Translation File for this property to work. Choices are: Yes No Expressions can be used to define the Translation Label value	Data
Link	Determines the page to be displayed when the data column is selected. Choices are: Enter a URL Use an expression to define the URL conditions	Data
Width	Determines the width of the data column. Choices are: Enter the width. Use an expression to define the width	Appearance
Format	Determines the date format in which a Date field value will display. Choices are: None MM-DD-YY DD-MM-YY YYYY-MMM-dd MMM-DD-YYYY MM-DD-YY HH:MM:SS DD-MM-YY HH:MM:SS DD-MMM-YYY HH:MM:SS Use an expression to define the date format	Appearance
Color	Determines the color of the data displayed in the field. Choices are: None Red Green Blue White Black Pink LightBlue LightGreen Gray Use an expression to define the date format	Appearance
Background Color	Determines the background color of the field . Choices are: None Red Green Blue White Black Pink LightBlue LightGreen Gray Use an expression to define the date format	Appearance
Font Family	Determines the Font Family used for the displayed data. Choices are: None Tahoma Times New Roman Trebuchet MS Use an expression to define the date format	Appearance
Image URL	Determines if an image from an external link is to be displayed Choices are: Specify the URL to the image to be displayed Use an expression to define image URL properties	Image

See Also

Layout and Data Properties

Basic Report Designer Functions

Report Design Layouts