Saturday, May 2, 2009

CRYSTAL REPORT INSTR() FUNCTION

Many Novice/Professional users face a common error "A boolean is required here" while using Instr() Function in Crystal Report. They try to give true /false or 0/1 value. But still failed in getting the desired result.

Instr() Function take the Index if it find the given text in the defined string. So the simple solution of the problem is

if Instr(string from where to search , string that is searched) > 0 then
"Type the message if the search is successfull"
else
"Type the message if the search is Unsucessfull"

I hope that you will understand it this time and after then in entire your life you will not forget it.

No comments: