How to have optional Date input in Live Report

haoest

Hello,

I can easily get it to work with an optional String input. For example if I want to have an optional string filter, i can do it like this, which returns everything if %1 is not provided

select name from dtree where %1='' or name like %1 + '%%'

I can't do the same with a date field. If I do this nothing is returned

select name from dtree where %2 is null or createdate > %2

Furthermore, if I simply select the date, no data is returned either:

select %2

 

 

Any ideas?

Greg Griffiths

you can use LiveReport templates to check this and then add the appropriate SQL section.