sorted datas with frxuserdataset
hello together,
I put data from my application inside a frxuserdataset by using frxUserDataSet1GetValue.
To calculate something I save the data also in a ValueList:TStringList.
procedure MasterData1OnBeforePrint(Sender: TfrxComponent);
... not Engine.FinalPass then
ValueList.Add(<frxUserDataSet1."WallThick">) ;
and:
ReportTitle1OnBeforePrint(Sender: TfrxComponent);
....
Engine.FinalPass then...
Now, the Problem: I've to sort the data before using in the userdataset.
Are there some idea how I can manage it?
Using SQL-Query with userdataset? Possible?
Maybe, rewrite the data to the userdataset after the sorting?
Thanks for your help....
I put data from my application inside a frxuserdataset by using frxUserDataSet1GetValue.
To calculate something I save the data also in a ValueList:TStringList.
procedure MasterData1OnBeforePrint(Sender: TfrxComponent);
... not Engine.FinalPass then
ValueList.Add(<frxUserDataSet1."WallThick">) ;
and:
ReportTitle1OnBeforePrint(Sender: TfrxComponent);
....
Engine.FinalPass then...
Now, the Problem: I've to sort the data before using in the userdataset.
Are there some idea how I can manage it?
Using SQL-Query with userdataset? Possible?
Maybe, rewrite the data to the userdataset after the sorting?
Thanks for your help....
Comments
grouping requires you to sort you queries using an order by clause to order the fields,
in the order of the group(s) conditions.
tables should be presorted.