Valentina Studio (Databases and Reports)

For everything that's not in any way related to PureBasic. General chat etc...
User avatar
the.weavster
Addict
Addict
Posts: 1537
Joined: Thu Jul 03, 2003 6:53 pm
Location: England

Valentina Studio (Databases and Reports)

Post by the.weavster »

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 :wink:

*Edited as I have confirmed reports can definitely be connected to an ODBC datasource.
Last edited by the.weavster on Thu Mar 24, 2016 2:27 pm, edited 3 times in total.
collectordave
Addict
Addict
Posts: 1309
Joined: Fri Aug 28, 2015 6:10 pm
Location: Portugal

Re: Valentina Studio (Databases and Reports)

Post by collectordave »

Just a quick question

How does the free version interface to PureBasic?
Any intelligent fool can make things bigger and more complex. It takes a touch of genius — and a lot of courage to move in the opposite direction.
User avatar
the.weavster
Addict
Addict
Posts: 1537
Joined: Thu Jul 03, 2003 6:53 pm
Location: England

Re: Valentina Studio (Databases and Reports)

Post by the.weavster »

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.
User avatar
Danilo
Addict
Addict
Posts: 3037
Joined: Sat Apr 26, 2003 8:26 am
Location: Planet Earth

Re: Valentina Studio (Databases and Reports)

Post by Danilo »

@the.weavster:
I get a security warning 'NET::ERR_CERT_INVALID' for your site.
Fred
Administrator
Administrator
Posts: 16619
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: Valentina Studio (Databases and Reports)

Post by Fred »

Is it done using PureBasic ?
User avatar
the.weavster
Addict
Addict
Posts: 1537
Joined: Thu Jul 03, 2003 6:53 pm
Location: England

Re: Valentina Studio (Databases and Reports)

Post by the.weavster »

Fred wrote:Is it done using PureBasic ?
C++ I think.
Should this be in Off Topic not Announcements?
User avatar
the.weavster
Addict
Addict
Posts: 1537
Joined: Thu Jul 03, 2003 6:53 pm
Location: England

Re: Valentina Studio (Databases and Reports)

Post by the.weavster »

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
Lynn
New User
New User
Posts: 1
Joined: Fri Feb 23, 2018 6:14 pm

Re: Valentina Studio (Databases and Reports)

Post by Lynn »

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.
Post Reply