Member Avatar for mono_jit23

How can I use 'like' keyword with wildcard characters(*) in RecordSelectionFormula of crystal report?

rptdoc = new ReportDocument();
rptdoc.RecordSelectionFormula = " {View1.RefNo}= '" + textbox1.Text + "'";

I need to use 'like' instead of '=' .....

  • 2 Contributors
  • 3 Replies
  • 95 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by finito
Member Avatar for finito 
rptdoc.RecordSelectionFormula = " {View1.RefNo} LIKE '%" + textbox1.Text + "%'";

Added the following three things: LIKE % %

Edited by finito because: n/a
Member Avatar for mono_jit23

I was using Access and it takes * instead of %.....Thanx 4 ur iniative.....:)

Member Avatar for finito

Np Peace

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.