p_qr_report.~pas

学员管理的软件

unit P_qr_report;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, QuickRpt, QRCtrls, ExtCtrls;

type
  TP_sj_report = class(TForm)
    QuickRep1: TQuickRep;
    QRBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRBand2: TQRBand;
    QRDBText1: TQRDBText;
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  P_sj_report: TP_sj_report;
  mysj_name:string;

implementation

{$R *.dfm}
uses main;
procedure TP_sj_report.FormShow(Sender: TObject);
begin
//main.DataModule2.report_aq.Close;
//QRLabel6.Caption:=mysj_name;
main.DataModule2.report_aq.Filter:='试卷名称='''+mysj_name+'''';
main.DataModule2.report_aq.Filtered:=true;
(*
with main.DataModule2 do
begin
report_aq.Close;
report_aq.SQL.Clear;
report_aq.SQL.Add('select 试卷名称,题目,选项1,选项2,选项3,选项4 from 试题表,试卷表 where 试题表.试卷号=试卷表.试卷号 and 试卷号='''+mysj_name+'''');
report_aq.Open;
QRDBText1.DataField:='试卷名称';
QRDBText1.DataSet:=report_aq;
QRDBText2.DataField:='题目';
QRDBText2.DataSet:=report_aq;
QRDBText3.DataField:='选项1';
QRDBText3.DataSet:=report_aq;
QRDBText4.DataField:='选项2';
QRDBText4.DataSet:=report_aq;
QRDBText5.DataField:='选项3';
QRDBText5.DataSet:=report_aq;
QRDBText6.DataField:='选项4';
QRDBText6.DataSet:=report_aq;
end;
*)
//main.DataModule2.report_aq.Open;
end;

end.