wildcard

[Helen]

vb windows .net 200
crystal reports

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

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Clic
Dim SelectFormula As Strin
Dim myCrystalReportViewer = CrystalReportViewer
SelectFormula = "{CLIN_FUND.FUND_AMT} > " & TextBox1().Tex
CrystalReportViewer1.SelectionFormula = SelectFormul
......et

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 for

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

crystal formul
{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

-

[Bernie Yaeger]

Hi Helen,

Here's the syntax as it should appear inside crystal:

{prod.bipad} like "187". If the user enters 'an' against a list of names,
this will return nancy, danny, but not bernie and not helen.

HTH,

Bernie Yaeger

"Helen" <an*******@discussions.microsoft.com> wrote in message
news:01**********************************@microsof t.com...

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

[Helen]

Thank you, Bernie. I even got it to work with your scenario, but with a wildcard instead, such as {prod.bipad} like "%%", so it's up and running now and lookin' good. Working for text strings, and multiple fields from multiple tables, but not yet working for string containing numericals. I have a separate posting for this question. Hope to resolve v. soon.
-H