I had been using code written by one of the members here.
(
if {?par} <> "ALL" then
{t.CODEID} = {?param}
else
if {?par} = "ALL" then
true
)
I had modified it and it worked all the time until now when I am facing an issue as follows:
Sample Data:
CODEID CODETYPE
A 3
B 3
C 3
A 1
B 1
C 1
A 4
B 4
I need to say if CODETYPE = ALL - give me everything as shown above in sample data.
If CODETYPE = 3 - give me only following.
CODEID CODETYPE
A 3
B 3
C 3
I am stuck. Please, push me in a right direction. Thanks
(
if {?par} <> "ALL" then
{t.CODEID} = {?param}
else
if {?par} = "ALL" then
true
)
I had modified it and it worked all the time until now when I am facing an issue as follows:
Sample Data:
CODEID CODETYPE
A 3
B 3
C 3
A 1
B 1
C 1
A 4
B 4
I need to say if CODETYPE = ALL - give me everything as shown above in sample data.
If CODETYPE = 3 - give me only following.
CODEID CODETYPE
A 3
B 3
C 3
I am stuck. Please, push me in a right direction. Thanks