Skip to Content
0
Former Member
Aug 10, 2010 at 06:23 PM

Display Drill Level when skipping drill levels with rightlclick/drill tbar.

22 Views

I have report in which I have a complex if (drillfilters() ....) function to print the proper label for the current drill level. For instance, if a person drills down to "Region", then the word "region " prints, and when they drill back up to National, the word "national" prints. I accomplish this by looking at the value of DrillFilters() and assigning a label based on whatever the current value is.

However, DrillFilters() the function is useless when a person right clicks the drill header and uses the menu to drill down (or up) and skip a few levels. Also, the drill toolbar will kill the drillfilters() function as well. When using either of these two methods, the value for drill filter doesnt change, or becomes inconsistant. Does anyone know of a workaround that will allow the drillfilters function (or something similar) to work....

In summary, I need to print a simple section label that represents the value of the current drill level. Drillfilters is not the total solution.