Base Report Automation

[sheltonjr]

I just started using BASE yesterday and have accomplished a lot.

1) I was able to get base to connect to my MySql database
2) I have created a query
3) I have created a report that uses that query and get a great report (except for Horz Lines, See earlier post)

Last year I wrote a QT application for our club that tracks equipment usage and calculates billing and stores all that in MySql.
I started adding report generating capabilities but found that tedious. I was looking for a free Crystal Reports or something similar
when somebody pointed me towards using OO, a program I already have on my Suse box.

Now getting to my question.

Is there a way to have my QT Application use OO to open my .odb document and pass the couple parameters required for the query and open the report for the user?

If I cannot pass query parameters, Is their a command line way to open my .odb document and have it start to open a report?

Thanks,
Jim Shelton

[r4zoli]

Last year I wrote a QT application for our club that tracks equipment usage and calculates billing and stores all that in MySql.
I started adding report generating capabilities but found that tedious. I was looking for a free Crystal Reports or something similar when somebody pointed me towards using OO, a program I already have on my Suse box.

I suggest to see into Pentaho reporting, community version: http://community.pentaho.com/

Is there a way to have my QT Application use OO to open my .odb document and pass the couple parameters required for the query and open the report for the user?

The report builder could digest some parameter at start, other parts not configurable in OOo by coding, but it is out my knowledge.