cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic & Cascading (Multiple Values) Prompt

Former Member
0 Kudos

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.

==================================================================================================

Example:

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

Thanks

Sunil

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Can someone please help on this issue.

Thanks

Sunil