Seaking out a Report Seat Map by Price Zone

I'm also seeking this out... I'm guessing if there's no reply since 2010 there may not be a report that does this?

I converted Ryan's example code in the SSRS pack they mention at the conference.

I was doing it as we needed to specify the colours for zone numbers for our SYOS map

Insert @seats (screen_no, xpos, ypos, seat_no, zone_no )
Select s.screen_no,
             s.xpos,
             s.ypos,
             seat_no = s.seat_no,
             zone_no = p.zone_no
From [dbo].T_SEAT s (NOLOCK)
JOIN [dbo].TX_PERF_SEAT p (NOLOCK) ON s.seat_no = p.seat_no and p.perf_no = @perf_no and p.pkg_no = 0
JOIN @screens sc on sc.screen_no = s.screen_no
Where s.smap_no = @smap_no
and s.is_seat=1

changed the final sql statement to essentially was so we could enter html colour styles into abbreviation in zone table or randomly assign them so map was distinctive

Select
            s.screen_no,
            screen_description = sc.description,
            s.seat_no,
            s.xpos,
            s.ypos,
            z.zone_legend,
            backcolor =
                        case
                                    when z.abbrev like '#[0-9a-f][0-9a-f][0-9a-f][0-9a-f][0-9a-f][0-9a-f]' then z.abbrev
                                    when s.zone_no%5=0 then '#ffff00'
                                    when s.zone_no%5=1 then '#00cc00'
                                    when s.zone_no%5=2 then '#ff6666'
                                    when s.zone_no%5=3 then '#ff9933'
                                    when s.zone_no%5=4 then '#9999cc'
                                    else '#ffffff'
                        end
From @seats s
JOIN @screens sc on s.screen_no = sc.screen_no
left join T_ZONE z (NOLOCK) on s.zone_no=z.zone_no and z.zmap_NO=@zmap_no

Order By s.screen_no, s.xpos, s.ypos

I converted Ryan's example code in the SSRS pack they mention at the conference.

I was doing it as we needed to specify the colours for zone numbers for our SYOS map

Insert @seats (screen_no, xpos, ypos, seat_no, zone_no )
Select s.screen_no,
             s.xpos,
             s.ypos,
             seat_no = s.seat_no,
             zone_no = p.zone_no
From [dbo].T_SEAT s (NOLOCK)
JOIN [dbo].TX_PERF_SEAT p (NOLOCK) ON s.seat_no = p.seat_no and p.perf_no = @perf_no and p.pkg_no = 0
JOIN @screens sc on sc.screen_no = s.screen_no
Where s.smap_no = @smap_no
and s.is_seat=1

changed the final sql statement to essentially was so we could enter html colour styles into abbreviation in zone table or randomly assign them so map was distinctive

Select
            s.screen_no,
            screen_description = sc.description,
            s.seat_no,
            s.xpos,
            s.ypos,
            z.zone_legend,
            backcolor =
                        case
                                    when z.abbrev like '#[0-9a-f][0-9a-f][0-9a-f][0-9a-f][0-9a-f][0-9a-f]' then z.abbrev
                                    when s.zone_no%5=0 then '#ffff00'
                                    when s.zone_no%5=1 then '#00cc00'
                                    when s.zone_no%5=2 then '#ff6666'
                                    when s.zone_no%5=3 then '#ff9933'
                                    when s.zone_no%5=4 then '#9999cc'
                                    else '#ffffff'
                        end
From @seats s
JOIN @screens sc on s.screen_no = sc.screen_no
left join T_ZONE z (NOLOCK) on s.zone_no=z.zone_no and z.zmap_NO=@zmap_no

Order By s.screen_no, s.xpos, s.ypos