For starters I am using the birt all-in-one instance (BIRT version 2.5.2, Eclipse version 3.5.2).<br />
<br />
I am new to BIRT and have gone through a couple of tutorials. I have checked forums and have found some potential solutions that use the tag library which do no seem to translate to the all-in-one method of report design.<br />
<br />
So, the basic scenario is this: I have a database full of service requests. I want to check for same day status updates based on the service date. Management would like to check a month or more at a time. Here is a simplified version of the query for the result set:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Select *
from serviceRequests s
inner join changeLog l
on (s.svcDate=l.changeDate and s.idNum=l.idNum)
where
s.status='canceled' and
l.oldValue='scheduled' and
l.newValue='canceled' and
s.svcDate>= ? and
s.svcDate<= ?;
</pre>
<br />
So, I created report params rp_startDate and rp_endDate and result set parms rsp_startDate and rsp_endDate (which I linked to the report params) but the input could not find the way to the dynamic links. I could not seem to find any way to explicitly bind the result set params. <br />
<br />
I tried calling them out in the query itself (e.g. params["rsp_endDate"].value) without success.<br />
<br />
I tried taking the s.svcDate where statements out of the query and used report parameters to filter the s.svcDate variable at the data set level. However, this seems to bog the query down significantly. <br />
<br />
I am guessing in the interest of optimization it would be best if the values could be included in the query in a where statement.<br />
<br />
I would prefer to collect the parameters separately rather than a more complex delimited field to keep it simple for end users.<br />
<br />
What is the best way to tackle the problem?
