vb.net - SSRS - Group Consecutive Rows of Same Time Spans -

vb.net - SSRS - Group Consecutive Rows of Same Time Spans -

related sql question - grouping consecutive rows of same value using time spans

i want convert table:

╔═══════════╦════════════╦═══════════╦═══════════╦═════════╗ ║ classroom ║ coursename ║ lesson ║ starttime ║ endtime ║ ╠═══════════╬════════════╬═══════════╬═══════════╬═════════╣ ║ 1001 ║ course of study 1 ║ lesson 1 ║ 0800 ║ 0900 ║ ║ 1001 ║ course of study 1 ║ lesson 2 ║ 0900 ║ 1000 ║ ║ 1001 ║ course of study 1 ║ lesson 3 ║ 1000 ║ 1100 ║ ║ 1001 ║ course of study 2 ║ lesson 10 ║ 1100 ║ 1200 ║ ║ 1001 ║ course of study 2 ║ lesson 11 ║ 1200 ║ 1300 ║ ║ 1001 ║ course of study 1 ║ lesson 4 ║ 1300 ║ 1400 ║ ║ 1001 ║ course of study 1 ║ lesson 5 ║ 1400 ║ 1500 ║ ╚═══════════╩════════════╩═══════════╩═══════════╩═════════╝

to table:

╔═══════════╦════════════╦═══════════╦═════════╗ ║ classroom ║ coursename ║ starttime ║ endtime ║ ╠═══════════╬════════════╬═══════════╬═════════╣ ║ 1001 ║ course of study 1 ║ 0800 ║ 1100 ║ ║ 1001 ║ course of study 2 ║ 1100 ║ 1300 ║ ║ 1001 ║ course of study 1 ║ 1300 ║ 1500 ║ ╚═══════════╩════════════╩═══════════╩═════════╝

the sql solution related question works query takes forever because have lot of info in tables , sql query using 2 sub queries. original table query 3 joins in complexity bigger.

i looking ssrs solution. possible using "vb magic" or other kind of magic in ssrs 2008 r2 ?

vb.net reporting-services ssrs-tablix ssrs-2008-r2 ssrs-grouping