Viewpoint

June 2017

Version: 10.17.163

Fixes

• The Excel Add-in in version 10.17.104 of Viewpoint did not work with spreadsheets created with earlier versions of Viewpoint.
• View Designer could end in error when editing some GROUP BY views.
• View Designer was not correctly omitting literals and constants from GROUP BY Clause.

April 2017

Version: 10.17.104

The following Enhancements are included in this version:

• Dashboards now have a setting for Default Font.
• The Viewpoint log now includes the date and time in the filename like so: VPlog_02242017_113011.txt. Files older than 7 days will automatically be deleted.
• New command line switch added to allow logging to be turned on without the warning message to the user /z:q

The following Updates are included in this version:

• View Designer (with server connection of remote—not *LOCALSYS or *SEQUEL) displays error ‘SQ9999 Error occurred in SQL Call Level Interface’ when switching to the Files & Fields and there is an alias field used mixed as “SumLval70”.
• View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) removed the GROUP BY clause when switching to the Files & Field tab and view contained a WDATA on the SELECT clause.
• In View Designer Files & Fields tab (for *LOCALSYS views only) derived fields that result in a DATE data type will now apply a type of DATE in the TYPE field.
• In View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) the Expression Editor to build the WHERE clause should use the AltName of an expression, not the expression itself.
• In a *LOCALSYS view, when building conditions in the WHERE clause Expression Editor, file identifiers are included when you select fields from files and not variable names.
• Opening a view in View Builder when files are not library qualified on FROM clause displays error 'A library is required for selection'.
• Application open in design will now detect any changes made to the view.
• Temporary files created by the Viewpoint OLE DB Provider will now be deleted.
• Emailing IBM i joblog from Viewpoint when there is a single apostrophe in the message text, failed to deliver email.
• When saving a client report over a view with either a numeric or an expression type variable (with no default value), will return an error that the value is not a valid numeric value for the numeric variable, or a syntax error for the expression type variable.
• Running a dashboard from a Viewpoint shortcut (.vpt) multiple times could produce a ‘runtime automation’ error message. Problem introduced in VP 11.16.294.
• Viewpoint is buffering data from a view when run in a dashboard, even though charts are designed beyond the initial records.
• The ability to provide custom edit masks on 7 segment digital gauges has been restored and improved by extending the supported mask from 6 characters to 20 characters.
• In Dashboard designer, resizing gauges very often causes the gauge to shrink or disappear.
• Running a client report from a script using the REPORT command to email displays the error MCH1210 ‘Receiver value too small to hold result’.
• Saving a client report when the view had an Expression (EXPR) variable, without a Default Value, would fail.
• In the Script Designer on Windows 10, prompting a second command did not show the command prompter, but the log showed the error ‘there was a problem with DLL: cwbunapi.dll’.
• From the Excel Add-in, Refresh All was not working with two views from two different hosts.
• From the Excel Add-in, when refreshing data if a prompted view returns no records, the current data is not blanked out.
• From the Excel Add-in, when refreshing all variables, even if from different views, will combine into one prompt.
• Dynamic Drill Down and Show Details option display syntax errors when the view used WDATA.
• Viewpoint Administrator will now all you to delete a remote server entry.
• A .vpt shortcut to create PC file without /D switch should prompt for path information.
• The Import > Query option will now use the SERVER and SYNTAX settings from the User’s defaults.

October 2016

Version: 10.16.294

The following enhancements are included in this version:

• Text size on many objects (views, host table, client tables, Client Reports, Scripts, Script Views, and Applications) was increased from 50 to 128 characters.
• View Builder and View Designer will support ‘Fetch First’ with a *LOCALSYS or *LOCAL connection and *SERVER syntax.
• Allow library name to be specified when saving Viewpoint object to Repository.
• In the Script Designer Variable tab, grid columns will match the view designer to make more readable.
• Excel Add-in now supports 64 bit Excel.

• The 2 dimensional chart options were added to menu dropdown.
• Copy/Paste actions added for Gauges, text boxes, action button and graphics.
• New option for Web Preview to see an HTML preview.
• Snap to grid for easy alignment of text, action button, and result windows.

The following updates are included in this version:

