I am using sharepoint 2010 and ssrs 2008 r2. Require to know about how to genertae drill down chart using ssrs 2008 r2 in report builer 3.0.
Ex: I am using report builder 3.0 to generate report using sharepoint list as a datasource. That list havingthe coloumn Project Name, Month, Year and Revenue.My chart should be like this,
1.Project Name VS Revenue Chart
2. Then If i click project Nam bar, it should show the chart Year VS Revenue for the corresponding Project Name.
3. Then if click that Year bar, It should show the chart Month VS Rvenue for the corresponding year and Project Name.
Reverse drill down also need to know.
Any one help me. I am new to this SSRS.
Kanthavel