Dataset for "Basic Charting" example grN columns, why duplicates?
Jeff Kowalczyk <jtk-/[email protected]> Sat, 3 Oct 2009 00:06:30 +0000 (UTC)
| Newsgroups | gmane.text.rlib.user |
|---|---|
| Message-ID | <[email protected]> |
As an RLIB evaluation for an upcoming report-writing project, I am reproducing
the "Basic Charting" example [1], using the provided chart.xml report
definition, and the columns from the plaintext representation.
I need some information on the g0_name...g4_name columns. I have a nearly
correct chart.csv, but extra grouping levels that the original doesn't have. I
presume there will be some duplicate columns, but I haven't figured out which
and why.
Can someone post the chart.csv that corresponds to the original example?
Thanks,
Jeff
[1] http://rlib.sicompos.com/examples.php "Basic Charting"
I have a working python script:
$ cat chart.py
import rlib
rpt = rlib.open()
rpt.add_datasource_csv("chart_csv")
rpt.add_datasource_csv("chart_m_csv")
rpt.add_datasource_csv("chart_header_csv")
rpt.add_query_as("chart_csv", "chart.csv", "products")
rpt.add_query_as("chart_header_csv", "chart_header.csv", "header")
rpt.add_query_as("chart_m_csv", "chart_m.csv", "m")
rpt.add_report("chart.xml")
rpt.set_output_format_from_text("pdf")
rpt.execute()
rpt.spool()
$ python chart.py > chart.pdf
The supporting datasets work fine:
$ cat chart_header.csv
"report_name","name","name2",
"Financial Summary Report ","Some Company INC","Expert Managers Of Restaurants",
$ cat chart_m.csv
"start_date","end_date"
"2003-09-07","2003-09-10"
I won't post the charts.csv here for space, see:
http://www.privatepaste.com/12cf7IxcEw
I would greatly appreciate suggestions and corrections on the proper use of the
g0_name...g4_name columns. If can explain why there are extra grouping levels,
that would be very helpful.
Thanks again.
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf