I would like to setup a P&L to get the data from a date range.
At the "Advanced Report Buider", tab "Report Default", I entered the following code into "Complete Selection":
PER( Code >= @PeriodStart Or Code <= @PeriodEnd )
@PeriodStart: parameter point to "Code" of "Financial Period" table
@PeriodEnd: another parameter point to "Code" of "Financial Period" table
Everytime I run the report, it gave me the latest balance instead of the balance within the specified date range.
Please kindly advise.
Thanks in advance,
Vivian