Skip to Content
0
Former Member
Jul 20, 2006 at 03:17 AM

Selection criteria in XL Reporter

20 Views

Hi,

I am currently writing a sales report using XL Reporter.

It needs to allow user to specify the document date and Item Group that they want to look at.

(a) Item Group

The only dimension that I can retrieve "Item Group" is Dimension Item.

If I create a parameter for Item Group refering to Dimension "Item", the Item Group displayed for selection is duplicated because there are > 1 item group in OITM.

Is there a way to get around it?

(b) Documentation Date

How to set up a parameter that refer documentation date? I can't use dimension "Financial Period" because the use needs to specify document date wanted not Financial Period wanted.