like, wildcard, vb .net 2002 windows, crystal 9

[hsandwick]

vb windows .net 2002
crystal reports 9

Record selection formula works fine for currency string result, good for operators =/>= and so on, as follows:
vb form

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SelectFormula As String
Dim myCrystalReportViewer = CrystalReportViewer1
SelectFormula = "{CLIN_FUND.FUND_AMT} > " & TextBox1().Text
CrystalReportViewer1.SelectionFormula = SelectFormula
.....etc

crystal select formula ...
{CLIN_FUND.FUND_AMT} > 500.00;
==========

Now, I'm using a string for a description, and as long as it equals what's in the textbox (= or LIKE), it's fine. But I need to use a wildcard to pull in all results that would contain what the user types in the textbox and it's not working.

vb form

SelectFormula = "{LINE_ITEM.CLIN_DESC} LIKE '" & TextBox1().Text & "'"
CrystalReportViewer1.SelectionFormula = SelectFormula

crystal formula
{LINE_ITEM.CLIN_DESC} LIKE "%%";

I tried inserting a wildcard % in the vb statement, but no luck.

How do I pull in all results that include the user's input in the textbox, please?

Many thanks.

-H

 

[dtempleton]

Try this:

SelectFormula = "{LINE_ITEM.CLIN_DESC} LIKE '*" & TextBox1().Text & "*'"

 

[hsandwick]

That did it! Tks, dtempleton, SO MUCH.
-H

 

[dtempleton]

Very welcome