LAB EXERCISES FOR SSRS 2008

HI,
Here , I am giving LAB3 and LAB 4 Exercises
LAB 03 – TEST YOUR SKILLS ON GROUPING DATA

Create a report to display all Product details
a) Group records by
i) Product Class
ii) Product Name
b) Interactive Sort records by
i) Color
ii) Size

Data table Information :
RDBMS : SQL Server 2008
Table Name : Product
Database : SSRS

Output Requirements :
Data should be grouped by each Product Class and Product Name. Records should be displayed in the new page only.




LAB 04 – TEST YOUR SKILLS ON DRIL DOWN GROUPING

Create a report to display customer details such as region, city based on the selected country
a) Group records by
i.) Region
ii.) City
b) Sort records by
i.) Customer name inside each group
c) Drill down by
i.) Region
ii.) City
Data table Information :
RDBMS : SQL Server 2000
Table(s) : Customer
Database : SSRS
Inputs :
Country
Sample Output :






Thanks,
Narasimha