PLUGIN README
Report Builder - Create and display custom reports with MySQL which users can
view directly or export as CSV.
-------------------------------------------------------------------------------


OVERVIEW
-------------------------------------------------------------------------------
This is an advanced plugin for website developers.  It allows you to quickly
create reports from the data in the CMS that users can then view from within
the CMS.

Note that creating reports requires MySQL knowledge so you'll need to either
know MySQL or have access to someone who does.  But either way, this plugin
will greatly reduce the amount of time required to create a report automating
the process. No programming is required other than writing a MySQL query.


GETTING STARTED
-------------------------------------------------------------------------------
First, activate the "Report Builder" plugin in the CMS under: Admin > Plugins.
Now click the "Reports" menu that was automatically created.

When first activated activated, the plugin will automatically create a small,
hidden section with sample product order data and two example reports that use
that data.

To see how reports work, try viewing these reports and exporting their data as 
CSV.


CREATING A REPORT
-------------------------------------------------------------------------------
To create a report, login to the CMS as an "Admin" user and click on the
"Reports" section, followed by the "Report Builder" menu.

Click the "Create" button, then enter a report name and a MySQL query, then 
click Save and your report will be added to the menu.

To get an idea for how to write a report, click "modify" on the existing reports 
to examine them.


LIMITING REPORT ACCESS
-------------------------------------------------------------------------------
You can limit or grant access to view reports on a user by user basis just like
you can with any other CMS section.  To do so just edit the user under "User
Accounts" and add or remove access to the "Reports" section under Section Access.

Note that access to reports is grouped so if the users has access to the
"Reports" section they will have viewing access to all reports.

Also note that only CMS users with administrator access can create, modify, or
delete reports.

-------------------------------------------------------------------------------
end of file.

