Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrating from version 8 to version 9

Status
Not open for further replies.

FarzanaSaleem

Programmer
Jun 17, 2003
63
PK
I am working with my colleague on a project. Both of us were given some reports to devleop on Crystal Report. I have Crystal Report version 8, installed on my PC whereas my colleague has version 9 installed.
I did not take this factor into consideration and develop my reports on version 8. My colleague completed his reports on version 9 and sent it to me for integration.

When I tried to open these reports on version 8 of crystal reports, I got the error; invalid report version. Then I also installed version 9 and saved my reports on version 9 as well.


When I tried to integrate these reports in my application (using Visual Basic 6.0), I got the error:
Unable to load report.

Then I came to know that version 9 does not support ocx approach. It seems that I will have to do a lot of rework and shift from ocx approach to RDC appraoch.

One solution that came to my mind (if it is possible) is to save version 9 report as version 8 reports, just like in MS Word, we can save current document in Word 6.0/95 format.

Please suggest
 
Unfortunately, Crystal Decisions did not provide a way to go from v9 to prior versions. They say that it is because of Unicode compliance, but I am pretty sure that this is not a physical impossibility, just a strategic decision. It will probably take a third party to develop a conversion utility, if the demand becomes great enough.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
I tried to use RDC approach as follows:

OCX Version:

Private Sub Form_Load()
CR1.ReportFileName = "C:\ListDepartment.rpt"
CR1.ReportTitle = "Department"
CR1.WindowTitle = "Department"
CR1.SelectionFormula = "{Department.Active}='Y'"
CR1.Destination = crptToWindow
CR1.Connect = reportConnectionString
CR1.Action = 1
End Sub


RDC Version:

Dim Appl As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Dim I As Integer

Private Sub Form_Load()
Set Report = Appl.OpenReport("C:\ListDepartment.Rpt")
Screen.MousePointer = vbHourglass
For I = 1 To Report.Database.Tables.Count
Report.Database.Tables(I).Location = "C:\ABC.UDL"
Next I
CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefault
End Sub

Private Sub Form_Resize()
With CRViewer91
.Top = 0
.Left = 0
.Width = Me.ScaleWidth
.Height = Me.ScaleHeight
End With
End Sub

I have completed the following tasks of the OCX Version:

CR1.ReportFileName = "C:\ListDepartment.rpt"
CR1.Destination = crptToWindow
CR1.Connect = reportConnectionString
CR1.Action = 1

Now I need to achieve the following tasks in RDC approach:
CR1.ReportTitle = "Department"
CR1.WindowTitle = "Department"
CR1.SelectionFormula = "{Department.Active}='Y'"

Please advise

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top