The report definition below works EXCEPT when I used a domain to define the data type. In those cases, it displays the text description of the domain rather than the attribute. What do I need to change?
REPORT "Entity and Attribute Properties Report - Current Diagram (SDH)"
DESCRIPT "Meta Data associated with an Entity and each of its Attibutes"
ID 25299
{
SETTING { PAGESIZE -1, 0.00 }
SETTING { HEADER 1 "Entity and Attribute Properties" }
SETTING { TRAILER 1 "as of ", "date"," page","#pg#" }
SETTING { INHERITVIAISA YES }
FIELD "PK" { SOURCE PROPERTY "Key" LENGTH 1 TYPE BOOLEAN }
FIELD "Null" { SOURCE PROPERTY "Default Nullity" LENGTH 1 TYPE BOOLEAN }
FIELD "Data Type" { SOURCE PROPERTY "SQL Data Type" LENGTH 22 TYPE CHARACTER }
FIELD "Effectivity Type" { SOURCE PROPERTY "Effectivity Type" LENGTH 30 TYPE CHARACTER }
FIELD "Default Value" { SOURCE PROPERTY "Default Value" LENGTH 30 TYPE CHARACTER }
FIELD "Value List" { SOURCE PROPERTY "Value List" LENGTH 120 TYPE MEMO }
FIELD "Text Description" { SOURCE PROPERTY "Description" LENGTH 1500 TYPE MEMO }
FIELD "Unique Set of Attributes" { SOURCE PROPERTY "Unique Set of Attributes" LENGTH 500 TYPE MEMO }
FIELD "Availability" { SOURCE PROPERTY "Availability" LENGTH 30 TYPE CHARACTER }
FIELD "Comments" { SOURCE PROPERTY "Comments" LENGTH 3000 TYPE MEMO }
TABULAR 1 {
SELECT "Name" LEGEND "Entity" LABEL LEFT WIDTH 5.0
SELECT "Unique Set of Attributes" LABEL LEFT
SELECT "Availability" LABEL LEFT
SELECT "Comments" LABEL LEFT
WHERE Class = Definition
WHERE Type = "Entity"
WHERE Current = T
ORDERBY "Name"
JOIN
WHERE RELATION = "uses"
JOIN
SELECT "Name" LEGEND "Attribute" LABEL LEFT WIDTH 5.0
SELECT "Text Description" LABEL LEFT WIDTH 5.0
SELECT "PK" LABEL LEFT
SELECT "Null" LABEL LEFT
SELECT "Data Type" LABEL LEFT
SELECT "Default Value" LABEL LEFT
SELECT "Effectivity Type" LABEL LEFT
SELECT "Value List" LABEL LEFT WIDTH 5.0
WHERE Class = Definition
WHERE Type = "Attribute"
}
}