Softpedia >Windows >Programming >Components & Libraries >FastCube VCL >  Changelog

FastCube VCL Changelog

What's new in FastCube VCL 2024.1.7

Mar 13, 2024
  • Engine:
  • Added support of Embarcadero RAD Studio 12
  • Added the ability to optionally use FastQueryBuilder in FastReport
  • Fixed virtual dataset behavior
  • Fixed error in FastCube with RAD Studio 12 under x64
  • Fixed HIDPI issues with RAD Studio 10.4
  • Fixed incorrect font scaling in barcodes at HiDPI
  • Fixed wrong sizes of export filter dialog forms when changing DPI
  • Fixed error after edit measure in FastCube FMX
  • Fixed change selected row when changing filter in Localization Editor
  • Fixed bug in FastCube when calling the editor script function when double clicking on the calculation field
  • Designer:
  • Added new editor for Memo object with syntax highlights (starts from Enterprise version)
  • Added Expression and syntax highlights in Memo object in the report designer workspace
  • Added new field definition editor (replace of an old Alias editor)
  • Added ability to sed type of drag and drop object type when drag data from data tree
  • Added ability to disable auto-updating of field list in the report designer
  • Fixed bug with style property of Gradient object in Object Inspector
  • Exports:
  • Modified Indy TLS usage in E-mail export filter
  • Fixed ligatures positions in RTL languages in PDF export filter
  • Lazarus:
  • Fixed bug in frxSQLEditorForm form
  • Fixed Syntax memo bug in Lazarus
  • Fixed FastCube cross editor in FastReport integration components
  • Other:
  • Fixed - the FMX.ConverterFR3toFRFMX.pas unit does not exist in LibRSXXFMX
  • Fixed - the frx package does not contain the frxFileSignature unit
  • Report object:
  • Fixed IBO package for RAD Studio 12
  • Transport:
  • Added a S3 Transport
  • Added AWS support to S3-Transport
  • Fixed default file extension when saving to clouds from preview
  • Fixed opening reports from clouds

New in FastCube VCL 2021.1.5 (Oct 25, 2022)

  • Added property TfcxSliceGrid.XAxisZone(YAxisZone).WordWrap which setups the word wrapping flags during cell size calculations
  • Highlight cell colors are exported now with XLSX export
  • Added an option TfcxXLSXExport.ExportColumnFieldsTitle (XLSX export) to have an ability to disable export of columns dimension titles (which is usually contains only Measures field)
  • Updated English and Spanish resources
  • Fixed error when Fields selection popup of CubeGrid is clicked
  • Fixed error when topN is pressend in the SliceGrid

New in FastCube VCL 2021.1.4 (May 18, 2022)

  • Fixed error when Fields selection popup of CubeGrid is clicked
  • Fixed error when topN is pressend in the SliceGrid

New in FastCube VCL 2.10 (Feb 10, 2020)

  • Added expression support. Expressions allows to perform simple calculations based on measure and dimension values and functions.
  • Added methods TfcxCustomNodePopup.ExpandAll, TfcxCustomNodePopup.CollapseAll, property TfcxCustomGrid.AutoExpandPopups (true by default) which defines
  • whether to expand/collapse all PopupWindow automatically on show.
  • Added date split to half year.
  • Added Range.IgnoreCase property to ignore case for text compare. Added appropriate checkbox to range editor.
  • Added clear buttons to the measure editor form.
  • Fixed error with loading chart for Lazarus.
  • Fixed compilation for Lazarus/FPC.

