Hello Gouthi,
Follow below points for your solution...
1) Download database script and create database.
2) Create New Report.
3) In report create Data Sources, after that create Datasets with Select script from 'CASE statement.txt' file.
4) Now drag LIST item on report, Select 'Group Properties..' from 'Row Groups -> Details' panel.
5) In 'General' Tab , Add Group on '[Certificate]'.
6) Now drag or add 'Rectangle' on LIST.
7) Drag Table and bind with datasets field as per above link.
8) Select and put Shape chart type, and set chart data. Set Values -> NumberFilms, Category Groups -> Length.
9) Now Right Click on Shape chart and select 'Show Data Labels'.
10) Now Run report.
commented on Jun 6 2012 7:40AM