How to fetch from data sets only some selected value in a Birt report
I have created a BIRT report on RTC 4.0.0. which prints some details from only some workitems.
So I have created a parameter on my BIRT report. The values of this parameter are set when report is executed by a user selection of some Workitems.
No problem, I have correctly my selected values on my parameter.
Then I use this values on each Data Sets with a filter. I use for example this syntax :
This syntax is correct and returns wanted values because I can use the operator "IN".
However, this is a filter and I have just learnt that filter is applied after data sets is fetched ... So if many many data are reported from data sets, the filter is useless...
I have discovered that it's better to use a parameter because data are filtered with this parameter before data sets are fetched ... And so many data are not returned !!!
Problem : how can I use an operator as "IN" in the parameter configuration window ...
I see that I can set a specific value but not a value which is stored on a parameter list.
Thanks for your help
Regards
Mathieu
One answer
WI_ID in WI_ID_FILTER
Comments
Thanks Bill for this response. It works for filter but I would like to use a parameter in order of a filter.
In fact, with the parameter, the selection is done before than data are fetched whereas filter is applied after all data are collected ...
So I would like to use parameter with multi value but the operator IN should not be available.
Mathieu
There are two filters in a data set. The filter tab gives you a post-fetch filter - not sure how useful this is. But the Filter section in the main tab is a pre-fetch filter I believe.
I'm not sure I fully understand your response. A multi-value text parameter is a bit tricky and I'm not sure Integer fields support the use of "in"
I am going to explore this new filter tomorrow.
Thanks a lot