Exopen Report 4 uses three Excel add-ins
Exopen Report 6 uses a single Excel add-in
Exopen Report 4 only supports 32-bit Excel for Windows.
Exopen Report 6 supports both 64-bit, and 32-bit Excel for Windows. Make sure to use the installation files matching the bitness of your Office installation.
Exopen Report 4 only supports using ODBC data sources.
Exopen Report 6 supports using the following ADO.NET .NET Framework Data Providers:
Getting data from a database to the report:
Putting data from the report to the database:
Exopen Report 4 uses Excel User Defined Functions (UDF) to specify the Exopen
…-functions in the Excel sheets, e.g.
=ExOpenRecordExport("CONTOSO";A1:A19;A26:AA5025;;FALSE;;;"";"";TRUE;FALSE;FALSE)
Exopen Report 6 uses the Excel built-in function CHOOSE to specify the Exo
…-functions in in the Excel sheets, e.g.
=CHOOSE(1;"ExoListLoad";;"Contoso";$A$1:$A$34;A40:AA1000;"";"VERTICAL";"FALSE";"TRUE";"FALSE")
The Exo…Store functions in EOX6 have a different behaviour compared to the ExOpen…Import in EOX4.
In Exopen Report 4 the ExOpen…Import functions created SQL INSERT
, UPDATE
, and DELETE
statements based on the SELECT
query in the function’s query area, and operated one record at a time.
In Exopen Report 6 the Exo…Store functions need to call a stored procedure, which in turn requires an User Defined Type (UDT) set up to define the table-valued parameter. All the rows in the function input area are sent to the procedure at once, and in the procedure you can define how the data is to be handled.
For more details regarding Store functions, see the Creating store functions and associated procedure and UDT example in the Exopen Report 6 User Manual.
In Exopen Report 6 there is built-in functionality (Tools → Convert EOX4 to EOX6) to convert Exopen Report 4 reports to the Exopen Report 6 format. The conversion can handle most cases, but for more complex reports there can be a need to perform some manual adjustments.
All EOX4 ExOpen…Import-functions are converted to the EOX6 Exo…Import compatibility functions. It is recommended to manually convert these to the EOX6 Exo…Store functions. This is primarily due to performance reasons, and secondarily due to that these Import compatibility functions do not have every option implemented that existed in EOX4 for corresponding functions.
EOX4 Function | EOX6 Function |
---|---|
ExOpenActiveUser | ExoActiveUser |
ExOpenClearArea | ExoClearArea |
ExOpenColReplaceExport | ExoColumnReplaceLoad |
ExOpenColumnExport | ExoColumnLoad |
ExOpenColumnImport | ExoColumnStore, ExoColumnImport |
ExOpenDateFormat | ExoFormatValue |
ExOpenDrillDown | ExoDrillDown |
ExOpenHideEmpty | ExoHide |
ExOpenInQuery | ExoInQuery |
ExOpenInRange | ExoInRange |
ExOpenInUserKeys | ExoInPermission |
ExOpenListExport | ExoGroupedListLoad |
ExOpenMatrix | ExoMatrixMultiLoad |
ExOpenMatrixExport | ExoMatrixLoad |
ExOpenMatrixImport | ExoMatrixStore, ExoMatrixImport |
ExOpenPublish | ExoPublish |
ExOpenRecordExport | ExoListLoad |
ExOpenRecordImport | ExoListStore, ExoRecordImport |
ExOpenRowExport | ExoRowLoad |
ExOpenRowImport | ExoRowStore, ExoRowImport |
ExOpenRunDate | ExoTimeStamp |
ExOpenSelectFromRange | ExoInputFilter |
ExOpenSingleRecordExport | ExoSingleRecordLoad |
ExOpenSingleRecordImport | ExoListStore, ExoSingleRecordImport |