Table of Contents
The Reports section of MC Trade offers a variety of tools for searching the database. Whether to create a report of specific data, pull data from a custom selection of fields, or search for SQL coding information to customize the database, the Reports dropdown menu has the necessary tools.
Video
Run a Report
The Run a Report section houses all the reports that can be run to summarize data collected in the database. There are 238 different reports for various types of collected data, and if these standard reports do not offer the specific parameters needed, a custom report can be made to pull the exact data required.
Click Here for more information on the Run a Report section.
Query Tool
The Query Tool is used to build a custom export based on specific search parameters. For example, the “Basic Profile Info” data view contains general information such as name and mailing address, as well as membership information such as Membership Level and Member Since Date.
The Query Tool offers over 20 data views, and each group offers many fields. For example, “Basic Profile Info” has over 100 possible fields.
Click Here for more information on the query tool.
Data Dictionary
The Data Dictionary lists all database tables and fields. It also includes the field type and field length. This feature is particularly useful to advanced users who are working with SQL queries or reports.
Click Here for more information on the data dictionary.
Manage Report Files
In addition to MC Trade's extensive library of reports, this part of the Reports module is used to add and create more reports via Crystal Reports.
Click Here for more information on managing report files.