• In Administrator, the copy defaults option was using the default user—not the selected user.
• From Administrator, Set Defaults option, copying a current user defaults to a new user profile causes a
• View Builder and View Designer give error that file cannot be found when the datasource is another *ISERIES connection.
• View Builder did not allow creation of multiple derived fields.
• In Warehouse Builder from ViewPoint Explorer, caused error due to parameters not being passed.
• Script View run in Viewpoint Explorer runs the body of the script twice.
• Prompted Script that runs from a Viewpoint shortcut results in the following error MCH1202 unmonitored by VPTJMSG at Statement *N, instruction X'0011'.
• Option to schedule an email as PDF failed when using the IBM Job Scheduler.
• Email request from Viewpoint as PDF ends abnormally, error in print command, when host version is less than R11M04 (for Sequel) or R10M04 (for Showcase).
• From View Designer, file in FROM clause specified with *LIBL does not send message when library is not on the library list of Viewpoint job.
• From the View Designer Files & Fields tab, when designing a DATABASE(*LOCALSYS) SYNTAX(*SEQUEL) View, use of EDTCDE(L) on a numeric field will be dropped when moving to/from the Files and Fields tab.
• View Designer should omit literals and constants from GROUP BY Clause.
• View Designer not handling French à character in FILE names with SERVER(*SEQUEL)
• From the View Designer, displaying view result after stepping in to a SELECT statement of a UNION view causes and unwanted ORDER BY to be added to the full SQL Statement.
• Once a DISPLAY returns no records, the script ends without running the remaining steps.
• When a user has assistance level set to 1 or 2 and View Builder is enabled, the setting renders the CRO (User based license) design window in a small frame and it cannot be resized.
• When two DATE variables used a default value and the second variable was *NOPROMPT, the first variable used the wrong default value.
• Unable to enter date of 12/31/9999 in date variable when run in ViewPoint.
• Dynamic Drill Down (Regroup or Show Details) fails with a *LOCALSYS view with file qualified fields.
• Creating a shortcut from a view display that also includes a chart produces a .vptchart file type instead of .vpt.
• Expression Editor better handles field names with double quotes.
• Subtotals in view results did not show if the ORDER BY fields used a field with an alias name.

• A dashboard with an Action Button set to Autorun fails to run a prompted object successfully when the variable is passed using /SETVAR.
• Chart title should be consistent at design time and run time.
• When the Dynamic Drill Down List file (SEQUEL/VPTDYNFLTR) contains a list of fields, only those fields are available for dynamic drilldown. If the file contains fields, but no fields that exist in the files that a grouping view references, then the option to view the complete list should appear in SWI, as it does in ViewPoint and SWS.
• Reprompting from a dashboard with a graph for new choice and receiving less records, produces an Overflow error.
• Digital gauge custom mask entries, like a $ sign, don’t display correctly.
• Inserting a view that returned no records cause the Designer to hang.
• Variable prompt windows often show behind the dashboard and cannot be seen.
• After adding chart, right click for Properties caused Properties window to come up behind designer window.

April 2016

Version: 10.16.098

The following updates are included in this version:

• From the ViewPoint Explorer, clicking on an object and cut, the paste action gives error CPD0043 ‘Keyword OBJTYPE not valid for this command’.
• From Script Designer, unable to save a script if changes were made after saving it
• If a Client Table is opened for design, but the only changes made are in the Group Footer Editor, the warning message "Do you want to save changes to this Client Table" was not issued.
• Using *SERVER syntax with a Grouping view with expressions for columns, Drill-Down/Show Details creates invalid SQL syntax.
• Runtime SQL conversion when using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) will convert inner join to WHERE condition with an additional pair of parentheses.
• Runtime SQL conversion when using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) failed when a UDF name is schema qaulified (i.e. select sequel.valid_date(2150101,''*CYMD'')).
• VALID_DATE function loops in rare circumstances.
• ViewPoint option for Field Sorting will now default to position, not alphabetic, for new installs.
• Import Query/400 option will now default to a view, not a report.
• Creating a Host Table over a view using the ViewPoint Universal Driver (JDE or *ADS connection) caused an error.
• From View Designer Files & Field tab, removing any files except the last file caused ViewPoint to hang.
• Application Builder can now create drill to option for Client Reports.
• Silent Install now supports the Excel Add-in install.
• Dashboard Action Button to Email View Results was not sending view text for subject line for PDF attachments.
• ViewPoint is unable to save view containing a WITH predicate.
• From the Variables tab of View Builder or View Designer, in the Integrity Test for DBLIST, the ‘View List’ button di not return records when the view name was specified.
• The Expression Editor of both View Builder and View Designer now has multiple entries for the DATE function.

• Default background color changed to white.
• Default font changed to Verdana size 11 for text and Verdana size 9 for Action Buttons.
• Default chart colors changed to 128 Pastels.
• After bringing a chart to the front or back, it will now be sizable.
• Text in text boxes will now be centered.
• Gauge using the COUNT function that returns a single record with now work correctly.
• Gauges did not work correctly when PC region setting did not match IBM I setting.
• Background image size changes on mouse click.
• When closing a dashboard using the X, the save option will now give you option to save as pc object as well as IBM i object.
• If a chart is built over a Client Table, the hide data option will work.

