on 12-15-2014 8:13 PM
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
Can someone please help on this issue.
Thanks
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.