New in FastCube VCL 2.9 (Mar 18, 2019)

  • Added TfcxSliceGrid.StatusZone.FloatFormat and TfcxSliceGrid.StatusZone.IntegerFormat. Use them to change format of values in StatusBar.
  • Added TfcxCube.SaveExtras to allow saving of Filters and Charts together with cube.
  • New cube format version with ansi-strings in UTF-8 format for compatibility with .Net
  • Added support for RAD Studio 10.3 Rio
  • Added TfcxSliceGrid.OnAcceptDrag event which allows to control DragDrop operations in grid
  • Added TfcxSlice.SyncronizeYFieldsWidth property which set width syncronization between axis level and field caption
  • Added SliceGrid.OnDrawItem event.
  • Changed CubeGrid header draw and added drop down with filter if FilterManager property set.
  • Changed format of all slice fields are saved in schema.
  • Fixed cell height calculations for large strings
  • Chaned XLSX export to reduce memory use and increase export spead for large cross-tabs
  • Fixed error with cell detail
  • Fixed error with Variant to Double conversion in cell highlight calculation
  • Fixed error with group rename from popup menu
  • Fixed error with unknown script language (.Net cube)
  • Fixed error with Selection
  • Fixed error with sequential loading from multiple sources (UseMultyLoad)
  • Fixed error with splitting of Null date
  • Fixed error with TIBBCDField in RAD Studio 10.*
  • Fixed error with UpdateStyles TfcxCustomGrid.UpdatePainter
  • Fixed error with loading of empty cube.

New in FastCube VCL 2.8.2 (Dec 4, 2018)

  • Added support for RAD Studio 10.3 Rio
  • Added TfcxSliceGrid.OnAcceptDrag event which allows to control DragDrop operations in grid
  • Added TfcxSlice.SyncronizeYFieldsWidth property which set width syncronization between axis level and field caption
  • Added SliceGrid.OnDrawItem event.
  • Changed CubeGrid header draw and added drop down with filter if FilterManager property set.
  • Changed format of all slice fields are saved in schema.
  • Fixed error of loading empty cube.

New in FastCube VCL 2.8.0 (Dec 4, 2018)

  • Added TfcxCustomGrid.OnCreatePainter event which allows to create an own grid painter
  • Added group creation by condition in code and and in TfxSliceGrid menu
  • Groupping and filtering through the axes context menu now handles selection
  • Added TfcxCubeGrid.FilterManager property. If the property is set then grid shows filtered set of data.
  • Added class TfcxFilteredOrderedRecordSetProvider
  • Added TfcxZoneRestriction.zrDontShowDropDown to disable showing of drop down window and a corresponding icon
  • Added method TfcxContinuousHighlight.ImageReverseOrder to set reverse order or icon highlight
  • Added methods TfcxSlice.SetTotalPosition(const Value: TfcxTotalPosition) and TfcxAxisContainer.SetTotalPosition(const Value: TfcxTotalPosition)
  • Added property TDimensions.DetailValue: Variant - current detail value for total calculation by formula based on subtotals.
  • Added property TfcxCubeDataColumns.VisibleIndex[ACubeFieldName: String]: integer
  • Added automatic changing of Y-axis fields header height in report
  • Adding/removing measure runs events OnBeforeAddSliceFieldToRegion, OnAfterAddSliceFieldToRegion and OnBeforeRemoveSliceFieldFromRegion
  • Added chs_Created in TfcxChangeInSlice (creating base empty slice)
  • Added schema loading/saving in AppendData
  • Fixed error in TfcxSourceFieldProperties.AssignTo
  • Fixed error in cells size calculation
  • Fixed error: Integer Overoverflow in CompareSQLTimeStamp
  • Fixed error: value does not load from database when field size greater 8192 byte
  • Fixed error in TfcxRange.Match
  • Fixed error of export to XLSX for collapsed dimensions
  • Fixed errors in German translations (thanks to Ralf Stegemann)
  • Fixed declaration of TfcxChartsManagerOnNeedChart event

New in FastCube VCL 2.7.0 (Dec 5, 2017)

  • Fixed error with Null values in export to Microsoft Excel 2007 (.xlsx)
  • Fixed error of reading milliseconds from XML

New in FastCube VCL 2.6.5 (Aug 14, 2017)

  • Added support for RAD Studio 10.2 Tokyo
  • Added export to Microsoft Excel 2007 (.xlsx)
  • Added procedure TfcxMeasuresContainer.Recalculate
  • Added property TfcxCube.AbortLoading: boolean to abort data loading in event OnProgress
  • Fixed names of TeeChart units in fcxpChartEditor.pas
  • Fixed error with creating measures with missed base field during loading schema
  • Fixed error with Unassigned and 0
  • Fixed error with drawing Fields zone
  • Fixed error with Highlights

