Vanilla v4 (Post 1 on 10) – FreeWebReport

Dear Readers,

Let’s start this 10-posts sequence by talking about FreeWebReport/Wysiwyg experience, that complement the FreeWebReport/Wizard and FreeWebReport/Explorer modules, that make FreeWebReport the most comprehensive and most playable interface in the WebReporting area.

As usual, FreeWebReport makes intensive usage of FreeMetadata secured documents as data source. Its complete Wysiwyg interface allows user to design complexes reports, but also open/modify already existing reports. See below some screenshot and access to videos for FreeWebReport/Wysigyw features, its better than thousand lines of post.

This interface provide you with Design and Preview panel, and with preview when designing each components. Different Datasets can be created, based on different Metadata (!!!!! … !!!!!!!), and you can decide whether or not the dataset are linked (!!!!! … !!!!!!!)

FreeWebReport – Chart Designer, using FreeMetadata document

FreeWebReport – Chard & List in same report

Some usefull videos

Vanilla4 – FreeWebReport Wysiwyg – simple list, list with group, dynamic expand of group/detail, interactive filter on data

Vanilla4 – FreeWebReport Wysiwyg – simple list & graph group, dynamic expand of group/detail

Vanilla4 – FreeWebReport Wysiwyg – CrossTab Report & Graph

Vanilla4 – FreeWebReport Wysiwyg – Using Templates to create reports (3 examples)

Have Fun !


Vanilla v3 (post 7 on 10) – FreeWebReport

Dear Readers,

With Vanilla v3, we provide power users with an enhanced version of FreeWebReport, that support – in short – muti datasource (Metadata document), multi data set (dataset beeing link or not, based on context),  a new set of layout (that is close from what is available in FreeDashboard) and additional graph & calculation formula.

With those new features, FreeWebReport leverage the Birt engine & Birt Xml definition used to produce the report (Birt is also based on a multi datasource/dataset, and FwReport set of functions is Birt alike). In addition, every report created by FreeWebReport can be open by a Birt java studio (for additional layout arrangement, such as pixel perfect column definition)

My personal opinion is that the last thing missing to FreeWebReport is a real Wysiwyg Web interface that could be provided in parallel to the easy-to-use Wizard, along with support of additional type of graphs … that’s why we will continue to provide new release of the module …

New layout management : basic report definition

Multimetadata support for datasources

Join Dataset Definition in FreeWebReport

Graph Definition

Calculated column : Formula Definition

Result in Vanilla portal

Your comments are welcome !

Have Fun !


Innovative module : FreeWebReport / Explorer

Dear Reader,

In our roadmap, there was an open feature for months : beeing abble to leverage the power of our Metadata documents with a Web reporting interface, to allow power users to browse a metadata document by drilling from objects to other details objects (passing context)

Thanks to Vanilla dev team, this feature – similar to Olap drill in FreeAnalysis – is now available in Vanilla 2.2 (using a FreeMetadata document that map a Sql database). You can find a simple video to introduce FWR/Explorer module.

Technically, exploration is based on secure metadata document (dataset security by group, dynamic column content management … ), meaning no Sql knwolegde is required. We have embed a Flash visualisation of relation between component :

Flash visualisation of Metadata document

Visual interface to see relation between objects

Views on Metadata document can be saved in Vanilla repository for later reuse, and there is a direct connexion with FWR/Report creation interface to arrange visual layout and saved a predefined report.

For basic features of FreeWebReport / Report creation, I have also published another simple video.

Have Fun !