rotation."startdate" AND (
output."startdate">rotation."startdate" AND
output."startdate"<=rotation."enddate"
)
)
OR
(
rotation."enddate"rotation."startdate"
)
)
)
WHERE
rotation."runid"=$P{RUN_ID}
GROUP BY
rotation."cropnumber",
rotation."crop",
rotation."startdate",
rotation."enddate"
ORDER BY
rotation."cropnumber"]]>
<band splitType="Stretch"/>