REPORT "Subreport: OV-03 Need Lines Working - PerformerSource followed by another level"
ID 52514
{
FONT "Font4" { NAME "Courier" HEIGHT 12 }
SETTING { DECIMALSEPARATOR "." }
SETTING { LISTSEPARATOR "," }
SETTING { MEASUREMENT ENGLISH }
SETTING { PAGESIZE -1", 0.00 }

TABULAR 1
{
ORDERBY "Name"

JOIN
WHERE REFERENCES = "performerSource"
JOIN

SELECT "Name" LEGEND "Performer Source" LEGENDFONT Font4, "Type" LEGEND "Performer Type"
WHERE Class = Definition
WHERE "Type Number" = 1372, 1373, 1374, 1367, 1375, 1376, 1377 REM "Performer Source"
ORDERBY "Name"

JOIN
SELECT Relation
ORDERBY Relation
JOIN

SELECT "Name" LEGEND "Related", "Identity" LEGEND "Related Id"
ORDERBY "Name", "Identity"
}
}