New in FastCube VCL 2.6.4 (Apr 21, 2017)

  • Fixed error with Highlights
  • Added support for RAD Studio 10.2 Tokyo
  • Fixed error with HideZero
  • Fixed error with Dataset in TfcxpCube
  • Fixed error in ColOffsetValue and RowOffsetValue
  • Fixed error with comparing Date in Ranges
  • Fixed error with export to Excel introduced in 2.6
  • Fixed errors with export to Excel for 64-bit systems

New in FastCube VCL 2.6.3 (Apr 18, 2017)

  • Fixed error with Highlights
  • Added support for RAD Studio 10.2 Tokyo

New in FastCube VCL 2.6.2 (Apr 14, 2017)

  • Fixed error with HideZero
  • Fixed error with Dataset in TfcxpCube
  • Fixed error in ColOffsetValue and RowOffsetValue
  • Fixed error with comparing Date in Ranges
  • Fixed error with export to Excel introduced in 2.6
  • Fixed errors with export to Excel for 64-bit systems

New in FastCube VCL 2.6 (Apr 14, 2017)

  • Added support for RAD Studio 10.1 Berlin
  • Added published properties Restrictions: TfcxZoneRestrictions for Zones to prohibit schema change by users
  • Slice fields display format is stored in schema
  • Added events TfcxSlice.OnBeforeRemoveSliceFieldFromRegion, OnBeforeAddSliceFieldToRegion and OnAfterAddSliceFieldToRegion
  • Custom popup menu can be used in DetailGrid
  • Added property TfcxMeasureField.ChangeNullToZero: boolean
  • Added property TfcxSlice.OnInterpreterCreated: TfcxInterpreterCreated
  • Added property TfcxpSliceGridReport.Orientation: TPrinterOrientation
  • Added functions TfcxMeasuresContainer.ChangeCalcMeasureScript
  • Apply percent format to "display as percent" cells while export to XLS
  • Added support for ShortInt fields
  • Added few missing resource strings
  • Replacing " " to "_" in function name in measure editor
  • Slice field format change now triggers axis repainting.
  • Slice field format change does not influence format of other fields of the same type.
  • Fixed small errors in HideZero and hidden cells
  • Fixed small errors in exports
  • Fixed error of deleting TfcxSliceGrid and TfcxCubeGrid in the designer
  • Fixed error in ODS export
  • Fixed error with TfcxScriptStringList in RAD Studio 10.1 Berlin
  • Fixed error with Calculated Field
  • Fixed error in TreeLike axis
  • Fixed error with DisplayAs = da_ColRank
  • Fixed error with VarSQLTimeStamp
  • Fixed error of loading old version cube
  • Fixed error of using Percentile
  • Fixed group expanding error
  • Fixed error in recompile.exe
  • Bar chart highlight now properly uses system colors (they converts to RGB first)
  • Fixed design of Measure editor for Lazarus

New in FastCube VCL 2.5.6 (Sep 1, 2016)

  • Added support of Embarcadero Rad Studio 10 Seattle;
  • Added restoring selected cell after loading schema;
  • Added export to CSV;
  • Added property TfcxAxisContainer.DimCaption[ALevel: TfcxSmallCount; AVisIndex: Integer]: TfcxString;
  • Reimplemented XML-A export;
  • If cell value is both minimum and maximum of the column/row then treat it as maximum for highlight rules;
  • Fixed errors in language resources;
  • Fixed errors in HTML and Excel exports;
  • Fixed error in HTML and Excel exports (error with property RepeatValues);
  • Fixed error in TfcxAxisContainer.DimValue;
  • Fixed error with double destruction of popup menu;
  • Fixed error in sorting.

