>I have a foxpro form that displays and prints a crystal report!
>Thanks to the help of Phil and Universal Thread:)
>Well.... I want to be able to set filters on the table Im reporting from how can I go about that?
>Idealy I want foxpro to do the SQL and crystal to report from the database... is that possible?

---

It would be "Crystal.CRPE.Application".

select * from (tcTable) where ... into cursor myCursor
lcTemp = sys(2015)
Copy to (tcPath+lcTemp) type fox2x
oCrystal=CreateObject("Crystal.CRPE.Application")
#Define WS_MAXIMIZE  29949952
DECLARE integer GetForegroundWindow in WIN32API
DECLARE short IsWindow in WIN32API integer
....
oRpt = oCrystal.OpenReport(lcReportName+".RPT")
With oRpt
  With .Database.Tables(lcTable)
    .Location = tcPath+lcTemp+".dbf"
  Endwith
...

Cetin