Viewpoint

November 2023

Version: 10.23.318

November 15, 2023

Enhancements

• Viewpoint has been modified to support TLS 1.2 connections to SWS when in running in Repository mode.

August 2023

Version: 10.23.223

August 15, 2023

Enhancements

• Alphabetic position-to search is now available in ViewPoint for prompted DBList variables on character fields.

• Viewpoint now supports TLS envruption protocols as well as SSL.

Fixes

• Fixed issue in Viewpoint Administrator option to display Active Sequel Users. The process was ending in error MCH1210.
• Migrating a Showcase query that contains only an upper case integrity rule fails.
• If custom paging was defined for a Client Report, it did not work correctly if a report section was suppressed or mimimized.
• Client Reports over prompted Host Tables will now save correctly.
• A fix was made to Viewpoint dashboard design to correctly assign the proper ORDER property to objects on the dashboard. This issue caused some controls such as Bring to Front and Send to Back to not display correctly in SWI.
• Error when loading or refreshing large view in Excel Add-in, “Microsoft Excel is waiting for another application to complete an OLE action” has been resolved.
• A dashboard with many Sequel objects set to refresh that is kept open for a long duration could encounter errors when refreshing the data.
• A fix was made to allow for variable column headings when using *SERVER syntax.
• Client reports created with user based Client Report License, and over embedded SQL statement renders a blank screen when opening for design.
• Remote Database connection on V7R5 fails due to incorrect Java path.
• Corrected issue with variable column headings when using Database of *LOCALSYS and Syntax of *SERVER. Dynamic column headings will now display in Viewpoint.
• JDE prompted view not added to Excel worksheet.
• ViewPoint installer now correctly identifies whether the Excel Addin is installed already and will automatically upgrade it.
• Unable to display view properties if variable default value contains SQL that returns no results if not prompted.
• Viewpoint could become unstable if Page Setup was changed to Landscape.
• Error when selecting blank for prompted variable in ViewPoint, SWI or SWS Host Mode.

December 2022

Version: 10.22.314

December 5, 2022

Fixes

• A fix was made to Viewpoint dashboard design to correctly assign the proper ORDER property to objects on the dashboard. This issue caused some controls such as Bring to Front and Send to Back to not display correctly in SWI.

• A fix was made that allows Viewpoint to connect to host using KERBEROS when set to use the default user.

September

Version: 10.22.244

September 13, 2022

Fixes

