wildcard
(Thursday, December 23, 2004)
Found the following interesting discussion in the Newsgroups:
wildcard
by:Anonymous
| 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
| | | Reply:
by: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
| | | Reply:
by:Anonymous
| | | 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
|
Posted by Xander Zelders
 
|
0 Comments:
Post a Comment
<< Home