AnsweredAssumed Answered

Open Date Filter in Out of Box Active Request List Report

Question asked by Balram.Deswal on Oct 24, 2016
Latest reply on Dec 12, 2016 by Balram.Deswal

Hi Team,

 

I have set up CABI Jaspersoft r6.2.0. I am using Jasperstudio for customizing the reports. I created a copy of out of box Active Request List report. After that, from Jaspersoft, I added the following input controls in that copied report:

 

 

 

These controls were started displaying in the Jasperstudio Repository Explorer as shown below:

 

After this, I updated the source code of the report in Jasperstudio to add the parameters as follows:

<parameter name="p_finalstartdate" class="java.sql.Timestamp"/>
<parameter name="p_finalenddate" class="java.sql.Timestamp"/>
<queryString>

 

And finally updated the query to add the condition of the open date of request as follows:

SELECT
cr.ref_num,
cr.id,
cr.open_date,
cr.priority_symbol,
cr.status_symbol,
cr.summary,
cr.web_url,
cr.customer_combo_name,
cr.assignee_combo_name,
cr.assignee_combo_name as ANALYST
FROM
cr
WHERE cr.type = 'R' and cr.active = 1 and cr.open_date >= $P{p_finalstartdate} and cr.open_date <= $P{p_finalenddate}
ORDER by ANALYST, cr.id DESC

 

The report is not giving any errors during execution, but it is not displaying any results after providing the start date and end date in the following prompt:

 

Kindly provide solution for this.

 

Thanks & Regards,

Balram Singh Deswal

Outcomes