crystal report parameters

[irlbinky]

Hi
I need help - preferably in code form as how I can pass the parameters to a Crystal Report Query (below) from text boxes in a form.
SELECT * FROM $ACCOUNT_TREELIST$$(1,0,NULL,(?param1), (?param))

Both paramaters are numbers.

Any help would be appreciated.
Thank
Cathal

 

[zemp]

Here is the basic syntax you will need to place the text box values into your SQL statement as numbers.

SELECT * FROM $ACCOUNT_TREELIST$$(1,0,NULL,(" & val(form1.text1.text) & &quot, (" & val(form1.text2.text) & &quot)"
Thanks and Good Luck!

zemp