Home Forums Reporting Services Reporting Services 2008 Development How to create a summary for a dataset RE: How to create a summary for a dataset

  • October 17, 2017 at 8:36 am

    #1964035

    Here is some test data.

    create table #Test

    (

    Location varchar(10),

    PatientNumber varchar(100),

    TobaccoUseInLast30Days varchar(5)

    )

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p1','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p2','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p3','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p4','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p5','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p6','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p7','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p8','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p9','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p10','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p11','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p12','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p13','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p14','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p15','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p16','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p17','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p18','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p19','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p20','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p21','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p22','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p23','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p24','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p25','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A2','p26','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p27','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p28','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p29','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p30','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p31','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p32','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p33','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p34','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p35','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p36','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p37','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p39','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p40','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p41','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p42','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p43','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p44','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p45','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p46','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p47','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p48','Yes')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p49','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p50','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p51','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('A5','p52','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('B4','p53','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('B4','p54','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('B4','p55','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('B4','p56','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('B4','p57','No')

    insert into #Test(Location, PatientNumber, TobaccoUseInLast30Days) values('B4','p58','No')