<p>Hi, I'm trying to make a report which queries a view containing millions of rows. There are basically two fields I need to filter on, one is an ID, the second is a time. So I've encountered two problems. </p>
<p> </p>
<p>1) It seems like the filter is only applied after the query is run and all the data is returned, which in my case, never resolves and throws out of memory. Is this normal? If so, then I guess that filter is inadequate in this case, which leaves parameters.</p>
<p> </p>
<p>2) But the param cannot take multiple values... So if you want to pass more than one ID, you have to code a script to modify the SQL query to include the parameter manually?</p>
<p> </p>
<p>It just seems weird as both of these seem rather basic for a reporting tool... How could passing multiple parameter values never be implemented in Birt? What is the use of having filter which loads results in memory that will never be used because they will be filtered anyhow? I guess maybe filters for subreport when the dataset data is already in memory but has to be used as a subset?</p>
<p> </p>
<p>Thanks!</p>
