Tabbed Report in SSRS using Bookmark

Here we will see how to create tabbed report in SSRS. Step 1: Create following SQL table to work on IF OBJECT_ID(N'dbo.EMPDetails',N'U') IS NOT NULL DROP TABLE dbo.EMPDetails CREATE TABLE dbo.EMPDetails ( EmpId int, EmpName nvarchar(50), Location nvarchar(500), EmpSalary int ) INSERT INTO dbo.EMPDetails VALUES (11,'Emp1','Chennai',1000),(12,'EMP2','Chennai',1000), (13,'Emp3','Bangalore',1000),(14,'Emp4','Mumbai',1000), (15,'Emp5','Hyderabad',1000),(16,'Emp6','Hyderabad',1000), (17,'Emp7','Chennai',1000),(18,'Emp8','Chennai',1000), (19,'Emp9','Bangalore',1000),(101,'Emp1','Mumbai',1000), (111,'Emp11','Hyderabad',1000),(112,'Emp12','Chennai',1000), (113,'Emp13','Chennai',1000),(114,'Emp14','Hyderabad',1000), (115,'Emp15','Bangalore',1000),(116,'Emp16','Chennai',1000), (117,'Emp17','Hyderabad',1000),(118,'Emp18','Chennai',1000), (119,'Emp19','Mumbai',1000),(120,'Emp2','Hyderabad',1000), (121,'Emp21','Bangalore',1000),(122,'Emp22','Hyderabad',1000), (123,'Emp23','Mumbai',1000),(124,'Emp24','Bangalore',1000), (125,'Emp25','Bangalore',1000),(126,'Emp26','Hyderabad',1000), (127,'Emp27','Bangalore',1000),(128,'Emp28','Mumbai',1000), (129,'Emp29','Hyderabad',1000),(130,'Emp3','Hyderabad',1000), (131,'Emp31','Mumbai',1000),(132,'Emp32','Bangalore',1000), (133,'Emp33','Bangalore',1000),(134,'Emp34','Bangalore',1000), (135,'Emp35','Hyderabad',1000),(136,'Emp36','Chennai',1000) Step 2: Create Shared Data … Continue reading Tabbed Report in SSRS using Bookmark

Advertisements