finding 2940 versus 2,940 in crystal report 2008

hi experts,
im using CR 2008 and i would like to search for the value 2940. in my report, i have the following records:

  1. 2940 - as order id, data type: number (2 records)
  2. $2,940 - as order amount, data type: currency (10 records)

from the Find function in Preview Panel in CR, search scenarios are as follow:

  1. search for 2940 - return only 2 records
  2. search for 2,940 - return only 10 records

is there a way for me to get the 12 records even when i search for 2940?

hope someone will be able to help.
thanks


ccool2000 :malaysia: (BOB member since 2008-12-09)

hi,

i would like to ask how to did you get the total number of records using the find function under CRystal Report?


nahtanoj :philippines: (BOB member since 2009-07-08)

hi there,
yes i found the search result which i mentioned as follow from the previous post.

from the Find function in Preview Panel in CR, search scenarios are as follow:

  1. search for 2940 - return only 2 records
  2. search for 2,940 - return only 10 records

any luck? thanks


ccool2000 :malaysia: (BOB member since 2008-12-09)