Results 1 to 3 of 3

Thread: [RESOLVED] Font changes in Report

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Resolved [RESOLVED] Font changes in Report

    Hi everybody,
    I created a report using cr9 in which I am using two fonts namely GurbaniHindi and Narad at different locations. The fonts display correct from CR9, but when i display the same report from VB i.e by adding CRviewer
    control on to a form in the proj all text is displayed in GurbaniHindi font. Below is the code in the reporting form:
    Code:
    Public subCode As Long
    Dim appln As New CRAXDDRT.Application
    Dim Report As New CRAXDDRT.Report
    Private Sub Form_Load()
    Dim SQL As String
    Me.Top = 0
    Me.Left = 0
    Me.Width = Screen.Width
    Me.Height = Screen.Height
    
    Me.MousePointer = vbHourglass
        SQL = "SELECT * FROM sheet1 WHERE Field4 = " & subCode
        Set Report = appln.OpenReport(App.Path & "\Reports\subjectText.rpt")
        Report.Database.Tables(1).Location = App.Path & "\Database\sggs99.mdb"
        Report.Database.Tables(1).ConnectionProperties("Database Password") = "authorisedToUse"
        Report.SQLQueryString = SQL
        CRViewer91.Refresh
        CRViewer91.ReportSource = Report
        CRViewer91.ViewReport
    Me.MousePointer = vbDefault
    End Sub
    
    Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
        Set Report = Nothing
        Set appln = Nothing
    End Sub
    
    Private Sub Form_Resize()
    With CRViewer91
        .Top = 0
        .Left = 0
        .Height = ScaleHeight
        .Width = ScaleWidth
    End With
    End Sub
    Can somebody pls help me in resolving this anomaly.

    CR9
    VB6

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Font changes in Report

    Moved to reporting

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Font changes in Report

    sorry it appears to be some corrupt file. Its now working.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width