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

[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

[cutamacious]

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

[buddu]

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

for problem 2 :
as cutamacious posted.

[interpoll]

when i tried the report show all the recordsets

and i want to show the query recordsets

interpoll

can input the full code??

[buddu]

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]

[interpoll]

i have add u in my massenger and wait

interpoll

[buddu]

have you cleared your doubt?