quick report datepicker for parameter

Hi,

To have the date picker for a quick report the report type would need to be something like Crystal or Query Builder. Is it safe to assume that you are referring to a quick report of type SQL Statement?

Cheers

Hi @Sajith D ,

Yes SQL statement.

Thanks @Sajith D 

SELECT customer_id,Name 
from ifsapp.customer_info 
where creation_date >   '&[--S-L]CUSTOMER_INFO.CREATION_DATE'

Let’s say we need to check the date range. Can we achieve it? because in the given solution we cannot give the name we want in the parameter list. Any work around please?

Ex:

SELECT customer_id,Name 
from ifsapp.customer_info 
where creation_date between &From_date AND &To_date

is this Possible in Aureana client as well? I tried the same sql statement but it triggers and error.