Hi All,
i was wondering if anyone could help me.
Say if i have a Tree prompt and it is set to multi select ie a GL account structure and a user selects two or more parents from the structure, do you know how you can retrieve all of the children from all of the accounts the user selects.
i know i have to use the descendents function, but i only kow how to use this when there is only one selection, not multiple selections from the same hierarchy.
Any advice would be great.
Thanks.
I would try using the children function. Maybe use children(?parameter?) in the query for your parameter? or in the query calculation in the report?