Hi,
How can I use datepicker for quick report parameter in IFS Enterprise Explorer 10?
Best answer by Sajith D
View original
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
Yes SQL statement.
Hi
Just realized that you can actually do this using a syntax similar to below.
SELECT customer_id,Name
from ifsapp.customer_info
where creation_date > &CUSTOMER_INFO.CREATION_DATE
Cheers
Thanks
+1
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
+1
is this Possible in Aureana client as well? I tried the same sql statement but it triggers and error.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.