InVision 2.6.1 released!

InVision 2.6.1 introduces 23 new features and enhancements. The most interesting new feature in this release is probably the support for macros in SQL Reports and SQL Scripts. Macros enables you to use C# to dynamically generate SQL queries at runtime, before they are executed. You no longer need to concat a string using SQL and then execute it using sp_executesql. For details about how to use macros, you should read this blog post, which goes into details on the subject.

Read more

Macros in InVision

Macros can be used in Reports and SQL Scripts to dynamically create and execute SQL queries at runtime without using SQL string concatenation to construct them and sp_executesql for execution. Macros are written in C#, which offers great flexibility for creating both simple and very complex macros.

Read more

InVision 2.6 Released

Hello world! The focus for version 2.6 has been about improving filtering capabilities and adding support Form Schemas, which provides a new way to build complex data entry forms.

Form Schemas enable you to quickly create complex data entry forms. While it is possible to create forms in previous versions of InVision, it is inflexible and too time consuming because each Form Element is an isolated entity with its own load, save and validation logic. With Form Schemas, you can create complex forms with automatic data persistence, validation, custom calculations and business logic, styling and layout. Form Schemas are displayed in Workbooks, and have actions and events like all other Workbook component.

Read more

InVision 2.5.0 Released

In addition to a number of new features and enhancements, the most important change in 2.5 is a change we’ve made to the core component of the system which handles the identity of the data rows in the database. When upgrading an existing instance, the installer will automatically do all the necessary steps, but it is very important that you back up the Solution database before upgrading in case an error occurs (network, disk, etc).

Read more

InVision 2.4.1 Released

This is mostly a service release with enhancements to existing features and fixes for a number of issues. We’re focusing most of our time and resources on the new desktop designer, but we’ll continue to provide regular releases to fix important issues and add highly requested features.

Read more

InVision 2.4.0 Released

With version 2.4, we’re introducting version 0.1 of the new InVision Desktop Designer that lets you develop Web Functions and customize the Home Page Layout without editing the deployed .cshtml-file. We will gradually port (and improve) every feature from the SL designer to the new desktop designer, but for the time being, you’ll have to use both tools to develop InVision solutions.  All significant new platform features will be added to the desktop designer, while the SL designer will only be getting minor enhancements and bug fixes.

NOTE! If you are upgrading to 2.4 from a previous version, you need to update Profitbase Installation Manager to the latest version (1.3.1.0) first.

Read more

InVision 2.3.0 Released

A new release of InVision is ready, and it contains some new very useful features and enhancements. Check them out below.

The most powerful new feature added this time is probably the ability to easily embed custom JavaScript computation libraries that can be used in spreadsheet formulas, where each spreadsheet gets its own compute instance. This enables you to write very advanced calculations for spreadsheets.

Read more

InVision 2.2.2 Released!

“From all of us, to all of you, a merrInVision christmas!” The December release is here with some new features and improvements. Some key features this time is Export to Excel, improved rendering of filters based on jagged dimensions, and that new members can be added to Workflow State Context Objects during a Workflow without requiring a restart.

Read more

InVision 2.2.1 Released

Another week, another release! 2.2.1 contains a few new cool and highly requested features, namely Template Columns for Worksheets and Reports, and the support for specifying both a Display Member and Value Member in spreadsheet Drop Down columns. 2.2.1 also contains a few very important bug fixes, which is described at the end of this post.

Read more