I am passing a From Date and a To Date from a Tabbed UI Button for a report that is used to filter the records displayed on the report. I would like to print the entered From Date and To Date on the report. The SQL filter on the Report Genie is LOGS.log_date>=:fromDate AND LOGS.log_date<=:toDate and the Argument bindings fromDate and toDate and the Argument Value is <Prompt at Run-Time>
I have been looking into how to do this and the documentation is fuzzy. What I've found is:
a5_getReportSQLFilter(L flagResolveArgument) - gets the SQL filter that was passed in to the print method. If the flagResolveArguments parameter is set to .T. (default value), the the arguments in the filter are resolved
To print out the value of the argument that was passed in, you would create a calculated field that uses the A5_getArgumentValue() function
In the Calculated Values, I've defined two values:
FDate = a5_getargumentvalue(calc->fromDate)
TDate = a5_getargumentvalue(calc->toDate)
I'm trying to use the FDate and TDate to print the values on the report.
So it looks like I might have the right pieces, I'm just not sure how and where to apply them. So my specific questions are:
1. Where do I define and enter the a5_getReportSQLFilter(L flagResolveArgument) to retrieve the variables that were entered for the report filtering?
2. How are the Calculated fields entered that will allow me to print the To and From dates?
Thanks for the help
Tim
I have been looking into how to do this and the documentation is fuzzy. What I've found is:
a5_getReportSQLFilter(L flagResolveArgument) - gets the SQL filter that was passed in to the print method. If the flagResolveArguments parameter is set to .T. (default value), the the arguments in the filter are resolved
To print out the value of the argument that was passed in, you would create a calculated field that uses the A5_getArgumentValue() function
In the Calculated Values, I've defined two values:
FDate = a5_getargumentvalue(calc->fromDate)
TDate = a5_getargumentvalue(calc->toDate)
I'm trying to use the FDate and TDate to print the values on the report.
So it looks like I might have the right pieces, I'm just not sure how and where to apply them. So my specific questions are:
1. Where do I define and enter the a5_getReportSQLFilter(L flagResolveArgument) to retrieve the variables that were entered for the report filtering?
2. How are the Calculated fields entered that will allow me to print the To and From dates?
Thanks for the help
Tim
Comment