Valentina Reports now support ODBC datasource!
This is great, because now Valentina Reports can work with data stored practically in any database format (MS Access, MS SQL, Oracle, Postgre SQL, mySQL, … ) and even XML.
In Valentina Studio improved datasource dialog to support ODBC.
In a Valentina ADK code, you should specify connection string in the VProject.MakeNewReport( inDataSource ), as the following: odbc://dsn=access,user=name,pass=123
Will be available in the 4.9b5 build or newer.
On users request we have made the next major improvements in Valentina Reports:
You can see details on the following pictures.
Continue reading [VReports][NEW] Improved HTML, Picture Controls
We have upload 2 new video lessons about Valentina reports:
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:vspro:vspro
We are happy to introduce, in the release 4.5, the result of our 8 months efforts – Valentina Server 64 bit for 3 platforms (win, mac, linux)!
Paradigma Software Inc announces a special holiday offer for professional database application developers. All sales of new or upgrades through Paradigma Software of ValentinaADK or Valentina Developer Network includes the associated Valentina Reports module free – up to a $1500 savings on Valentina Developer Network!
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:vspro:vspro
Here you can find new and improved video tutorials:
* Preview Overview
* SubReports
* Formatting
* Expression Field
New lessons now come in two languages English and Russian.
You can use this control to force page break for a report.
These buttons allow you easy import local project to a remote Valentina Server, and visa versa – remote project to local HDD.
Idea is simple: you choose local project, then vstudio create on a selected VSERVER a new project, and execute INSERTs record by record from your local project’s table. As result, you get on the VSERVER a new project with all the same items, which already registered and ready for use.
This is a very important feature for reports. And we have implement it using the same internal engine as the Valentina SQL format() function.
You can read Valentina WIKI: http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#format
For any output field you can specify in the inspector its pattern and kind of pattern (number, currency, …).
This feature allows you to specify for a selected item different styles of formatting (bold,color, …) depending on condition, for example, if f1 > 0 color is black, else it is red and bold.
You can use any valid Valentina SQL expression in the condition.
This option allows you make sure that if there is no enough space at bottom of page then group header is printed on the next page with its records.
You can now copy style from one element of report to another using tool bar button.
Igor have implement ORDER of items feature.
This allows you to have two or more overlapped objects and control their order of draw using commands
* Send To Back
* Send To Front
You can find these commands as buttons in the Toolbar, as menu commands and as keyboard shortcuts.
Igor has improve the appearance of Report Editor’s toolbar. Now it have groups to easy switch between different sets of actions and see buttons only for that actions. This also allows to add into the same space much more toolbar’s buttons.
Added more toolbar buttons and commands to edit layout of a report.
During last month, Igor did an incredible job to speed up Valentina reports in different areas x10, x2, x2 times …