Sort on hidden field

edited 10:54AM in FastCube
Row fields are sorted by value like text. I would like to change this sort order to some hidden number field but don't know how to do this.

Comments

  • edited 10:54AM
    Hi.

    Use in TfcCube before open cube:
    // base fields feature
    procedure SetBaseField(AField, ABaseField: String);
    function HaveBaseField(AField: String): Boolean;
    procedure ClearBaseFields;

    For example:
    Field1 - string field (to display)
    Field2 - numeric field (to sort)
    You need:
    fcCube.SetBaseField('Field1', 'Field2');

    Oleg Pryalkov
  • edited 10:54AM
    Is it possible to add this feature to user interface as field property?
    Beacuse I create cube dynamically from different datasets.
  • edited 10:54AM
    You can set Base Field only before loading data.
    Use event TfcCube.BeforeOpen to show your dialog to select and set needed fields.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.