Inserting / Using Crystal 10 report in Access form

[skalina]

I'm able to do this with earlier versions of Crystal - but am having trouble with Crystal 9 and 10...

I've inserted the Crystal ActiveX report Viewer Control 10 Object - but not sure what to do with that exactly...For now, i've renamed it as CR.

Then i added a button and changed the vb code to as follows:


Private Sub Command3_Click()
CR.Connect = "Provider=SQLOLEDB.1;Server=LSCSK;Database=TWO;UID=sa;PWD=truman"
CR.ReportFileName = "c:\VBcrTest.rpt"
CR.Action = 1
End Sub

Doesn't seem to be working -- anyone have any suggestions?

Thanks

Steve