| Query Question [message #250388] |
Mon, 30 July 2007 10:21 |
Eclipse User |
|
|
|
Hello!
Have a JDBC Datasource and want now to display data using report
parameters!
First parameter ist StartTime and StopTime to select the TimePeriod, an
other parameter is Name. Starting the report I want to choose StartTime -
StopTime but no Name parameter!! Just want to get all entries in this time
Period. As a further step I want now to filter on Names in this
TimePeriod. As a next step I want again to filter just over an other
TimePeriod with all Names and then again filter on Names. I tried this
with Property Bindings but I cannot match it to start just with TimePeriod
Filter! Hopefully my problem is clear and somebody can give me an example
how to do this!
SQL Statement I am using:
select *
from baleview_aag
Order by baleview_aag.StartTime
... with filter on StartTime and StopTime.
But it doesn't work to pass "NULL" to default filter Name or "Blank"
because result is always null?! When passing a Name just all entries with
this name are viewed!?
Thanks a lot and regards,
Chris
|
|
|
Powered by
FUDForum. Page generated in 0.03589 seconds
Home