v6.9.5.0

Matthew Fifield -

Release Date: 01/30/2017

 

Changes

Linking

The linking process as a whole was completely reworked for better performance and stability.  

  • New Join type "FULL"
  • Users can now change the Alias of a table (This includes the way the linking statement is being built to use an Alias)
  • New Table Creation process that does not run when opening a view.  This greatly reduces the amount of time that is used when opening a view.  The tables are rendered only when going to the linking tab.
  • The table order is no longer based on the visual aspect of where tables are located, but instead based off of the order in which they were linked.
  • Tables can now be added to a view even if none of their fields are used.  This means that views can be altered by table links without adding unwanted fields.
  • The same table can now be added multiple times to be linked back to itself.
  • Historical linking now saves specific links instead of full sets of tables.  This allows for tables to be automatically linked as they're added to the view (if they've been linked before in other views).

**IMPORTANT**

Any Views that are opened and saved moving forward will not be compatible with older versions.  This is due to the new linking.  It is recommended that if one user updates to this version, all Users update to prevent any version conflicts.

 

Parameters

Parameters are no longer Automatically added to the view when adding filters with a statement such as ?Example?.  Parameters are now managed in the Parameters tab where they can be added and removed.

  • Parameters settings are now no longer lost when a filter statement containing a parameter was removed/updated.
  • Parameters can be disabled so that they're not prompted at runtime, but can be re-enabled later without losing the Parameter's properties.
  • New Property called Variable Filter.  This property enables this parameter to use a Variable filter (explained in more detail below).
  • There is no longer a difference between a Finished Report Parameter, or View Parameter.  All parameters are managed from the Parameters Tab.

 

Variable Filters *NEW*

Variable filters are a powerful new tool that allows users to completely modify the statement that is being sent to the database via parameter.

Variable filters are used in unison with a parameter that has the property "Variable Filter" enabled.  To use a Variable filter, the user would create a parameter with a list of values (example: Statement1, Statement2, Statement3), with Variable Filter Enabled.  Then create three Variable filters and name them Statement1, Statement2, and Statement3.  Now, at runtime this parameter value will be replaced with the statement for the selected Variable Filter, effectively adjusting the entire filter statement based on a parameter.  Variable Filter statements can also contain Parameters.

 

 

 

Have more questions? Submit a request

Comments