Obtaining data within a date range in XL Reporter
I'm currently working on BS in XL reporter.
I was trying to extracting data in a date range, setting PER( Code >= @MthFrom Or Code <= @MthTo ) in report default tab.
However, the result is shown as all data as of current date. E.g. Selection criteria: >=200808, <=200809, the result is shown as from Begining to 200810.
Please kindly advise.
Edited by: Julie Wan on Oct 1, 2008 1:10 PM
brent mcdonell replied
Change the XL Reporter code to: PER( Code >= @MthFrom And Code <= @MthTo )
The "Or" was ending up making the Period selection open-ended on both ends of your range. Changing it to "And" will keep it contained between those two Period Codes.
Hope this helps,