<p>Hello everyone.</p>
<p> </p>
<p>I am new to BIRT and am looking for any specific information on creating date parameters.</p>
<p> </p>
<p>I have some basic guides but they don't seem to go thru the full process and I think I am getting hung up somewhere. I was hoping reviewing some more detailed documentation on this might be best.</p>
<p> </p>
<p>The short explanation is this:</p>
<p> </p>
<p>I am trying to have the end user enter FROM/TO dates for a specific field to filter the data.</p>
<p> </p>
<p>I set up report parameters for each (FROMDate, ToDate)</p>
<p> </p>
<p>I then set up Data Set parameters for each and link to the report parameters.</p>
<p> </p>
<p>I create query and in the WHERE clause, mark the field with a ?:</p>
<p> </p>
<p>WHERE</p>
<p> d.compl_dte >= ? ((this will be FROMDate))</p>
<p>AND d.compl_dte <= ? ((this will be TODate))</p>
<p> </p>
<p>When saving the query, I get an error that notes: "Cannot get the result set metadata", "SQL statement does not return a ResultSet object", and "D"."COMPL_DATE": invalid identifier.</p>
<p> </p>
<p>Any assistance would be appreciated.</p>
<p> </p>
<p>Complete query below:</p>
<p> </p>
<div>SELECT a.stud_id,</div>
<div>a.lname,</div>
<div>a.fname,</div>
<div>a.dmn_id,</div>
<div>a.region_id,</div>
<div>a.email_addr,</div>
<div>a.org_id,</div>
<div>a.jl_id,</div>
<div>a.cntry,</div>
<div>a.job_title,</div>
<div>b.lname as superlname,</div>
<div>b.fname as superfname,</div>
<div>b.email_addr as supermail_addr,</div>
<div>c.enrl_dte,</div>
<div>c.enrl_stat_ID,</div>
<div>d.cmpl_stat_ID,</div>
<div>d.compl_dte,</div>
<div>d.cpnt_id,</div>
<div>d.cpnt_typ_id,</div>
<div>e.cmpl_stat_desc</div>
<div> </div>
<div>FROM pa_student a,</div>
<div> pa_student b,</div>
<div> pa_enroll_seat c,</div>
<div> pa_cpnt_evthst d,</div>
<div> pa_cmpl_stat e</div>
<div>WHERE b.stud_id(+) = a.super</div>
<div>AND a.stud_id = d.stud_id</div>
<div>AND d.stud_id= c.stud_id(+)</div>
<div>AND d.schd_id = c.schd_id(+)</div>
<div>AND d.cmpl_stat_id = e.cmpl_stat_id</div>
<div> AND d.compl_date >= ?</div>
<div> AND d.compl_date <= ?</div>
<div>/** and a.stud_id = '10014615' */</div>
<div>ORDER BY a.lname, a.fname, d.cpnt_id</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
