Hi Jan,
You might need to 2 reports 1 main, 1 subreport.
[Main report parameters]
<parameter name="p_start_date" class="java.sql.Timestamp"/> <parameter name="p_end_date" class="java.sql.Timestamp"/>
[Main Report variables]
<variable name="v_start_date" class="java.lang.String" resetType="None">
<variableExpression><![CDATA["{ts'"+new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{p_start_date})+"'}"]]></variableExpression>
</variable> <variable name="v_end_date" class="java.lang.String" resetType="None">
<variableExpression><![CDATA["{ts'"+new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{p_end_date})+"'}"]]></variableExpression>
</variable>
[Subreport parameters]
<parameter name="p_start_date" class="String"/> <parameter name="p_end_date" class="String"/>
Create the main report and link the subreport and click on the subreport while on the main report and click edit parameters and link main report variables with the subreport parameters.
v_start_date - > p_start_date
v_end_date - > p_end_date
SELECT
casd.cr.ref_num,
casd.cr.id,
casd.cr.open_date,
casd.cr.priority_symbol,
casd.cr.status_symbol,
casd.cr.summary,
casd.cr.web_url,
casd.cr.customer_combo_name,
casd.cr.assignee_combo_name,
casd.cr.assignee_combo_name as ANALYST
FROM
cr
WHERE casd.cr.type = 'R' and casd.cr.active = 1 and casd.cr.open_date >= $P{p_start_date} and casd.cr.open_date <= $P{p_end_date}
ORDER by ANALYST, casd.cr.id DESC
Hope this gives you more info and resolves your issue.