• The Java version shipped with Viewpoint has been updated from Java 1.7 to Java 1.8
• Changing Fonts in View Designer gave error 339 Component 'sysinfo.Ocx' and did not show window.
• In design of a RDB/*Server view, if a file name is incorrect VP will not allow you to go to the Variables tab. It has been fixed now and you still get a message that the file could not be found but it allows you to go to the Variable tab.
• Client Table over *LOCALSYS/*SEQUEL View with WDATA (hidden) fields fails to display gives error Cant open ADO recordset; column 'OHSTRE_01' is not found.
• A fix has been made to properly allow you to turn on and off the following options in a Host Report Design - View/Show Grid, View/Show Available Fields, and View/Show Field Names.
• An issue with the Viewpoint Listener Service was introduced in 11.21.361 that prevented the service from starting.
• In the 64-bit Excel Add-in, a defined expression variable value was not passed correctly, view returns no records.
• Corrected a rare condition where the 32-bit ViewPoint Addin was installed instead of the 64-bit Addin.
• Objects in a dashboard where there are some views/charts located to the right beyond main window cause the objects to open up out of position. Clicking on the visible objects would snap them back into place, but scrolling to the right most objects you had little control on moving the objects. This has been fixed.
• A fix was made to correct an issue where a gauge would reflect the wrong value when the dashboard refreshed the data. The gauge was based on the total of a column, and the view data was hidden.
• Dashboard with many Showcase objects set to refresh that is kept open for a long duration could case 'an error occurred while retrieving records' with an MCH0603 message on the host when no records were returned on a refresh.
• In Repository mode a when inserting a chart in a dashboard was blank if the view is in a repository subfolder.

January 2022

Version: 10.21.362

January 6, 2022

Updates

• Fixed issue where the 'Bring to Front' and 'Send to Back' options for objects in a dashboard were not saving with the dashboard.

• Fixed issuer where *SERVER syntax did not show custom column heading that used single quotes. For instance, /<S- COLHDG('Order' 'Entry' 'Date' )-S>/.

• Fixed issue where if a spreadsheet had spaces in its name, an error would display when doing a refresh (the addin was changing the space to an underscore).

• Fixed issue where a refresh in the Excel addin would loose any cell formatting such as centering of text, background shading, italicized, and cell bordering.

• Fixed Viewpoint Files & fields tab errors out when a join contains a between comparison.

• Added back the missing Series Order option for charts when designing in a dashboard.

• Fixed issue where if a spreadsheet was somehow corrupted and was missing the named ranges for a view, refreshing data caused a Ribbon Class Error (create range error). We added error handling when trying to get the named range. If an error occurs then fall back to using the range that should be in the add-in xml.

• Fixed issue where text settings such as font, italics, underline and strikethrough are not getting saved with the dashboard.

August 2021

Version: 10.21.214

August 23, 2021

Enhancements

• In dashboard design, snap to grid now allows a minimal pixel setting of 10.

• In a dashboard, system information is changeable in the Options menu.

• TRIM function will now show in Expression Editor lists.

• The joblog sent from a Viewpoint job will now include job name, number, user and date in the attachment named when emailed. The default type will use default output type as defined for type SPOOL in Esend for the user.

• Excel Add-in

  • Enable the ability to add specific columns from a view to a worksheet.

  • Improved performance loading views when using 64 bit Excel.

Fixes

• A fix was made that now will allow you to create a gauge over a single cell of data from a view that produces a single column of data.

• A fix was made for when adding an Action Button to run a view and save the results as a PC file, the save as Browse window would come up behind the dashboard and essentially freeze your process. It now displays in the front.

• Dashboards allows a chart or a gauge to be created over a view that displays a single cell of data

• Dashboard graph would not display, if the tool bar was left displayed when saving the dashboard.

• Opening View in View Designer or View Builder and making minor changes will not remove saved subtotals from view results

• Script Designer doesn't allow script to save using "DO" command when part of MONMSG command.

• Script COND comparison of two QSTRING with blanks not accurately comparing blank to blank. Blanks should not have to have the same number of blanks.

• Viewpoint Add-in for Excel field formatting not retained after refresh

• Display Results when the column headings caused width to exceed 2000 positions will now have message to indicate not all fields displayed.

• View Builder Variable Tab erroneously showed Allow Null with host version 11.13 or earlier and VP 11.20.260 or greater and views using SYNTAX(*SEQUEL).

• In Repository mode, a Script with DISPLAY command referring to view with description with .vptivew ended in error.

• A Script View using *LOCALSYS/*SERVER using DBLIST with character values and other variables with *ALL did not resolve the quotes correctly.

• Script Designer doing copy / paste with CTRL-C/CTRL-V does a double copy.

• In View Builder the Design Value from the Variables tab did not work to avoid the prompt at runtime from the designer.

• Repository Mode (CHGAUTMODE *REPOSITORY) should allow CRO reports initiated from a script for a host job to run on the Viewpoint Server.

• From Viewpoint running a view with TRIM using *LOCALSYS *SERVER gave 'column not found' error.

• In View Designer in Repository mode doing a File>Save As will now create a new *USRSPC object for the new .vptview if the user didn't have authority to the original view.

• In Repository Mode, view not saved correctly when open from Recent tab.

• Viewpoint changes the vptview name to lower case when opened from recent tab in Repository Mode.

• Copy/Paste from Viewpoint explorer (Host Mode) fails if system is not expanded

• In Repository Mode, Viewpoint Explorer option to Save Results As>IFS Folder did build path correctly and gave error.

• In SWS Repository Mode, designing a CRO report using Crystal 11 when the view doesn't return any records caused Viewpoint to errror 'Failed to load database information'.

• In SWS Repository Mode using CHGAUTMODE(*REPOSITORY) did not allow saving a CRO report.

• Excel Add-in

  • Excel Add-in in Repository mode gives error using Extended Help text on variable prompt.

November

Version: 10.20.260

November 16, 2020

Fixes

• Excel Add-in in Repository mode gives error using Extended Help text on variable prompt.

• View Designer alters JOIN when same file used more than once with *SEQUEL syntax.

• Repository Mode (CHGAUTMODE *REPOSITORY) should allow CRO reports initiated from a script for a host job to run on the Viewpoint Server.

June 2020

Version: 10.20.174

June 29, 2020

Enhancements

• Designing views with variables using *ALL/*OMIT is more user friendly and will only require checking the Null Variable box instead of specifying leading/trailing values to omit. This enhancement requires host version 11.14 (or 10.14 for Showcase) and applies to views using *SERVER syntax.

• The Viewpoint Explorer in Repository modes allows running and opening of other files like PDF and Excel spreadsheets (SQ-1937).

• The Client Report/Table tab from the Host Default Settings was moved to the Viewpoint Options.

• The Product Library Name from the Host Default Settings was moved to the Viewpoint Options.

• Dependency on ACTBAR has been removed.

Fixes

• Some Viewpoint Icons on buttons were oversized when using Windows 10.

• Viewpoint design error when using ADS: "RDB Name.Library Name.Table Name" cannot be found.

• From View Builder using an ADS connection the library list of the job was inadvertently changed when creating a second view in the same session.

• View Builder will handle views with NOT statement on WHERE, like WHERE not(custmast.CSTAT='A' AND custmast.CSTTE='CA').

• View Builder Sort tab now allows the selection of any field in the file, not just those on the SELECT clause.

• View Builder will not change the ORDER BY clause if fields are identified by number.

• CRO report with subreport showed sign on prompt.

• In Repository Mode, the File\Save As dialogue removed the file name when selecting a folder.

• When a numeric JDE field that supported variable precision (via the data dictionary) was used in a GROUP BY, an SQL error occurred. This has been corrected.

• Excel Add-in will now handle OPEN type fields.

• In the Excel Add-in numeric date fields with a defined edit code of W that should format the value as YYYY/MM/DD did not do it correctly. It used dashed instead like YYYY-MM-DD.

• VPTRMTCMD requests now support a /V command line switch in both lower and upper case.

April 2020

Version: 10.20.093

April 7, 2020

Fixes

• Improved visualization of the join relationships in the View Designer File & Field tab.

• The Excel Add-in supports views with *SERVER syntax.

March 2020

Version: 10.20.066

March 16, 2020

Fixes

• In View Designer using SYNTAX(*SEQUEL) when joining on derived field caused error opening existing view or creating a new one (problem introduced in xx.19.356).
• In View Builder, field descriptions and attributes added to Simple Join dialogue.
• View Designer using SYNTAX(*SERVER) was unable to handle spaces in the override tags, like for column headings.
• When copy/pasting SQL statements from Adobe Acrobat Reader, Adobe Reader stripped out some of the "-" characters. It converts "/* <S EDTCDE(" to "/* <SEDTCDE(" which is invalid to Viewpoint. This condition will be corrected.

January 2020

Version: 10.19.356

Fixes

• View Builder has improved handling of joins including:

  • Ability to use more than one pair of fields to join on.
  • Default join type changed to inner join.
  • Complex mode added to allow join on derived field in native syntax in an Expression Editor.
  • Cancel button added with warning message about saving changes.
  • Full Exception removed from list of join types.
  • File Edit button now works.
  • Using the same file twice will now work.

• View Builder with a non-*SEQUEL connections showed two alias columns instead of one for Name As.

• In View Designer using native syntax a join condition found on the WHERE clause will remain on the WHERE clause when going to Files & Fields tab.

• In View Designer, complex views that won’t open on the Files & Fields tab will now allow access to the Variables tab.

• View Designer drag/drop JOIN on multiple fields builds SQL inconsistently

• EXPR type variable with a value that is 1 character causes ViewPoint to not display results.

• View Designer WHERE Expression Editor in *LOCALSYS *SERVER gives error when using Variable ‘An error was encountered trying to update the SQL statement’.

• From View Designer, the WHERE clause dropped if CANCEL is clicked when using Expression Editor.

July 2019

Version 10.19.202

Enhancements

• The Script Designer has better message when there is an unmatched IF/DO and END and will not allow script to be saved in that state.
• In the Expression Editor using *SEQUEL syntax, the CONTAINS function was added.
• Incorporated new version of Newtonsoft JSON for improved compatibility with other products like Visual Studio.
• SQL Parser Improvements - Significant improvements to the SQL Parser to better handle native SQL including these specific examples:
  • Date Expressions using YEAR an MONTH on the WHERE clause are handled better.
  • Better handling expressions on GROUP BY clause.
  • WHERE clause with similar file correlation names in a sub-query.
  • View Builder views with multiple join types.
  • Quoted field names mixed with numeric Order By.
  • A Fetch First clause over 32,000 characters.
  • Expressions in the Group By clause and quoted field names.
• View Builder:
  • Join tab removed and consolodated to simplify the design process.
  • *Localsys *Server view, editing an expression to show as currency does not add the edit code to the SQL.
  • Removing a field from the SELECT clause did not remove it from other clauses like the GROUP BY or ORDER BY.
  • View with excessive parenthesis gave error "Filter Parentheses Not Correctly Balanced".
• Excel Plug-in:
  • In Repository Mode, the path for the view object will now support both upper and lower case letters. Previously only lower case was allowed.
  • Excel Add-id returns Ribbon Class Error (getRange2Shift) when many more records are returned than previously.
  • Cell formatting was reset when view data is refreshed when using an ADS connection (requires host).
  • When refreshing view(s) in Excel, if Automatic Calculation option is set to on, disable it for the refresh. Once complete it, enable it and force Calculate Now.

Fixes

• View Designer won’t change the ORDER BY to use field names when field number was specified. This is especially important when sorting by JDE UDC fields that require quotes.
• In View Design, a *SEQUEL view erroneously issues the error " Parser expected search condition" when the WHERE clause had a space between ‘IN’ and ‘(‘.
• In Administrator using Repository Mode, the Maintain Host Entries now has a Test Connection button.
• In Administrator, a local host entry for the IBM I can now be created using the same name for the server name entry for Iseries or DB2 type.

November 2018

Version 10.18.312

Enhancements

• Administrator option for Advanced Database Security now has additional options for ADS and JDE configuration.
• When setting query variables, if user is in the middle of editing the value or has not tabbed over or pressed enter to accept changes, buttons function(s) will be disable, plus user message will display.
• Excel Add-in now supports Set Query Variable which allows the variable to be set and then when refreshed will upate the variable in as many places as it is used in the spreadsheet.
• View Builder should allow searching for a file in *USRLIBL
• In Repository mode, added right-click option for the user to Create/Delete/Rename folder, as well as Copy and Paste folder(s).
• In Repository mode, added new button to the SaveAs form/screen to create new folder in the current repository when saving an object.
• Added ability to change repository name in the Excel Add-in References, if for any reason SWS server and/or name of the repository changed, preventing it from refreshing a view in a worksheet.
• Improve Templates for *SERVER syntax that allow variables, grouping functions and a back option.

Fixes

• Repository mode will now allow shortcuts with extensions in both upper and lower case (i.e. VPTVIEW and vptview) to run.
• In Repository mode when saving a Script or Application, the extension for the saved object will automatically be set.
• In Repository mode error at connection to Repository Error message CPF4101 appeared during OPEN for the file SWIUSERDFT.
• In Repository Mode deleting an object from the Explorer no longer requires a license for SWI.
• Repository mode when a user is not allowed to log in to the Repository, they should be prompted to enter new information.
• Repository mode will now remember the last used JDE Environment and Role.
• In Repository mode Save As on an existing view with uppercase letters in the original name has all lower case in the new name.
• In Repository mode, open a view in View Designer, Click the yellow "Open" folder icon just left of the "Save" icon. This opens a list of repository folders. Click cancel and you get Run-time error '0'
• Excel Add-in Canceling from a variable prompt gave: Object reference not set to an instance of an object .
• Excel Add-in improperly re-formats a field when it is character field that contains only numeric characters with 4 leading zeroes.
• Excel Add-in will now wrap column headings.
• Excel Add-in Repository mode ERROR: Ribbon ViewPoint - RunSelectedObj: Object reference not set to an instance of an object when adding extendable areas.
• Silent Installed failed on initial install.
• View Designer corrupting SQL statement when field name ends with _1.
• View Designer does not recognize the AS keyword in an SQL statement.
• View Designer corrupts SQL statement that references a quoted file name.
• In View Designer, Display option is grayed out if another option is chosen and then canceled.
• Script run from a shortcut or DOS command fails with -2147023170 Automation error The remote procedure call failed.
• Script Designer fails to run script and gives error CPD0018 Message String ' "DISPLAY ' contains a character that is not valid when Viewpoint is current and host software is very old.
• View Builder and View Designer improved to quote schema names with underscore characters.
• View Builder gives error ShowExtended Dialog, class not registered msstdfmt.dll when another dialogue box like Expression Editor is opened.
• In View Builder with an ADS or JDE connection, you could only delete the last field in the list regardless of which one was chosen.
• In View Builder edit drop down is disabled for Binary fields from SQLSERVER
• From View Builder and View Designer the Expression Editor had invalid date functions listed like SCSERVER10CYYDD.
• From Explorer focus of scrolling improved after keying in a library name, object list will scroll.

June 2018

Version 10.18.159

Enhancements

• In Repository mode the JDE connection will not be recycled if the Environment and Role have not been changed in Viewpoint repository mode. This will help in performance after the first connection to a server.�
• In Repository Mode, Import Query has been added.
• Improved performance for JDE JDE connections if the role and environment have not been changed in ViewPoint repository mode.
• From the view results, Export to Excel produces error 'Application-defined error' when fields used edit words.
• Improved message in Repository Mode when user excluded from IFS directory.

Fixes

• Logging in to SWS Repository Mode from the Excel Addin, user is prompted for the wrong repository.
• In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
• In Repository Mode, Dashboard designer will now allow a Script View to be used.
• Silent Install will check for locks and prevent the install from running if the product is in use.
• Opening a very large Warehouse Builder definition or script in Viewpoint results in an error CPD0074 Value 'EXECUTE SQ' for COMMAND exceeds 5000 characters.
• When view results are display, and "Close & Reprompt" is selected, the prompt screen should redisplay, and the variable values should default to those previously selected. Since updating to VP 11.18.046, if a DBList variable had a default value, and the view is run with that default value still present, when "Close & Reprompt" is selected, there will be no value displayed for that variable
• In Host Mode Dashboard designer, Save To the Repository was unavailable.
• In the View Designer using five or more files with the Viewpoint Universal Driver (JDE and ADS connections), Viewpoint wasn't building the joins correctly.
• In the View Designer, with a *Localsys/*Server view, if a specific length is specified on an expression, going to the F&F tab and making a change to the column heading removes the specified length from the SQL.
• In View Builder, choosing an expression column and then Edit brings the wrong column into the edit window when there are many fields and the expression is in the middle.
• In View Builder, choosing a file that is not in the specified Group of Favorites causes Runtime Error 0.
• In the Script Designer, a MONMSG command was mistakenly converted to SCMONMSG command.
• From the Script Designer, selecting a line in a script, then click on Edit/Delete produces Runtime Error 0.
• From Script Designer, creating a Script or Script View in Viewpoint Host mode and saving to repository fails.
• DBList on a variable shows all fields with name of RENAMED when fields have names longer than 10 characters.
• Designing a *Localsys/*Sequel view, when you hide a column (WDATA) the type and length are changed to the values of the following field. Un-hiding the length does not change back.
• Excel Add-in drops decimals with some zoned numeric fields. When the problem happens, the integer part to the left of the decimal is correct while the fractional part to the right of the decimal is dropped.

February 2018

Version 10.18.046

Enhancements

• Dashboard support added to Repository mode.

Fixes

• The Script Designer was changed to handle command strings greater than 2000 characters (Host version 10.10/11.10 also required).
• The install will now detect where the OS is Windows 10 and if .NET 3.5 is not installed/enabled and automatically enable it.
• Exporting view results to Excel produces error 'Application-defined error' if there are any numeric fields that have an edit word or an edits code that places non-numeric characters in the field (such as / or -).
• Gauges do not appear on a dashboard that also includes a website.
• Dashboard that consist of nothing but text and Action Buttons display nothing when launched.
• On the Files and Fields tab of the Viewpoint Designer, there is a "file" cell in the Fields Section that indicates what file the given field is selected from. That "file" cell is no longer editable, and will not show a dropdown list showing all files referenced in the view.
• Once CRO has been saved, attempts to do a Print Preview or Preview Sample end in error.
• In the View Designer, when clicking on the Files and Fields tab, User sees message box with yellow triangle alert with exclamation point, ‘Graphical Design Interface, There is a problem with the SQL and/or variables. Fix the SQL then try again.’ This error happens on a view using field sequence number from SELECT clause on the ORDER BY.
• In the Dashboard Designer when a hidden view that returns no records, saving the dashboard deletes all other Sequel objects.
• In repository mode should only show SWS data sources that the user has authority to use.
• The View Designer might hang when using SERVER(*LOCALSYS) SYNTAX(*SERVER) under these conditions:
  • The Order By used field numbers, not names, and the view contained variables.
  • Using the WHERE button to go to the Expression Editor.
  • Resorting columns on the Files & Fields tab.
  • Changing column headings or edit codes/words on the Files & Fields tab.
• In Repository Mode using Assistance Level 1, the Save Option on the Actions tab now brings you directly to save to the repository.
• The View Designer was changing a non-equal comparisons on the WHERE clause to an equal sign when using SERVER(*LOCALSYS) SYNTAX(*SERVER) as it was treating it as JOIN criteria.
• View Builder was adding CAST to grouping function unnecessarily and creating an invalid expression.
• In Repository mode, an error ‘The data source with key {0} does not exist’ would appear if the SWS connection timed out.
• Excel Add-in:
  • When refreshing data if the results set contains only a single row, if the number of columns in the worksheet doesn't equal the number of columns in the embedded view, and if there is an extendable data area defined.
  • When adding prompted view & unchecking “Refresh data” option on the Add View form – we get message “no records available”.
  • Opening the workbook when a column heading had a slash character(/) caused error, ‘Ribbon ViewPoint (Loading Data) Index was outside the bounds of the array.

December 2017

Version 10.17.348

Enhancements

• Applications now support using a Script View as the start object to easily allow a work file to be created for drill down purposes.
• From the Administrator Advanced Database Security window, there is now a setting under Options -> Default Object List with two choices: Expanded or Collapsed. Performance can be improved for very large lists by selecting Collapsed.
• View Builder Edit Filter with BETWEEN will name variables uniquely.

Fixes

• View Designer and View Builder in Repository mode will list the datasources rather than SEQUELHOST entries for server connections. Dependent on host version M09.
• The View Designer with SERVER(*LOCALSYS) and SYNTAX(*SERVER) was erroneously removing field to field comparisons on the WHERE clause like custmast.CSTTE<>custmast.DFTWH.
• View Designer was erroneously removing the DATE function from GROUP BY views when the derived field using MONTH, YEAR or other date function was also used on the GROUP BY clause using *LOCALSYS *SERVER.
• Views using Common Table Expressions did not run from repository mode.
• Shortcut created to email a Client Table or Client Report as Excel sent file with .txt file extension.
• Save existing CRO to repository with a different name modifies the current *USRSPC.
• Viewpoint Administration creation of host entries will copy Driver and Connection strings from corresponding type template.
• From Administrator, the creation of host entries will copy Driver and Connection strings from corresponding type template.
• From the properties of a host report, adding a jpg image to a pdf overlay gave error Run-time error '35600': Index out of bounds".
• When using Viewpoint to run a view with email recipient and specifying CSV format, some view names generate an email attachment with .txt suffix rather than .csv, so the file does not open in Excel.
• When emailing from Viewpoint, if the attachment file name was less than 12 characters the file was created in tmp and then cleaned up. Otherwise, file went to the home directory or to root and remained. Now all files will be created in tmp and cleaned up.
• The Google Map Wizard has been removed.
• Changes were made to enable Viewpoint to offer better support of Advanced Database Security when libraries and files reside on an independent auxiliary storage pool (iAsp).
• In Repository mode, improved error message when trying to refresh embedded views in an Excel worksheet when the repository hasn’t been defined.
• In Repository Mode, inability to open underlying View of .VPTREPORT (CRO Report) has been fixed.
• In Repository Mode, non-Administrator profiles will be able to retrieve a list of Datasources.

October 2017

Version 10.17.292

Enhancements

• Emailing from Viewpoint as PDF will now allow you to change to attachment name.
• Email dialogue window in Viewpoint will now provide a box for the email Subject.

Fixes

• Unable to create Client Report over view with a variable using a Values List Integrity test with no default value.
• ViewPoint won't include any select fields that don't have a field reference
• (literals/numbers) in the GROUP BY.
• With Auto Join turned on, after importing a query and adding additional files,no joins are established for the new files.
• From Client Table results, highlight any of the values or the entire column on the Total column on the right, click on the Graph option, and nothing happens.
• From the results of a prompted view, turn on subtotals. If you then choose to re-prompt the view, the values in the subtotal boxes were missing.
• From view results of a SERVER(*LOCALSYS) SYNTAX(*SEQUEL) view, Regrouping and show details will now include the file.field qualification to accommodate ambiguous field names.
• A view run in a script may use the default value rather than the value passed in the SETVAR when the view had a variable with a *ALL default value, an integrity test of a DBList or values list, and the presence of a *NOPROMPT variable.
• In Dynamic Drill Down, O type fields (DBCS) are not recognized as character so the values are not quoted which caused a syntax error.
• Dynamic Drill Down options will be not available for views with SERVER(*LOCALSYS) SYNTAX(*SEQUEL) that use WDATA function.
• In the Administrator>Database Security, the Select by Object became inactive when switching from tab to tab.
• From Viewpoint Explorer, when right clicking on a Host Report Display Results in PDF, no results are displayed.
• From the View Designer, after making any kind of change on the Files & Fields tab, if you click on the SQL tab, the group by clause was removed.
• View Builder will allow AltNames for derived fields that are longer than 10 characters, mixed case, and surrounded by quotes.
• In the View Designer Files & Fields tab, when the view uses the same file twice an error ‘column or global variable not found’ when any field attribute is changed because the correlation name was dropped.
• In the View Designer Files & Fields tab, when a view references greater than 10 files, and 1 is removed, the numeric file qualifiers were not adjusted properly.
• The WHERE Expression Editor in View Designer and View Builder will not include CONTAINS for views with SERVER(*Localsys) SYNTAX(*Server.
• In the Dashboard designers, moving a view results window changed the size of the data.
• In the Dashboard designer, toolbar windows were sometimes left on window. All Viewpoint windows inside Dashboards will now force the menu to close when mouse moves off of the form.
• On a dashboard, the total on a vertical gauge could overlay the chart.
• In the Dashboard designer, use the Right Click/Insert to add either a text box or an action button. The initial box or button does not automatically snap to grid. You must move the item for it to then snap to grid size.
• A Dashboard with a Script View gives error ‘Object NOKEYPATH in library QTEMP not found’ when refreshing the data.
• Dashboard refresh skips views that return no records on first pass.
• Using the Import/Query in Viewpoint, the view is created as *Sequel/*Sequel. It does not use the Users Sequel Default choices.
• Custom formatting for values in digital and radial gauges is lost when any other changes are made.
• Better message handling when view results or Excel Add-in results surpass the 2,000 character limit.
• In the Excel Add-In, adding columns to a worksheet forces you to wait while the column information. Now a ‘wait’ cursor will be shown.
• Using the Excel Add-in will now the characters & and > in the description of the view.
• Excel Add-in: JDE User prompted twice for Environment/Role when adding a View to a new worksheet.
• Excel Plugin for 64 bit Excel could not add in a Script View object,
• On a new Viewpoint install, the default for field list found in tools>ViewPoint Options>Design Tab will be changed to 'position'.
• Silent Install was not properly loading Client Reports.
• View subtotals are lost when view is saved to the repository (both Host and Repository modes).
• Using DATE function in *LOCALSYS View - ViewPoint automatically adds CAST function, causing runtime error.
• Repository Mode:
  • Excel plugin 64 bit- Login windows for Repository mode using SWS had the login hidden behind the Excel workbook.
  • Excel Add-in Repository mode should not require Repository signon if SWS authentication is an Iseries user.
  • In Repository mode for a Host Report, if a title was specified during the wizard, the title will now be saved with the report.
  • Script Designer in Repository mode now checks that the script has a valid name without slashes.
  • In REPOSITORY mode, File >Save As on Existing object will now default to existing name/folder.
  • In Repository mode when using JDE credentials plugin not connecting to selected repository.
  • Attempt to save CRO to repository using Viewpoint Repository mode results in CPD0104 ‘Expression not allowed for parameter REPORT’.
  • A migrated View and Excel workbook, opened in Repository Mode when refreshed, gave error ‘Index was out of range. Must be non-negative and less than the size of the collection’ after logging into the Repository

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

Enhancements

• 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

Fixes

• 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

Enhancements

• 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.
• In Dashboards:
  • The 2 dimensional chart options were added to menu dropdown.
  • Copy/Paste actions added for 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.

Fixes

• 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.
• In Dashboards:
  • 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

Enhancements

• 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.

Fixes

• General:
  • 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.
• In Dashboards:
  • 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.
• Excel Add-in:
  • 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.
• In View Builder:
  • 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).

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 Showcase Products