Skip to Content
avatar image
Former Member

remove of these parameter line lets in data but not separate it.

This part of a long record select is solving one issue. Before not all negative qty locations were being displayed. but not if the user want to see specific locations as entered in parameters its' not showing only that but all.

{ICLOC1.LMLTPC} = {?Location Type} or {ICLOC1_1.LMLTPC} = {?Location Type}) and

((

{ACBALMPK.IRLOC3} <> "" and

{ACBALMPK.IRLOC2} <> "" and

{ACBALMPK.IRLOC1} <> "") or (

{ACBALMPK.IELOC3} <> "" and

{ACBALMPK.IELOC2} <> "" and

{ACBALMPK.IELOC1} <> "")) and

-- here is the full RS.

(IF {?Lev_Pos} = "ALL" then

    1=1

else

    {ICLOC1.LMLOC3} = {?Lev_Pos} OR {ICLOC1_1.LMLOC3} = {?Lev_Pos}) and

(IF {?Bay} = "ALL" then

    1=1

else

    {ICLOC1.LMLOC2} = {?Bay} OR {ICLOC1_1.LMLOC2} = {?Bay}) and

(IF ({?Warehouse}) = "blank" then

    {ICLOC1.LMWHS#} = "" OR {ICLOC1_1.LMWHS#} = ""

else

    {ICLOC1.LMWHS#} = "CRW" OR {ICLOC1_1.LMWHS#} = "CRW") and

{ICLOC1_1.LMCOM#} = "001" and

{ICLOC1.LMCOM#} = "001" and

(IF {?Assembly Items} = "ALL" then

    1=1

else

    (IF {?Assembly Items} = "yes" then

        ({ICPRT1.IABMU} = "1" or {ICPRT1_1.IABMU} = "1")

    ELSE

        ({ICPRT1.IABMU} <> "1" or {ICPRT1_1.IABMU} <> "1"))) and

(IF {?Inventory Items} = "ALL" then

    1=1

else

    (IF {?Inventory Items} = "inventory items" then

        TRIM({ICPRT1.IARCC6}) = "INV" OR TRIM({ICPRT1_1.IARCC6}) = "INV"

     ELSE

        TRIM({ICPRT1.IARCC6}) = "" OR TRIM({ICPRT1.IARCC6}) = "")) and

(IF {?Inactive Location} = "ALL" then

    1=1

else

    {ICLOC1.LMACTF} = Left({?Inactive Location},1) OR {ICLOC1_1.LMACTF} = Left({?Inactive Location},1)) and

(Select {?Quantity}

    CASE "ALL":

        1=1

    CASE "Negative":

        ({ACBALMPK.IRQOH#}<0) OR ({ACBALMPK.IEQOH#}<0)

    CASE "0":

        ({ACBALMPK.IRQOH#}=0) and ({ACBALMPK.IEQOH#}=0)

    CASE "Greater than Zero":

        ({ACBALMPK.IRQOH#}>0;) OR ({ACBALMPK.IEQOH#}>0;)) and

(IF {?Item} = "ALL" then

    1=1

else

    {ACBALMPK.IRPRT#} = {?Item} or {ACBALMPK.IEPRT#} = {?Item}) and

(IF {?Location Type} = "ALL" then

    1=1

else IF {?Location Type} = "RAK" then

    {ICLOC1.LMLTPC} = {?Location Type} and {ICLOC1_1.LMLTPC} = {?Location Type}

else

    {ICLOC1.LMLTPC} = {?Location Type} or {ICLOC1_1.LMLTPC} = {?Location Type}) and

((

{ACBALMPK.IRLOC3} <> "" and

{ACBALMPK.IRLOC2} <> "" and

{ACBALMPK.IRLOC1} <> "") or (

{ACBALMPK.IELOC3} <> "" and

{ACBALMPK.IELOC2} <> "" and

{ACBALMPK.IELOC1} <> "")) and

(IF {?Available for Sale} = "ALL" then

    1=1

else

    {@strAS} = {@STRASfirst}) and

(IF {?Available for Purchase} = "ALL" then

    1=1

else

    {@strAP} = {@STRAPfirst}) and

(IF {?Aisle} = "ALL" then

    1=1

else

    {ICLOC1.LMLOC1} = {?Aisle} or {ICLOC1_1.LMLOC1} = {?Aisle})

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 05, 2015 at 09:42 PM

    Hi Paul,

    One thing to be aware of is CR considers null values as valid field data so you may need to add logic to test for nulls using IF isnull()

    Refer to the CR help file ( F1 key ) on testing for nulls.

    And your explanation is not very clear...

    Don

    Add comment
    10|10000 characters needed characters exceeded