Hello everybody,
I have four search criteria in my report.
I want to use 'like' clause at run time from vb6.
The report goes like this.
It has cash receipts(cr1,cr2..), bank receipts(br1,br2...) and cash payments(cp1,cp2....).The field is a string type.
I used the following:
cr.selectionformula="{table.fieldname} like 'cr*'"
but that doesnt work.
the same thing when i worked directly from report it worked. But in vb it gives error in selection formula.
Help.
thank you.
I have four search criteria in my report.
I want to use 'like' clause at run time from vb6.
The report goes like this.
It has cash receipts(cr1,cr2..), bank receipts(br1,br2...) and cash payments(cp1,cp2....).The field is a string type.
I used the following:
cr.selectionformula="{table.fieldname} like 'cr*'"
but that doesnt work.
the same thing when i worked directly from report it worked. But in vb it gives error in selection formula.
Help.
thank you.