Results 1 to 5 of 5

Thread: [RESOLVED] [2005] Crystal Report "like" Statement passing.

Threaded View

  1. Apr 24th, 2007, 01:30 PM #1
    smilbuta
    smilbuta is offline

    Thread Starter
    Lively Member smilbuta's Avatar
    Join Date
    Apr 2005
    Location
    Orlando
    Posts
    104

    Resolved [RESOLVED] [2005] Crystal Report "like" Statement passing.

    Hello , community.

    Im having an ussue with crystal reports. and VB.net.

    Im trying to pass a selection formula:

    Code:
      CrystalReportViewer1.SelectionFormula = "{EQ_Equipment.equipment_cf_tag} like '73'"
    This fails to return any rows.

    but if i use the following

    Code:
      CrystalReportViewer1.SelectionFormula = "{EQ_Equipment.equipment_cf_tag} = '73'"
    I get the correct line of data...

    What am i doing wrong???
    EDIT: I just discoverd something odd... I created a record withthe number 1173

    If i do a like Search on 1173 it finds the record... if i do alike searc on just 73 it returns no record.. WHAT?...
    Last edited by smilbuta; Apr 24th, 2007 at 01:42 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width