Problem with crystal report control

Hi,
Iam developing a package using vb6,crystal reports 9,and oracle 8.
I placed crystal report control on MDI form and named it as CRP.
but in the properties of CRP iam not getting " .SQLQuery " property
i.e CRP.SQLQuery why it is happening..i need help
thanks in advance

the sample code is
MDI_DCT.CRP.Connect = "dns=dct;UID=DCT;PWD=dcttre"
MDI_DCT.CRP.ReportFileName = "c:\program files\DCT\Daybook_report_DUP.RPT"
MDI_DCT.CRP.Action = 1

in the above code if i tryed to select the property MDI_DCT.CRP.SQLQuery is not visible

Welcome to the forums. :wave:

Do you have it on the parent MDI form?

Are you able to get the other property without any issues? Is your tool has valid working license? Can you able to sent the sample code that you used in your application?

Quote:

---

I placed crystal report control on MDI form and named it as CRP.

---

Thats strange! Iam not able to do it. :confused:

I believe .SQLQueryString is option for reference to Report Report.SQLQueryString
Add a reference to CRAXDDRT.dll (usually found in C:\Program Files\Common Files\Crystal Decisions\2.0\bin) and add the following in declarations

Code:

---

Dim appln As New CRAXDDRT.Application
Dim Report As New CRAXDDRT.Report

---

Now type Report. in the Form load event you should find the sqlQueryString pop up
The CR control has a ReportSource property to which is passed the Report object

Code:

---

CRP.ReportSource = Report

---

By the way why do you want to put it in MDI. You should consider putting it in a ordinary form. Are other options available in the intellisense (popup) or you have typed them.