[Rlib-users] Dataset for "Basic Charting" example grN columns, why duplicates?

[Jeff K. <jt...@ya...>]

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.