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.
Valentina Studio (Databases and Reports)
- the.weavster
- Addict
- Posts: 1537
- Joined: Thu Jul 03, 2003 6:53 pm
- Location: England
Valentina Studio (Databases and Reports)
Last edited by the.weavster on Thu Mar 24, 2016 2:27 pm, edited 3 times in total.
-
- Addict
- Posts: 1309
- Joined: Fri Aug 28, 2015 6:10 pm
- Location: Portugal
Re: Valentina Studio (Databases and Reports)
Just a quick question
How does the free version interface to PureBasic?
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.
- the.weavster
- Addict
- Posts: 1537
- Joined: Thu Jul 03, 2003 6:53 pm
- Location: England
Re: Valentina Studio (Databases and Reports)
It has a command line interface:collectordave wrote:How does the free version interface to PureBasic?
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.
Re: Valentina Studio (Databases and Reports)
@the.weavster:
I get a security warning 'NET::ERR_CERT_INVALID' for your site.
I get a security warning 'NET::ERR_CERT_INVALID' for your site.
Re: Valentina Studio (Databases and Reports)
Is it done using PureBasic ?
- the.weavster
- Addict
- Posts: 1537
- Joined: Thu Jul 03, 2003 6:53 pm
- Location: England
Re: Valentina Studio (Databases and Reports)
C++ I think.Fred wrote:Is it done using PureBasic ?
Should this be in Off Topic not Announcements?
- the.weavster
- Addict
- Posts: 1537
- Joined: Thu Jul 03, 2003 6:53 pm
- Location: England
Re: Valentina Studio (Databases and Reports)
I've edited the URLs so they're now http not httpsDanilo wrote:@the.weavster:
I get a security warning 'NET::ERR_CERT_INVALID' for your site.
Re: Valentina Studio (Databases and Reports)
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.