hello,

i have 2 easy proplems :
1)
how to do a query and put the result in a report (crystal report)
i have used this cose:
a = "select * from t1 where id ='1' order by no"
Data1.RecordSource = (a)
Data1.Refresh
r1.ReportFileName = "E:\a.rpt"
r1.DataFiles(0) = "E:\a.mdb"
r1.Destination = crptToWindow
r1.Action = 1

2)
how to show the report in the same frame ??
not to open crystal report frame.

inrepoll