After I use the refresh button on the crviewer the lines from second table (linked in the cr program) in the details section of the .prt file doubles in the crviewer.

I am using CR XI and vb6
I have following code:


sql_string_03 = "SELECT * FROM TblHfdRegel"
Set Geg_rsdata_03 = New ADODB.Recordset
Geg_rsdata_03.Open sql_string_03, cndatabase_02, adOpenKeyset, adLockOptimistic

Set oApp = CreateObject("CrystalRuntime.application.11")
Set oReport = oApp.OpenReport(App.Path & "\printen.rpt", 1)
oReport.Database.SetDataSource Geg_rsdata_03, 3, 1
oReport.DiscardSavedData

CRViewer1.ReportSource = oReport
CRViewer1.Refresh
CRViewer1.ViewReport

Set oReport = Nothing
Set oApp = Nothing

Geg_rsdata_03.Close
Set Geg_rsdata_03 = Nothing

Thanks in advance,
Brian