Skip to Content
author's profile photo Former Member
Former Member

Dynamic & Cascading (Multiple Values) Prompt

Request help from experts on the following issue:

We have various organization hierarchical structures in our company & the users need a prompt to select a specific organizational hierarchy structure, followed by a specific level within the organization hierarchy and associated values within that Level: Here is how the prompt needs to look like:

1 Fiscal Year - List of values (2015, 2014, 2013, 2012 and so on) - Dynamic list - User selects 1 value from the list)

2 Organization Hierarchy structures - (Dynamic List corresponding to Fiscal Year Selected in 1 above) - List of Values ( A, B, C, D and so on) - User selects 1 value form the list.

3 Based on hierarchy selected, display all the levels within the hierarchy structure. The level selected by the user will act as 1st level of grouping in the report.

4 Based on level selected above, corresponding values with *-All option to appear for user selection. This would be a filter.

5 List all levels of the hierarchy below the one selected in point # 3 above for 2nd level of grouping.

6 List associated values for filter based on level selected at Point # 5. Provide *-All option.



Points 1-4 above

Fiscal Year Hierarchies Levels Values

2015 A (1 to 7) user selects say 3 All codes for Level 3 with *-all option

Points 5-6 above

Levels Values

Should list levels 4-7 for selection Values based on Level Selected by the user


The query I wrote works perfectly fine to handle points 1-4. 2nd level of iteration works but would only list level 4 in the example above. We need to see Level 4, 5, 6 and 7 (if 7 is last level) for selection.

Notes : LOV will be limited to 1000 values. Writing a single query may return more then 1000 values. In order to curtail results some of the parameters need to pass on to the query.

Should I go for a stored procedure / UDF ?? Will it work in business view manager?? BOXI 3.1 - CR XI / 2008



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 05:40 PM

    Can someone please help on this issue.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.