• Able to add View columns to non-contiguous columns in Excel therefore allowing blank columns in the spreadsheet.
• Spreadsheet containing a view with a name that contains a special character (such as @), did not have the add-in available.
• Add-in would freeze if using a prompted view, choose Refresh, Click Cancel on prompt window, and close the spreadsheet.
• Choosing View References and then columns causes error Cannot find column[viewname] Line 0 in some instances.
• Using a view with hidden columns (WDATA) showed incorrect fields in Choosing Columns list.
• View that returns one record will not refresh when the second requests has more than one record.
• On the 22nd refresh, the add-in would hang.
• Extendable area not automatically resizing when a prompted view is used.
• When the view contained a grand total and a calculation was added to the extendable area that is a percent of total, when the refresh returned different amounts of data, the calculated field was wrong.
• Improved control on Column Selection window.
• The Add-in will now use brings data into the spreadsheet, columns should be formatted as specified in the view.
• Add-in is now supported for Excel 2016 32-bit.
• System Default will use Default Sever from ViewPoint Options.

• The Files tab will use the ViewPoint Options to include or exclude logical files in the list.
• Creating a new view with SYNTAX(*SERVER) with a left outer join corrupts the SQL statements and causes ViewPoint to hang.
• View Builder will now use the ViewPoint option for Field Sorting on the Field tab.
• The File tab will now have *FAVORITES in the Group pull down to use the favorite list of files from ViewPoint Options.
• View Builder hung on the Join tab when the same file was added more than once.
• Sort tab will now show list of fields when SELECT * is used.
• Sort tab now allows properties for Ascending or Descending and Absolute value sorting.
• The Field tab will now use the ViewPoint option for Field Sorting.
• On the File tab, resequencing the files did not actually change their order on the FROM clause.
• On the Field tab * for all fields is now removed when fields are selected.
• Expression Editor of Filter tab now has a third combo box for field comparisons.
• File tab will provide Member list for multiple member files when using SYNTAX(*SEQUEL).
• Filter tab will now support derived fields when using SERVER(*LOCALSYS).

The following enhancements are included in this version:

• The Auto-join process has been updated to support views with SYNTAX(*SERVER) when the join criteria appears on the WHERE clause.
• The Edit User Library list option and be restricted by setting Allow Command Line to No in the user defaults.
• Dynamic Drill Down (details and regroup) is now supported with a datasource of *EXCEL or *ACCESS.

November 2015

Version: 10.15.317

The following enhancements are included in this version:

• Silent Install now supports modular switches to control installation of Client Report, Administrator, and Excel Plug-in.
• In the email to download the Client Table Viewer, the link was updated.
• New Excel Plug-in with the following:
  • Extendable area to allow Excel calculations based on dynamic data
  • Field/Column selection
  • Limit and modify number of row returned
  • Add multiple views to the same sheet
  • Add multiple views to different sheets
  • Selectively re-prompt or re-prompt all
  • Jump function to move easily through the spreadsheet to any extendible area or view

May 2015

Version: 10.15.167

The following updates are included in this version:

• On a French language PC, from the results of a view or host table, the option for Format Layout gave an unstable error.
• On PC with language settings that use the comma instead of the decimal point, opening ViewPoint gave an unstable warning message.
• View Builder was removing the WHERE clause if it contained a NULL comparison.
• In View Builder, creating a CVTDATE expression erroneously assigned an edit code M.
• In View Builder, the File drop down list did not render a list based on the file name filter if you keyed in a library name first.
• Editing the User Defaults using a drop list to the set one of the library values cause the user defaults to become corrupt and would cause errors about invalid parameter values.
• View Builder Fields Tab, creating expressions without assigning a name results in the builder creating invalid names, such as 1 & 12.
• View Builder Fields Tab, editing a field creating an expression, if you choose Cancel the original field is deleted. If you choose Done to finish, the field/expression is moved to the bottom of the field list.
• From view or host table results, selecting Format\Layout on a French language PC caused a runtime error.
• ViewPoint not handling French accent character in library names.
• Decimal conversion error on product version when opening ViewPoint when PC setting used decimal instead of period like on a French language PC.
• From the embedded Client Report designer, Display Results failed if report is built over a prompted Script View.
• In View Builder, selecting a field and choosing the Edit (Pencil) button, then clicking on the Editor button, if you click Cancel at this point, the field is no longer being deleted from the list.
• In View Builder when creating an expression, if you click on Done before entering in an alternate name, you now get a message that requires you to enter in a name before completing.
• Improved message handling in View Designer when the SQL statement is not valid before re-entry into View Builder allowed.
• Improved message handling in View Designer assistance level 3, when entering View Builder with a blank SQL statement.

 

Back to Product Index

 

Copyright © HelpSystems, LLC.
All trademarks and registered trademarks are the property of their respective owners.
Last Published: 201709261131