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)!
Category: Valentina Reports
Valentina Reports Free in December 2009
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!
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.
MakeNewReport(index, db, query = NULL, …); Query now can be NULL on default.
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.
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.