Select Case on a Formula field not returning all expected entries

[auylox]

Hello,

CR 2008
Oracle 11
Windows 7

I'm having problems with a selection formula not returning all of the entries I expect when I select based upon a formula field. Using the folowing selection formula:

{VW_CATALOGUE.ID_NUMBER} like {?Data}

where {?Data}= "2956/201*" returns three lines: "2956/201 a", "2956/201 b-d", and "2956/201 e-f".

Using a selection formula that includes a formula field:

{@Parameter} like {?Data}

where {@Parameter}is defined by:
Select {?Parameter}
case "By ID Number": {VW_CATALOGUE.ID_NUMBER}
case "By Location": {VW_CATALOGUE.LOCATION}
case "By Group Name": {VW_GROUPS.GROUP_NAME}

and {?Parameter}="By ID Number"
and {?Data}="2956/210*"

returns only 2 lines: "2956/201 a" and "2956/201 b-d".

Please let me know if you need any more information, and thanks for any help you can provide.

K

 

[auylox]

Please disregard. I resolved it by reversing the links between two of my tables.

K