Valentina Studio Pro – Page 19 – Paradigma Software Blog

4 NEW Video-tutorials for VStudio and Reports.

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

Two new Video Tutorials about ODBC datasource setup.

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.

3 New Video Tutorials added to VStudio PRO about Reports.

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.

Report Editor get new control – Page Break

You can use this control to force page break for a report.

Project window have new “Import Local/Remote Project” buttons

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.

Report Editor get powerful formatting by pattern

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, …).

Report Editor get feature Conditional Formatting

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.

Report Editor get “keep together” option for Group Header

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.

Report Editor get Copy Style feature

You can now copy style from one element of report to another using tool bar button.

Report Editor now supports ORDER of items.

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.

Report Editor More Beautiful, Powerful

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.

Valentina Reports – Faster, Faster…and Faster!

During last month, Igor did an incredible job to speed up Valentina reports in different areas x10, x2, x2 times …

Now faster PREVIEW of reports in the Report Editor of VStudio Pro
Now faster drawing of report layouts in the Report Editor
Now faster generation of PDFs

Report Control Picture now have property to specify picture by URL/path.

As result you can show in a report not only picture from DB, but from disk or by any URL.

Reports on linux now much faster (10+ times)!

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.