New in FastCube VCL 2.4 (Sep 1, 2016)

  • Added OnPrepareSaveDialog event for export components. This allows to setup save dialog before showing it to user;
  • Additional totals uses property CalcTotalsOnTotals;
  • Fixed painting of expand/collapse icons when windows themes are disabled and some VCL style is used;
  • Fixed error with SmallInt;
  • Fixed: SliceFieldExtra is not saved in Measure Editor;
  • Fixed error Out of memory in some case.

New in FastCube VCL 2.3 (Sep 1, 2016)

  • The latest version of FastCube VCL supports Embarcadero RAD Studio XE8 (Delphi XE8/C++Builder XE8);
  • Added sorting in CubeGrid and DetailGrid;
  • Added TfcxSlice.ApplyDefaultSettings;
  • Added TfcxSlice.ResetDisplayLabelOfFields;
  • Added aggregate function Weighted arithmetic mean;
  • Detail grid does not reset the list of fields on each show;
  • Added aggregate function Median;
  • Added option "Merge Cells" in export to Excel;
  • Acceleration and optimization calculation of measures;
  • Hide "Sort" menu item for "Measures" field since it has no sense for it;
  • Renamed property TfcxMeasureField.SliceField2 to TfcxMeasureField.SliceFieldDistinct;
  • Removed filters for number input in the Range editor;
  • Fixed errors of calculation of totals which based on other totals;
  • Fixed errors of measures calculation;
  • Fixed error of loading filters with NULL value;
  • Disabled DoubleBuffered, ParentDoubleBuffered for XE6+ since it cause painting glitches;
  • Fixed error with attributes referenced from main dataset;
  • Fixed error in TfcxMeasuresContainer.SetPosition;
  • Fixed error in HideZero;
  • Fixed memory allocation error in xls Export on 64bit platforms;
  • Fixed error in TfcxAxisContainer.DimValue;
  • Fixed error in CopyToClipboard from DetailGrid;
  • Fixed error with determining of Minimal Value for conditional highlight in some situations.

New in FastCube VCL 2.2.0 (Oct 29, 2014)

  • Added support of Embarcadero Rad Studio XE7 (Delphi XE7/C++Builder XE7)
  • Added support of Embarcadero Rad Studio XE6 (Delphi XE6/C++Builder XE6)
  • Added properties Distinct and DistinctField into Measure editor
  • Added: System counter can use Distinct and DistinctField
  • Added checking the number of rows and columns in Excel 97-2003 export
  • Added property TfcxSlice.ClearUnattachedFieldsFilter: Boolean and function TfcxSlice.ResetUnattachedFieldsFilter: boolean (Reset filters in fields not placed in Axis or Filters)
  • Сase insensitive compare in TfcxSliceFields.IndexOfField
  • Added properties TfcxMeasureField.Distinct: Boolean, TfcxMeasureField.DistinctForTotal: Boolean and
  • TfcxMeasureField.SliceField2: TfcxSliceField. It allows check uniqueness of values of additional field during calculation
  • Added support of ftSingle fields
  • Added property TfcxAxisContainer.DimValue[ALevel: TfcxSmallCount; AVisIndex: Integer]: variant
  • Added property TfcxDataSource.UseOnlyVisibleFields
  • Added property TfcxSliceGridToolbar.DialogsDefaultPath for Save/Open dialogs.
  • Added TMeasure.ColOffsetTotalValueForDims[Offset: integer; ADimNames:String]: Variant and TMeasure.RowOffsetTotalValueForDims[Offset: integer; ADimNames: String]: Variant
  • Refactor code to split non-visual part from visual part
  • Added editor for additional calculated total into Dimension editor
  • Added Axis editor
  • Speedup filters loading
  • Added compatibility with FastCube 2 FMX
  • Added Croatian translation by Kresimir Majdenic
  • Added German translation by Thomas Werling
  • Added Italian translation by Augusto Pellis
  • Fixed error in Excel 97-2003 export
  • Fixed error with size of filter region
  • Fixed error in TMeasure.ColOffsetValue[Offset: integer]: Variant, TMeasure.RowOffsetValue[Offset: integer]: Variant and TMeasure.ColRowOffsetValue[ColOffset, RowOffset: integer]: Variant
  • Fixed error: wrong filter setting after loading filter in some case.
  • Fixed errors: AV with property CreateAllCells in calculation measure when all measures are calculation
  • Fixed error: wrong measure values in some cases during script calculation
  • Fixed errors: AV in TfcxSliceGrid not linked with TfcxSlice
  • Fixed error: AV after editing measure
  • Fixed error: AV in export
  • Fixed error: AV during adding measure when TopN is active
  • Fixed error with national characters in incremental search
  • Fixed error with TIBBCDField
  • Fixed errors in property TfcxSlice.FieldsOrder
  • Fixed error: AV after the field drop to an axis with an expanded group
  • Fixed: OK button was not translated in Information dialog
  • Fixed property spelling (was ArgFuncs become AgrFuncs)
  • Fixed status zone popup menu checks
  • Fixed error: AV in TfcxSlice.InternalSetSelectedVis
  • Fixed error in SliceGrid styles applying (memory corruption)

