How to passing a recordset value as query in crystal?

[Vincentan]

I using ADODB and recordset and I facing a problem in crystal selection fomula and any expertise kindly please correct and advice my error!

Dim ItemNoFrom as string, ItemNoTo as string
ItemNoFrom = "ABC001"
ItemNoTo = "ABC100"
crReport.action = 0
crReport.selectionformula = &quot;Select * from tblDB where itemno >= '&quot; & ItemNoFrom & &quot;' and itemno <= '&quot; & ItemNoTo & &quot;'&quot;

It occur error for &quot;... the remaining text is not part of SQL .... &quot;

I try before in

crReport.SQLQuery = &quot;Select * from tblDB where itemno >= '&quot; & ItemNoFrom & &quot;' and itemno <= '&quot; & ItemNoTo & &quot;'&quot;

But it return me wrong data. Any body kindly please help.

 

[synapsevampire]

You may want to add more information, such as versions and software used.

The selectionformula is not used for passing SQL:

http://msdn.microsoft.com/library/d...wsformscrystalreportviewerpropertiestopic.asp

Consider using TTX files, here's an example:

http://beta.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_10379116.html

-k