/
eVenue Discount Codes Report

eVenue Discount Codes Report

Owned by Jerome Ellos
Last updated: Apr 05, 2024 by Albert Saludaga

Requirements and Purpose

This report will show discount codes from different exchanges. Discount codes are gathered by a spider script taken from different sources.

Report Definition

  1. Author

    1. Jerome Ellos (Full Scale developer)

  2. Presentation Medium

    1. SSRS Portal

  3. Fields (data)

    1. Site Name

    2. Group Code

    3. Discount Code

    4. Password Code

Report Data Flow

The table needed from viagogo (212) are fetched by an ODBC Connector to be consumed by the Report. MySQL is the source database and it needs the ODBC Connector to bridge between SSRS and MySQL.

Datasource(s)

The main data source is table eVenue_Discount_Codes in the MySQL database Viagogo (192.168.10.212).

Datasets

Dataset Name

Query

Dataset Name

Query

1

dsDiscountCodes

SELECT * FROM eVenue_Discount_Codes ORDER BY site_name, group_code, discount_code

 

 

 

Related content