PureBasic Forums - English

There is now a free report viewer for customers of Valentina Studio Pro.

Valentina Studio Pro can be used to create databases, tables, queries, etc... for SQLite, MySQL, Postgres and Valentina DB.
It also has a visual report designer. Reports can also be connected to an ODBC datasource as well as the databases listed above.

Valentina Studio Free can be used to preview/print the reports created with Pro. With the upcoming version (out in the next few days) there will be a command line interface too, so you'll be able to use RunProgram() to call a report and have it output as a *.pdf file.

You may also find Valentina Server interesting, as well as serving reports created with Studio Pro it enables you to share SQLite databases in a client/server set up. There are various ways of communicating with Valentina Server including ODBC and a REST interface.

E&OE

*Edited as I have confirmed reports can definitely be connected to an ODBC datasource.

Just a quick question

How does the free version interface to PureBasic?

collectordave wrote:How does the free version interface to PureBasic?

It has a command line interface:

vstudio.exe
-project "~/Documents/MyProject.vsp"
-make_new_report "Report_1"
-datasource "vserver://host=localhost ..."
-query "SELECT * FROM t1"
-print_to_disk "~/Documents/1.pdf"
-format kToPdf

Look for RunProgram() in the PureBasic help file for an example of calling a program and reading its output.

@the.weavster:
I get a security warning 'NET::ERR_CERT_INVALID' for your site.

Is it done using PureBasic ?

Fred wrote:Is it done using PureBasic ?

C++ I think.
Should this be in Off Topic not Announcements?

Danilo wrote:@the.weavster:
I get a security warning 'NET::ERR_CERT_INVALID' for your site.

I've edited the URLs so they're now http not https

There is now an ongoing discussion about Valentina Reports and Valentina Studio Pro in use with PureBasic (via the C lib versions) on the Paradigma Software forum. Check it out.