Thanks to new SHOW PROCEDURES ALL, we was able implement Function Browser in the SQL Editor of Valentina Studio.
This Function Browser contains a list of system function and used defined stored procedures and functions listed by categories such as:
Continue reading NEW Function Browser in the SQL Editor of VStudio!
We have added the left side bar into Schema Editor.
It looks similar to what have OS X Finder and Windows 7. This sidebar allows you easy jump to the most common and/or recent places of your job. For example, you can by single click open recent database or connection or your bookmark to a Valentina Server. Your login and password can be stored, so no need to retype them each time.
Continue reading NEW Left Side Bar in Schema Editor of Valentina Studio
We have added to SQL Editor of Valentina Studio great new feature: now you can get much more rich output from an SQL command. And this output is separated into 4 tab panels at bottom of Editor.
Continue reading NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune
We have upload 2 new video lessons about Valentina reports:
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:vspro:vspro
New Video lessons added:
1) VStudio -> Import via ODBC datasource.
2) VStudio Pro -> Reports -> Grouping
3) VStudio Pro -> Reports -> Controls -> Picture Field
4) VStudio Pro -> Reports -> Regions -> Report Header
We have add 2 news video tutorials EN. One for MAC and one for WIN about how to setup ODBC datasource around Valentina ODBC driver.
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:video
These lessons can be helpful to setup ODBC data source for other dbs also, e.g. MySQL or MS Access, if you want import from then into Valentina using
Valentina Studio ODBC data import.
And lesson about this import from ODBC is our next lesson, which is in the work.
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.