====== VT Reports ======

Venture Tracker provides a simple interface to run individual reports - this can be accessed from the **Dashboards -> VT Reports** menu. An example is shown below:

{{ :dash:vt3_user_defined_reports.png?600 }}

The interface allows reports to be tuned and refreshed, the underlying SQL to be viewed (maybe to copy for the start of a new report) and also for the data to be exported in a number of formats (CSV is shown in this example).

Once a report has been created, it can be re-run at any time by any VT user. 

Creating and editing reports is controlled by user level permissions, but any logged in user of VT can see and run existing reports.

<WRAP round important>
It is worth mentioning that the reporting interface is secured – data can be read but NOT updated, changed or deleted, via the reporting system.
</WRAP>
===== SQL guidelines =====

In order to create VT Reports, you will need a basic understanding of Structured Query Language (SQL).  If needed, you can revise the basics here: [[+tab|https://sqlzoo.net/wiki/SQL_Tutorial|SQL Tutorial]]

<WRAP todo>
More to be added
</WRAP>

<WRAP info>
If you wish to include Extra Fields in your reports, you may wish to look at the following information: [[ef-schema|Extra Fields Schema]]
</WRAP>