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

bjzhq

group header: condition is qrySellStock."account"

masterData1:

on group footer band:
[SUM(<qrySellStock."qty">,masterData1, 1)] is OK,
[SUM(<qrySellStock."qty">*<qrySellStock."price">,masterData1, 1)] is sometimes incorrect data

note: I use DBX with fr3.03 & fr3.05

why?

bjzhq

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

bjzhq

i test that dbx is ok with fr2.53

i hope author can check it.

best regard！

AlexTZ

DBX is unidirectional dataset, this may cause such problems.

bjzhq

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

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

bjzhq

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