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.
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.
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).
InVision 2.4.2 Released
Version 2.4.2 is a service release with a few fixes and enhancements. Nothing new and exciting, but we’re working on something…:)
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.
Export report/dashboard as an image
As of build 2762 of InFront 3.2 we have added an api endpoint to export a given report or dashboard as an image.
Custom report menu links
As of build 2762 of InFront 3.2 we support creating custom links behind the gear icon on every report. The functionality is configured by entering an anchor tag <a ….. />, or a plugin name e.g. <mycustomlink>, on the report property called “Menu custom HTML or plugins”. Example : The following value : <a href=”http://www.profitbase.com”>Profitbase … 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.
Profitbase Installation Manager v1.3.1.0
A new version of the Profitbase Installation Manager has been released. Noteable changes: – Support for InVision 2.4 – Fixed bug that caused a crash when uninstalling and then reinstalling InVision again, then selecting status. – Better logging behind the scenes. Anyone whos online should see a message box show up about updating to the … 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.