frmpreview.frm

人事管理信息系统

VERSION 5.00
Object = "{8767A745-088E-4CA6-8594-073D6D2DE57A}#9.2#0"; "crviewer9.dll"
Begin VB.Form frmPreview 
   Caption         =   "报表预览"
   ClientHeight    =   3210
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4965
   LinkTopic       =   "Form1"
   ScaleHeight     =   3210
   ScaleWidth      =   4965
   StartUpPosition =   3  'Windows Default
   Begin CRVIEWER9LibCtl.CRViewer9 reportPreview 
      Height          =   2895
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   4575
      lastProp        =   500
      _cx             =   8070
      _cy             =   5106
      DisplayGroupTree=   -1  'True
      DisplayToolbar  =   -1  'True
      EnableGroupTree =   -1  'True
      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 = "frmPreview"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public reportSQL As String
Public reportName As String
Private Sub Form_Load()
    'Dim Connection As New ADODB.Connection
    'Dim recReport As New ADODB.Recordset
    'Dim MsgText As String
    Dim CRXApplication As New CRAXDRT.Application
    Dim CRXReport As CRAXDRT.Report
    'Dim CRXDatabase As CRAXDRT.Database
    

    'Connection.ConnectionString = "Data Source= Xtreme Sample Database 9;User ID=;Password=;"
    'Connection.Open
    
    'Set recReport = ExecuteSQL(reportSQL, MsgText)
    
    'CRViewer91.EnablePrintButton = False
    
    'recReport.Open reportSQL, Connection, adOpenDynamic, adLockPessimistic, adCmdText

    'If Not recReport.EOF Then
    
        
        'Set CRXReport = CRXApplication.OpenReport("D:\program\VB_PROJECTS\Vb_Common\reports\USE ACTIVEX DATA\RPT\report1.rpt", 1)
        
        Set CRXReport = CRXApplication.OpenReport(reportName)
        CRXReport.RecordSelectionFormula = reportSQL
        'Set CRXDatabase = CRXReport.Database
        'CRXDatabase.SetDataSource RS, 3, 1
        'CRXReport.Database.SetDataSource recReport, 3, 1
        'CRXReport.PrintOut
        reportPreview.ReportSource = CRXReport
        reportPreview.ViewReport
    'Else
    '    Exit Sub
    'End If
    
    'Set recReport = Nothing
    
    
    
End Sub

Private Sub Form_Resize()
reportPreview.Top = 0
reportPreview.Left = 0
reportPreview.Height = ScaleHeight
reportPreview.Width = ScaleWidth
End Sub