Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Case on a Formula field not returning all expected entries

Status
Not open for further replies.

auylox

Technical User
Feb 7, 2007
20
CA
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
 
Please disregard. I resolved it by reversing the links between two of my tables.

K
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top