Using LIKE abc% in crystal report

Posted by Thiru under Others on 8/27/2012 | Points: 10 | Views : 1416 | Status : [Member] | Replies : 2
Hi Friends,

If any one knows how to use abc% in crystal report parameter

example:
objrpt.SetParameterValue("vBCDE", "%" & cmbBranch.Text)

it means: parameter value "vBCDE" LIKE %ABC
i.e.: as in sql query: select * from tablename where vBCDE LIKE '%ABC'
which should give all record ending with ABC in vBCDE column in sepecified tablename

expecting your valuable reply.




Responses

Posted by: Sandeepkasar on: 8/27/2012 [Member] Starter | Points: 25

Up
0
Down
rather than using it in crystal reports you can send a param to the stored proc and use like there

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Thiru on: 8/28/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Sandeepkasar,
Thanks for your reply.
I understand that we can filter the required search string in stored procedure and pass the
same to crystal report parameter's

But i like to do diretly in crystal report parameter.

expecting your valuable reply.

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response