Hi,
My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report.
I tried to filter the date range using 'select expert' which set the between from to transaction parameter.
If I press F5 in the CRYSTAL REPORT, the date filter is populated in advance. However, if I run report, it never interrupts the report.
your advice will be greatly appreciated. Sage is SQL based.
If you want to have a prompt for dates when running a customized Crystal Report, you need to set them up in the report as a Parameter Field, then use the Parameter Field(s) in the report selection criteria.
Be careful doing that with Sage stock reports (like the Statements), because sometimes report totals are pre-calculated by Sage programming, instead of being the result of report formulas.
Specifically, for that report, the aging amounts will not automatically adjust if you filter out some row data.
