crystal report and query and .........

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

Quote:

---

Originally posted by interpoll
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

---

To Same Frame: I think this is only possible if u r using Crystal Reports ver 8.0 prior to that every time it opens a new window. I've tried displaying in same frame in prior versions but ended up opening a new window.

Qury: Well what happened when u used that code

for first problem u can use
crystalreprot1.Selection formula ="{t1.id}="& yourvalue

for problem 2 :
as cutamacious posted.

when i tried the report show all the recordsets

and i want to show the query recordsets

interpoll

can input the full code??

CrystalReport1.SelectionFormula This statement is filters the Records according to u r condition.
U must add the Table name and Filednames like
{Tablename.Fieldname}= your conditon value

it will work like Where Tablename.fieldname=yourvalue

Order by u need to set into report itself.

if not understand come to hotmail online [email protected]

i have add u in my massenger and wait

interpoll

have you cleared your doubt?