REPORT "Multi-level, no subreports: Need Line"
ID 22309
{
SETTING { DECIMALSEPARATOR "." }
SETTING { LISTSEPARATOR "," }
SETTING { MEASUREMENT METRIC }
SETTING { PAGESIZE -1", 0.00 }
SETTING { REPORTFORMAT 20 }
SETTING { EXTRACTFILE "test" }
SETTING { STYLESHEETFILE "Reports\StyleSht\default.xsl" }

TABULAR 1
{
SELECT "Name" LEGEND "Source"
WHERE Class = Definition
ORDERBY "Name"
JOIN
WHERE REFERENCEDBY = "performerSource"
JOIN
SELECT "Name" LEGEND "Need Line"
WHERE Class = Definition
WHERE "Type Number" = 1402
ORDERBY "Name"
JOIN
WHERE REFERENCES = "performerTarget"
JOIN
SELECT "Name" LEGEND "Target"
WHERE Class = Definition
ORDERBY "Name"
}
}

REPORT "main: 1 level with 2 subs (1 level, 1 level)"
ID 52510
{
FONT "Font4" { NAME "Courier" HEIGHT 12 }
SETTING { DECIMALSEPARATOR "." }
SETTING { LISTSEPARATOR "," }
SETTING { MEASUREMENT ENGLISH }
SETTING { PAGESIZE -1", 0.00 }
SETTING { HEADER 1 "OV-03 Need Line" }

TABULAR 1
{
SELECT "Name" LEGEND "Need Line"
WHERE Class = Definition
WHERE "Type Number" = 1402
REM "Need Line"
ORDERBY "Name"
SUBREPORT "Subreport: OV-03 Need Lines Working - PerformerSource" { }
SUBREPORT "Subreport: OV-03 Need Lines Working - PerformerTarget" { }
}
}
REPORT "Subreport: OV-03 Need Lines Working - PerformerSource"
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"
}
}
REPORT "Subreport: OV-03 Need Lines Working - PerformerTarget"
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 = "performerTarget"
JOIN

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