|Dynamic where clause in Birt [message #915642]
||Mon, 17 September 2012 17:17
| Vani Ra
Registered: September 2012
Here is a question, probably not something new, but I am kind of stuck. |
I want to dynamically pass the where clause to birt to generate a report for me. I know how to pass parameters to Birt report but this is something totally different.
My where clause changes altogether in different scenarios. Actually am designing a search page which has many parameters and report is generated based on the values entered by the user. sometime user fills 2 fields and other times he might fill 10 fields.
Say at first, my query is Select * from xx where empNo. is yy
and second time it might be Select * from xx where salary Between 100 and 200
So In short, my where clause is very dynamic. and I want to keep where clause as a parameter and want to pass it to Birt manually at run time instead of pre defining it in data set. Is it possible to meet such requirement ?
Powered by FUDForum
. Page generated in 0.11595 seconds