Thursday, June 21, 2012

NextReports Server: Queries

NextReports Server manages reports and charts. Both are created upon an sql query which was not seen anywhere on the server. The only thing users could see was the list of parameters values used to run a query.

Version 5.3 of server will bring more information regarding sql queries. First, in monitor a new column Query will be added:
By clicking it, the full query (with all parameters replaced by the actual run values) will be seen:

In Info actions for report and chart, users will see also the query:

Search actions for report or chart will bring a new entry "Sql Contains" which will look for all entities whose sql queries contain the entered text:

It is possible now to search for a special column or table (for example) used in our reports, identifying very fast what reports may be affected by column or table name changes.

Wednesday, June 20, 2012

NextReports Designer: your home, your data

NextReports Designer contains internally a lot of user data:
  • config files which can be modified from UI like settings, servers
  • demo data base
  • generated logs
  • all created queries, reports, charts
  • all generated files through export / preview actions
  • report and chart templates
  • data sources and schemes definitions
  • workspace files
Till version 5.3 all this data is kept inside installation folder. This has a few drawbacks:
  • If you install designer as an administrator and you want to use it as a regular user you must have write rights in installation directory
  • Two or more users on same computer can see all data and cannot work concurrently
Starting from version 5.3, user data will be kept inside user home. When a user starts NextReports Designer, inside its user home a new folder called .nextreports-<version> will be created.

There are some things you must be aware of.

When you import from an older version, you must select the user data folder, meaning:
  •  old installation folder for version < 5.3 or  
  • .nextreports-<version> folder for version >= 5.3
NextReports protocol (used by server's edit in designer feature) is installed in registry in HKEY_LOCAL_MACHINE instead of HKEY_CURRENT_USER, to be used by all users from same machine.

Because there are more users which can work on the same designer, from version 5.3 more instances are allowed. Previous versions allowed only for one instance of NextReports Designer.