[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
Re: Font changes in Report
Re: Font changes in Report
sorry it appears to be some corrupt file. Its now working.