SELECT T2.CustNo,
       T4.Company,
       T3.Description, 
       T1.OrderNo, 
       T3.ListPrice, 
       T3.Cost,
       T1.Qty,
       T1.Qty*T3.Cost as Sales 
FROM   "Items.db" T1,
       "Orders.db" T2, 
       "Parts.db" T3, 
       "Customer.db" T4
WHERE  (T2.OrderNo = T1.OrderNo) AND 
       (T3.PartNo = T1.PartNo) AND 
       (T4.CustNo = T2.CustNo)
ORDER BY T2.CustNo, T3.Description

unit DBDemosUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, plPrev, plQueryPrev, DB, DBTables;

type
  TForm1 = class(TForm)
    Query1: TQuery;
    plQueryPrev1: TplQueryPrev;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
  private
    { Private 宣言 }
  public
    { Public 宣言 }
  end;

var
  Form1: TForm1;

implementation

uses
  Printers;

{$R *.DFM}

//=============================================================================
//  結果をプレビュー
//  オブジェクト・インスペクタで設定した内容でプレビュー
//=============================================================================
procedure TForm1.Button1Click(Sender: TObject);
begin
  //設定ダイアログを表示して設定する場合
  plQueryPrev1.plSetPrinter.ShowSetupDialog;

  //ダイアログを表示しないで設定する場合
  //Orientationの使用には，usesにPrintersが必要
  //plQueryPrev1.plSetPrinter.Orientation := poLandscape;

  //印刷プレビュー開始
  plQueryPrev1.Preview;
end;

end.