Drill Down Reporting
Posted on 2008-01-25
Hello Experts - this is a good one!
In Crystal Reports XI, there is a great feature that offers drill down capabilities based on Groups. I've set this up a few times before, and now have a need to display two "values" and also allow drill down. I wondered if it was possible, and therefore, am asking this question to the Experts.
Some additional background is that in the Chart Expert, I've chosen a "Stacked bar chart" and on the Data tab, am able to get the drill down to work with just one Value, when choosing the appropriate details (On Change of and Show Values) in the Group button. The Group button only allows me to choose one value though, so when I click the Advanced button in the Chart Expert, and add the second value, the drill down is not enabled anymore.
In testing, I was able to allow two values in the Chart Expert, add a Group Header with the Group names dropped in, and then the Group names had drill down enabled, but that defeats the purpose of having drill down capability in the chart.
Please let me know if you've been able to get around this Crystal Reports limitation by using CR XI. I know that multiple values with drill down is available in Webi, but, unfortunately, the company I'm working at does not license Webi, so I'm looking for a CR XI solution.