<p>Hi There esteemed BIRT developers.</p>
<p> </p>
<p>I am new to developing in BIRT, however I have used a few other report development tools in the past.</p>
<p> </p>
<p>I am starting off small here, so apologies for the stupid question.<br><br>
I have tried searching for a solution to my hurdle but alas nothing seems to full my needs.</p>
<p> </p>
<p>I am trying to develop a listing report for Maximo users that they can run themselves and uses a date range as the input parameters for the report i.e. DateFrom and DateTo, I am just not sure how to integrate this into the report OPEN query.</p>
<p> </p>
<p>sqlText = "select p.displayname "<br>
+ " ,LT.LABORCODE "<br>
+ " ,LT.CRAFT "<br>
+ " ,LT.REFWO "<br>
+ " ,LT.STARTDATE "<br>
+ " ,LT.REGULARHRS "<br>
+ " ,LT.PAYRATE "<br>
+ " ,WO.WORKTYPE "<br>
+ " ,wl.description "<br>
+ " from labtrans lt "<br>
+ " join workorder wo on lt.refwo = wo.wonum "<br>
+ " left join worklog wl on (wl.recordkey = wo.wonum and wl.class = 'WORKORDER') "<br>
+ " join person p on LT.LABORCODE = P.PERSONID "<br>
+ " where LT.STARTDATE between to_date('01/01/2014, 'dd/mm/yyyy') and to_date('15/12/2015', 'dd/mm/yyyy') "<br>
+ " order by LT.STARTDATE desc ";</p>
<p> </p>
<p>Once again apologies for the elementary question.</p>
<p> </p>
<p>Jag</p>
<p> </p>
<p> </p>