New in FastCube VCL 2.0 (Oct 7, 2013)

  • Grids:
  • Improvements to source data grid
  • Closer to the native look of Windows with enabled themes
  • Gradient drawing
  • Data analysis:
  • Optimized axis operations
  • New dimension attribute for single choice (radio filter)
  • improvements in Groups and 4Totals
  • Ranks for measures
  • Tree-like axis
  • Data highlighting styles
  • Status panel
  • Advanced using of FastScript
  • New export filters
  • Cube:
  • Splits
  • Loading from custom storage
  • Data conversion during the load process
  • Custom field calculation during the load process
  • Add/remove operations on fields after the load
  • Append data to an active cube
  • Global filter

New in FastCube VCL 2 Beta (Jan 30, 2013)

  • Using paint style in the grid (first step). See "Cross table" tab - "Grid style".
  • Printing chart in report. See "Cross table" and "Chart" tabs.
  • New aggregate function "Count of Unique". See examples.
  • New aggregate function "First value". See examples.
  • Using text measure. See examples.
  • Using values of detail records in the script for calculated measures. See examples.
  • Export of cube/cube data to the following XML formats: XML for Analysis, xml-msdata (.Net DataSet), ms rowset (ADO), DataPacket (ClientDataset). See export.
  • Using events to format chart. See "Chart" tab.
  • Properties TfcSlice.FieldsOrder: type of order in the Field List (by Field Name, by Field Caption, by order in DataSet, by event OnFieldsListSortCompare). See "Cross table" tab - "Slice options".

New in FastCube VCL 1.9 (Mar 3, 2012)

  • Added support of Embarcadero Rad Studio XE2 (Delphi XE2/C++Builder XE2);
  • Added feature loading data from multiple sources with the same structure. Added TfcCube.UseMultiLoad property and event
  • TfcCube.OnGetNextDataset
  • Added Lithuanian resources (thanks Evaldas);
  • Added in script properties VisibleCol and VisibleRow in TDimensions and TMeasures;
  • Added option mdcoUseYearInWeekOfYear in TfcCube.Options. It allows to distinguish number of week from the past or from the next year;
  • Added in script properties TDimensions.MembersCountInCol: Integer and TDimensions.MembersCountInRow: Integer;
  • Added option mdsoCalcOrderByDimOrder in TfcSlice (Use Dimensions order during calculation measures);
  • Added event OnAfterAddedSliceFieldToRegion: TfcSliceFieldRegionChanged in TfcSlice;
  • Added version info in StatForm (open from toolbar);
  • Added Hungarian resources (thanks Berenyi Gabor);
  • unit fcAbout renamed to fcAboutDlg since 1stClass has same unit name
  • Changed for compatibility with version 2
  • Fixed error in GetFirstColIndex, GetFirstRowIndex;
  • Fixed error in TfcCube.Refresh;
  • Fixed error loading multiple dataset;
  • Fixed few errors with showing nationals characters in Lazarus;
  • Changed few sort routines to fix problems with accidental dissapearing of random dimension members experienced by Lazarus users only;
  • Fixed error with sort by measure totals and focused row/column
  • (measures count > 1);
  • Fixed print error (value with '[]');
  • Fixed Recompile ({$R-} {- Range-Checking });
  • Fixed Recompile for Embarcadero Rad Studio XE (Delphi XE/C++Builder XE).

