Assumed Sold Report

Assumed Sold Report

This report will generate the data collected showing the Events with TicketGroups assumed as sold.

Report Definition

  1. Author

    1. April Dianne Gahuman

  2. Presentation Medium

    1. SSRS Portal

  3. Fields (Data)

    1. Exchange

    2. Event Name

    3. Event Date

    4. Venue Name

    5. City

    6. Market Intel Count

      1. #

      2. TicketGroupID

      3. Section

      4. Row

      5. Seats

      6. Price

      7. Quantity

      8. Date Added

      9. Date Assumed as Sold

  4. Grouping

    1. Event ID

    2. Event Name

    3. Event Date

    4. Venue Name

    5. City

    6. Ticket Type

    7. Ticket Exchange

    8. Market Intel Count

  5. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here: TBPortal → SSRS Reports → Assumed Sold Report

  6. Intended delivery mechanism (run on demand vs. delivered by subscription)

    1. On Demand

  7. Future maintenance tasks or manually maintained items

    1. N/a

Data Source(s)

The data source is from the STG Database.

Stored Procedures:
[reporting].[FindAssumedSoldEvents]
[reporting].[GetAssumedSoldEventTickets]

Filters

Filter Name

Description

Filter Name

Description

Event Name

Lets you input specific Event Name to show.

Venue Name

Lets you input specific Venue Name to show.

City

Lets you input specific City to show.

Ticket Exchange

Drop down menu showing options for Ticket Exchanges (Apex. EiBox Office, Seat Geek, StubHub, Ticket Evolution, Ticket Network, Vivid

Event Date From

This field displays a calendar to which you can select the desired starting date.

Event Date To

This field displays a calendar to which you can select the desired ending date.

 

Related content