|
Re: Dynamic where clause in report? [message #631419 is a reply to message #631306] |
Thu, 07 October 2010 13:55 |
|
Depending on your back-end database, I'd do something like the following:
where customer_name = ?
and
(customer_phone_number IS NULL or customer_phone_number = ?)
Some databases don't short-cut evaluation and that last clause may have to be written differently.
|
|
|
|
Re: Dynamic where clause in report? [message #631562 is a reply to message #631306] |
Fri, 08 October 2010 01:22 |
|
You can do pretty much whatever you want to the query text (not just the where clause) by clicking on the data set, going to the Script tab and going into the beforeOpen event. There should be a lot of examples of that in the BIRT communities, I'd search for beforeOpen or queryText.
|
|
|
Powered by
FUDForum. Page generated in 0.02939 seconds