+2I have requirement to create a report and invoice date which is of date data type is the parameter that needs to be given in the order report dialog which should also allow between operator. I'm trying to use report_sys.parse_parameter(column (which is date data type), parameter (which is date datatype)).its throwing me invalid relational operator error.
How do we solve this.when the parameter is date data type.
Thanks in advance.
Best answer by Tomas Ruderfelt
I would suggest doing two parameters instead. Then you have full freedom in the RDF to create a proper WHERE statement instead of using Report_SYS.Parse_Parameter (which also might lead to performance issues).
Like this example:
voucher_date BETWEEN from_date_ AND from_date_
I would suggest doing two parameters instead. Then you have full freedom in the RDF to create a proper WHERE statement instead of using Report_SYS.Parse_Parameter (which also might lead to performance issues).
Like this example:
voucher_date BETWEEN from_date_ AND from_date_
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
