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 …
As result you can show in a report not only picture from DB, but from disk or by any URL.
MakeNewReport(
inIndex as integer,
inDatabase as VDatabase,
inQuery as String = NULL,
inCursorLocation as EVCursorLocation = kClientSide,
inLockType as EVLockType = kReadOnly,
inCursorDirection as EVCursorDirection = kForwardOnly ) as VReport
Starting from 4.1 parameter inQuery can be NULL. In this case will be used original query around which was designed report, i.e. query stored inside of project.
This simplify development because there is no need to copy/paste query 2 times. In the same time you still can specify different query: e.g. with different WHERE statement.
Igor have made great job improving speed of reports generation on linux, which uses the FreeType library (instead of wxWidgets+OS like on WIN/MAC). As result, time of report of one developer go down from 3 second to 0.3.
Actually FreeType library can be used on MAC and WIN. Just no big sense because it was much slower.
Now we see sense to enable TWO render-engines on MAC/WIN and be able switch them runtime. This will be useful for building of automated test-system for reports.