Blue World Communications Inc. has shipped Lasso Reporter 6, a new tool for creating reports from data contained within MySQL databases. It can be freely used on servers running Lasso Professional 6, the company’s Web application server for creative professionals.
Multiple users can login to create and securely view their own private reports, along with reports shared with others. Reports contain a header, footer and body area where data can be summarized, sorted and calculated by individual groups or by the total found set.
An unlimited number of custom report formats can be created and stored with Lasso Reporter. The content of reports changes dynamically with each report run as data within the found set changes. And reports can be exported for additional processing in other applications or printed from within Lasso Reporter.
Each report can be based on a found set of records established via multiple queries on several database fields, each controlled by a full collection of query operators and logical comparison operators. The query criteria can also be displayed in the report.
The found set from compound queries can be grouped and sorted in ascending and descending order. Grouped field summaries can be displayed by themselves or along with all records within each group.
With Lasso Reporter, there are several built-in date range options designed to speed the specification of precise date ranges. Date ranges for reports may be displayed within the header or footer of the report. Also, the preferred display format for dates and currency can be customized.
Lasso Reporter requires a single-user or multi-user version of Lasso Professional 6, which includes a built-in Lasso MySQL database from which reports may be derived. Reports can also be created based on data contained within any external MySQL databases. Details, more pricing info, and an online live demo of Lasso Reporter can be found at the Blue World Web site.