[[PageOutline(2-5,Contents,pullout)]]
= Chart Report Generator =

== Description ==

Generate reports with chart using Google Chart API.
First developed in shell script and now in python.
I'm a new python programmer, so, any improvement to my code is welcome. I was discovering the language while coding this report.

It's not a plugin yet, but will be. Any help is welcome.
I'll try to improve the code, making the reports more flexible and easy to use.
The template is very simple and could be improved a lot. Maybe using another python library.


== Bugs/Feature Requests == 

Existing bugs and feature requests for ChartReportGeneratorPlugin are 
[report:9?COMPONENT=ChartReportGeneratorPlugin here].

If you have any issues, create a 
[http://trac-hacks.org/newticket?component=ChartReportGeneratorPlugin&owner=msbrogli new ticket].

== Download ==

Download the zipped source from [download:chartreportgeneratorplugin/tags/chartreportgenerator-0.1b here].

== Source ==

You can check out ChartReportGeneratorPlugin from [http://trac-hacks.org/svn/chartreportgeneratorplugin here] using Subversion, or [source:chartreportgeneratorplugin browse the source] with Trac.

== Example ==

Copy the files to any directory and configure the script editing ''config.py''.
The ''config.py'' have some suggestions!

== First Mode ==

Uses independent queries.
The query must have only two columns: the first is the labels and the second is the data.

{{{
{
  'title': 'section title',
  'description': 'section description (optional)',
  'queries': [
    {
      'title': 'chart title',
      'type': 'chart type', (available types are in Google Chart API)
      'filename': 'chart filename (don't use extension)',
      'sql': 'query to chart'
    },
    {
      'title': 'chart title',
      'type': 'chart type',
      'filename': 'chart filename (don't use extension)',
      'sql': 'query to chart'
    }
  ]
}
}}}

== Second Mode ==

Uses dependent queries. The ''main query'' must have only one column, and the ''query to chart'' must have only two columns: the first is the labels and the second if is the data. The tag ''${item}'' is replaced by current item in the ''main query''.

{{{
{
  'title': 'section title',
  'description': 'section description (optional)',
  'sql': 'main query'
  'queries': [
    {
      'title': 'chart title (can use ${item})',
      'type': 'chart type', (available types are in Google Chart API)
      'filename': 'chart filename (don't use extension and ${item})',
      'sql': 'query to chart'
    },
    {
      'title': 'chart title',
      'type': 'chart type',
      'filename': 'chart filename',
      'sql': 'query to chart'
    }
  ]
}
}}}

== Recent Changes ==

[[ChangeLog(chartreportgeneratorplugin, 3)]]

== Author/Contributors ==

'''Author:''' [wiki:msbrogli] [[BR]]
'''Maintainer:''' [wiki:msbrogli] [[BR]]
'''Contributors:'''