how to make a report using crystal report direct from MS Access Form

[bluestuck]

Hii, everyone..
I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "

does anyone know how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?

btw i use database sql server 2008 and MS Access 2007 as my frontend application.

here's the code that i'v found and gives me an error

Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work

 

[liddlem]

Its been a while since I use CR (XI) - But if my memory serves me well, I think you need to make an ODBC connection to the SQL back end.
I remember that I stored my reports in a commonly accessible location on the network, then create a hyperlink from the DB front end to launch the report(s) in question.
Hope this helps.

 

[bluestuck]

thankss, its work...