1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
| // *******************
// Bloc impression
// *******************
procedure TfmTriParDate.frxUserDataSetTriDateCheckEOF(Sender: TObject; var Eof: Boolean);
begin
Eof := lig > DBGridTri.RowCount - 2;
end;
procedure TfmTriParDate.frxUserDataSetTriDateFirst(Sender: TObject);
begin
lig := 1; // premier enregistrement
end;
procedure TfmTriParDate.frxUserDataSetTriDateGetValue(const VarName: string; var Value: Variant);
begin
if SameText(VarName, 'DateEnregistre') then
Value := DBGridTri.Cells[2, lig];
if SameText(VarName, 'Types') then
Value := DBGridTri.Cells[3, lig];
if SameText(VarName, 'NumChq') then
Value := DBGridTri.Cells[4, lig];
if SameText(VarName, 'Tiers') then
Value := DBGridTri.Cells[5, lig];
if SameText(VarName, 'Cat') then
Value := DBGridTri.Cells[6, lig];
if SameText(VarName, 'Debit') then
Value := DBGridTri.Cells[7, lig];
if SameText(VarName, 'Credit') then
Value := DBGridTri.Cells[8, lig];
end;
procedure TfmTriParDate.frxUserDataSetTriDateNext(Sender: TObject);
begin
Inc(lig); // prochaine ligne
end;
// *********************************
procedure TfmTriParDate.BtImprimerClick(Sender: TObject);
var
MemoCpt, MemoBanque, MemoTotCpt, MemoDebit: TfrxMemoView;
begin
// ***** Impression du Compte
// nom du Rapport: FrImpFiltreDetailsCpt.fr3
MemoCpt := frxReportFiltreCpt.FindObject('MemoCpt') as TfrxMemoView;
MemoCpt.Text := LblDetailNomCpt.Caption;
MemoBanque := frxReportFiltreCpt.FindObject('MemoBanque') as TfrxMemoView;
MemoBanque.Text := Banque;
MemoDebit := frxReportFiltreCpt.FindObject('MemoDebit') as TfrxMemoView;
MemoDebit.Text := FormatFloat('#,##0.00', DBGridTri.ColumnSum(7, 1, DBGridTri.RowCount - 2)) + #128;
MemoTotCpt := frxReportFiltreCpt.FindObject('MemoTotCpt') as TfrxMemoView;
MemoTotCpt.Text := FormatFloat('#,##0.00', DBGridTri.ColumnSum(8, 1, DBGridTri.RowCount - 2)) + #128;
frxReportFiltreCpt.PrepareReport();
frxReportFiltreCpt.PreviewOptions.Zoom := 1.45; // pour avoir 145 %
frxReportFiltreCpt.ShowPreparedReport;
end; |
Partager