I was wondering if Reporting Services charts supports slicing and dicing
like the way Excel do without having to generate multiple chart reports for
the different dimension levels selection?

If it supports are there any reference available?

Thanks in advance.

"Nestor" <n3570r (AT) yahoo (DOT) com> wrote

Only in a very limited way. You can get a similar effect by using a Matrix
control and creating groupings based on the levels in a dimension, and these
groupings can be shown/hidden by the user. But the groupings are defined as
part of the report, and can't be changed by the user at runtime.

There is some information in Books Online.

Peter

Drop-down parameter selection can provide some OLAP chart interactivity,
by mapping parameters to dimensions:

http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/olapasandrs.asp
...
Using Parameters to Filter Data in the Report

The whole purpose for creating parameters is to filter the data that is
displayed in the report. To accomplish this we are going to rely on the
ability of Reporting Services that enables queries to be generated
dynamically at runtime. Treating the MDX query as an expression does
this. Again, to illustrate this technique we'll provide an example.

If we return to our static report example, we'd like to be able to
"slice" the report by a particular time member.
...
- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks a lot. In that case maybe I'll have to use OWC to achieve the same
effect.


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote