can i pass sub query or query as parameter to crystal from VB

[Guest_imported]

I have my dsr file in vb.
Now my query will be in this form.
select * from table1 where table1.field1=(select field1 from table2).
So i dont want to make recordset as it is using lots of memory.
I want to pass it to crystal directly .
Please suggest me how to solve.
I am a new to crystal.So some code example will be of great help

Thanx in advance

 

[lyanch]

Crystal 8.5 and earlier does not directly support what you want to do.

In 8.5 (I missed a couple versions, not sure the first one you can do this in) you can edit the SQL statement to contain what you just wrote. You can only change the where statement, anything else is discarded. Select database, show SQL query and then edit it directly.

If you need an output field that is a nested query you need to use a subreport.

I have not had an opportunity to evaluate Crystal 9.0 but it supposedly supports full control of SQL.

Lisa

 

[Guest_imported]

Hi,
My query will be created dynamically depending upon certain crirterias.So I dont know what will be the exact query.
But there will be some sub query for sure.
When i can make a recordset and pass it to crystal but its taking up huge memory and programs hang.
So i want to pass query directly.
Or some give selectedformula.
Pleas help me

Thanx

 

[lyanch]

I don't believe that you can pass Crystal a query that it normally wouldn't mind having. For this you might want to approach the dataset from a stored procedure perspective?

Lisa