Obtaining data within a date range in XL Reporter

[Former Member]

Dear All,

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.

Thank you.

Regards,

Julie

Edited by: Julie Wan on Oct 1, 2008 1:10 PM

[Former Member · Accepted solution]

Hello Julie,

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,

Brent McDonell

[Former Member · Accepted solution]

Dear Brent,

Thank you for your solution.

I've tried to change the formula to 'and' before, but misread the data and thought it was wrong. It works fine now.

Thank you!

Regards,

Julie

[Former Member]

Hi Julie,

Please check this thread to see if it is related to yours:

Thanks,

Gordon

[Former Member]

Dear Gordon,

Thank you for your reply.

However my case is different to your given link.

In my case, there is a result coming out, but not within the correct range i selected. It shows all instead.

I tried to set the period range in report default tab, in column tab of a expanding column, and in cell tab of an individual cell, but none have worked. E.g. PER( Code >= @MthFrom or Code <= @MthTo )

Regards,

Julie

[Former Member]

Please check customer portal to find a document called "Using Syntax and Functions in XL Reporter".

It is very helpful.

Thanks,

Gordon