AnsweredAssumed Answered

Open Date Filter in Active Incidents Report

Question asked by varelafpy on Aug 23, 2018
Latest reply on Sep 7, 2018 by Paul_Coccimiglio

Hi!

i want to put a open date input control in a copy of Active_Incidents Report on CABI 6.2

the report is composed of the following

  1. main_jrxml
  2. Active_Incidents_By_Analyst.jrxml
  3. Active_Incidents_By_Analyst_subreport.jrxml
  4. Active_Incidents_By_Category.jrxml
  5. Active_Incidents_By_Category_subreport.jrxml

(i dont use the subreport of by priority and group)

I do the following:

First i select the filter from the repository

 

 

 

Then i set the parameter on the Main Report and sub-reports as follows:

 

In the MAIN report

first i set the parameter:

 

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

      <parameterDescription><![CDATA[]]></parameterDescription>

 </parameter>

then i set the variables:

<variable name="v_finalstartdate" class="java.lang.String" resetType="None">

<variableExpression><![CDATA["{ts'"+new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{p_finalstartdate})+"'}"]]></variableExpression>

</variable>

 

and finally i set the parameter in the subreport (by analyst and by category)

<subreportParameter name="p_finalstartdate">

<subreportParameterExpression><![CDATA[$V{v_finalstartdate}]]></subreportParameterExpression>

</subreportParameter>

 

In the respective subreports (by analyst and by category subreports)

Before the Query i set

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

 

Then in the query i set

and open_date >= $P!{p_finalstartdate}

 

Save and import..

The reports run without error message

But the only subreport that is filter like i want is the graph not the list

the list not appear in the report, i think that the report filter the list but the dates does not match or something like this.

i use  <parameter name="p_finalstartdate" class="java.sql.Timestamp"/> and and open_date >= $P!{p_finalstartdate} in the query of the graph and the query of the list, but only the graph are doing what i wanted.

Why the subreport(LIST) does not respond to the filter and the graph subreport does it?

 

Please help!

Outcomes