New in FastCube VCL 1.8 (Oct 19, 2010)

  • Added support of Embarcadero Rad Studio XE (Delphi XE/C++Builder XE)
  • Added property RunScriptInDesigner in TfrcCube.
  • Added search by first symbol (after pressing a key) in popup lists (list of fields and the lists of unique values)
  • Added TeeChart 2010 support
  • Fixed error: AV when calculation measure is moved in field list
  • Fixed range drawing when XP themes are enabled.
  • Fixed error with UnicodeString measures
  • Fixed error: AV after compiling project without using runtime packages in BCB 6
  • Fixed error with ftMemo fields
  • Fixed error of TfcGrid printing

New in FastCube VCL 1.7.1 (Jun 16, 2010)

  • Added script event OnGetFieldConv in TfrcCube.
  • Added parameter ACalcRowHeight: boolean in TfcGrid.SelectCell
  • Added events TfcSlice.OnBeforeRemoveSliceFieldFromRegion and TfcSlice.OnBeforeAddedSliceFieldToRegion

New in FastCube VCL 1.6 (Oct 27, 2009)

  • Added function TfcAxis.GetVisibleIndexFromAbs(ALevel: Integer; AAbsIndex: Integer; var AIndex: integer; var AVisible: Boolean): Boolean;
  • Added procedure TfcGrid.SelectCell(ACol, ARow: integer; AMakeVisible: boolean);
  • Added support for Embarcadero Rad Studio 2010 (Delphi/C++Builder)
  • Added option mdsoSaveFiltersByValue ? TfcSlice (save in Schema filters by value)
  • Added new aggregate function "Last value". It is possible to use it with any type of the data!
  • Added property UseParentFont into TfcGridStyles.
  • Font, color and alignment of TfcGrid are used when print with TfrcGrid.
  • Added property Font into TfcGridStyle.
  • Added script property Measure[].TotalValueForDims['dim1, dim2, ...'] to get measure total value for dimensions dim1, dim2, ...
  • Added Greek resources (thanks Dimitris Karagikas)
  • Added an ability to use one field for the measures and dimension simultaneously
  • Added script events OnGetSeriesClass, OnSeriesCreated and OnChartFilled in TfrcChartView.
  • Updated chart support in unit frcCrossRTTI.
  • Added property StackType (MultiBar) in TfcChart.
  • Added support THorizBarSeries in TfcChart.
  • Added new events OnSaveTemplate and OnLoadTemplate in TfcChart.
  • Added new property DefaultTemplatePath in TfcChart.
  • Added new properties DefaultSchemePath, DefaultCubePath and DefaultExportPath in TfcGrid.
  • Added option in Grid: mdgoChangeOrderByClick - Switching order of sorting by one mouse button clicking.
  • Added properties Dimensions.IsTotalByCol and Dimensions.IsTotalByRow. You can use this properties in Script.
  • Added new format type fkCustom (You can to create and registrate custom formates. Use fcCustomFormats.AddFormat. See examples fcExamples).
  • Added Swedish resources from Niklas Larsson
  • Added FastReport integration package for BCB6
  • Added: You simultaneously can change width of all columns in the X axis. Keep key Ctrl at change of width of the column.
  • Only the UTF8 encoding is now used for scheme files.
  • Event TfrcGrid.onGetStyles is changed
  • Fixed export of Null data into various XML formats
  • Fixed error of reading from stream property StackType (MultiBar) in TfcChart.
  • Fixed error with property DefaultExportPath in TfcGrid and property DefaultTemplatePath in TfcChart.
  • Fixed width TfcChartToolBar.
  • Fixed error of reading Chart Template from version before 1.5.5.
  • Fixed error: Calculation of sizes of memos is wrong in FastReport if are used different fonts.
  • Fixed error: AV in Chart if no data in grid
  • Fixed error: Caption of measures are wrong when dimension is collapsed