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:
Can somebody pls help me in resolving this anomaly.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
CR9
VB6




Reply With Quote