Skip to Content
0
Former Member
Mar 03, 2009 at 08:13 AM

XL Reporter: Date Range issues

24 Views

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