frmprint.frm

很好用的通用库存管理程序

VERSION 5.00
Object = "{8767A745-088E-4CA6-8594-073D6D2DE57A}#9.2#0"; "crviewer9.dll"
Begin VB.Form FrmPrinter 
   Caption         =   "报表打印"
   ClientHeight    =   7665
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   9645
   Icon            =   "frmPrint.frx":0000
   LinkTopic       =   "Form2"
   ScaleHeight     =   7665
   ScaleWidth      =   9645
   StartUpPosition =   3  '窗口缺省
   WindowState     =   2  'Maximized
   Begin CRVIEWER9LibCtl.CRViewer9 CRViewer91 
      Height          =   7335
      Left            =   -1320
      TabIndex        =   0
      Top             =   0
      Width           =   9495
      lastProp        =   500
      _cx             =   16748
      _cy             =   12938
      DisplayGroupTree=   -1  'True
      DisplayToolbar  =   -1  'True
      EnableGroupTree =   0   'False
      EnableNavigationControls=   -1  'True
      EnableStopButton=   -1  'True
      EnablePrintButton=   -1  'True
      EnableZoomControl=   -1  'True
      EnableCloseButton=   -1  'True
      EnableProgressControl=   -1  'True
      EnableSearchControl=   -1  'True
      EnableRefreshButton=   -1  'True
      EnableDrillDown =   -1  'True
      EnableAnimationControl=   -1  'True
      EnableSelectExpertButton=   0   'False
      EnableToolbar   =   -1  'True
      DisplayBorder   =   -1  'True
      DisplayTabs     =   -1  'True
      DisplayBackgroundEdge=   -1  'True
      SelectionFormula=   ""
      EnablePopupMenu =   -1  'True
      EnableExportButton=   0   'False
      EnableSearchExpertButton=   0   'False
      EnableHelpButton=   0   'False
      LaunchHTTPHyperlinksInNewBrowser=   -1  'True
   End
End
Attribute VB_Name = "FrmPrinter"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim CRXReport As New CRAXDRT.Report
Private Sub Load_RPT(rpt_Path)
'Dim CRTable As CRAXDRT.DatabaseTable
'On Error GoTo ErrHandle
 'Dim CPProperty As CRAXDRT.ConnectionProperty
   'Dim CRTable As CRAXDRT.DatabaseTable
Set CRXReport = CRXApplication.OpenReport(rpt_Path, 1)

CRCommand.ActiveConnection = db
CRCommand.CommandType = adCmdText
CRCommand.CommandText = SqlBase

CRXReport.Database.AddADOCommand db, CRCommand
CRXReport.SQLQueryString = SqlBase
CRViewer91.ReportSource = CRXReport
CRViewer91.ViewReport
'Exit Sub
'ErrHandle:
'MsgBox Err.Description, vbCritical, "Error"
 
End Sub


Private Sub Form_Load()
 Load_RPT PublicPath
 Form_Resize
End Sub
Private Sub Form_Resize()
   
    CRViewer91.Top = 0
    CRViewer91.Left = 0
    CRViewer91.Height = Me.Height - 200
    CRViewer91.Width = Me.Width - 200
End Sub