Using LIKE abc% in crystal report

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts