BUG:sum(..) in fastreport3.03 & 3.05

Comments

• bjzhq

  November 2004 edited November 2004

  i test that ADO, BDE are ok, only dbx has above case.
  note: fr3.03 & fr3.05
• bjzhq

  November 2004 edited November 2004

  i test that dbx is ok with fr2.53
  
  i hope author can check it.
  
  best regard！
• AlexTZ

  November 2004 edited 2:29AM

  DBX is unidirectional dataset, this may cause such problems.
• bjzhq

  November 2004 edited 2:29AM

  AlexTZ wrote:

  DBX is unidirectional dataset, this may cause such problems.

  I do not know this problem is caused by DBX, because:
  1. the way I get data is : SQLConnection + SQLQuery + DatasetProvider -->
  ClientDataSet --> fastreport
  2. I uses same way, fastreport2.53 has no such problems
  note: I use mssql2000
  
  thanks, best regard!
• AlexTZ

  November 2004 edited 2:29AM

  Do you able to make a demo that uses clientdataset only? I don't have mssql on my PC.
• bjzhq

  November 2004 edited November 2004

  I write TfrxDBXQueryEx as TfrxIBXQuery(fr3_DeveloperManual-en.pdf)
  TfrxDBXQueryEx = class(TfrxCustomQuery)
  private
  FDatabase: TfrxDBXDatabase;
  FClientDataSet: TClientDataSet; //***
  procedure SetDatabase(const Value: TfrxDBXDatabase);
  protected
  procedure Notification(AComponent: TComponent; Operation: TOperation); override;
  procedure SetMaster(const Value: TDataSource); override;
  procedure SetSQL(Value: TStrings); override;
  function GetSQL: TStrings; override;
  public
  constructor Create(AOwner: TComponent); override;
  class function GetDescription: String; override;
  procedure UpdateParams; override;
  property Query: TClientDataSet read FClientDataSet; //****
  published
  property Database: TfrxDBXDatabase read FDatabase write SetDatabase;
  end;
  
  I create a temporary SQLQuery and TDataSetProvide when I get data by SQL.
  so, I can retrive data through SQLConnection + SQLQuery + DatasetProvider -->
  ClientDataSet --> fastreport.
  but I meet two problems:
  1.sum(expression) sometimes error data, but sum(OneField) is right data
  2.order by sum(expression or OneField) desc, I get data always is ascend data,
  but order by OneField desc, is descend data
  note:
  1.above case happend with fr3.xx and DBX. but BDE and ADO has not above case
  2.fr2.53 has no above case with BDE, ADO and DBX