RE: More on DW data selection

[ssolberg]

RE: More on DW data selection

You are correct but it is easy to get what you want using OR's in your
selections such as: (multiple fields needed in selections)

MYFLD EQ *VALUES 123 124
AND TYPE EQ *VALUES X Y
AND OTHER EQ XYZ
OR MYFLD EQ *VALUES 125 126
AND TYPE EQ *VALUES X Y
AND OTHER EQ XYZ

You have to "duplicate" the other criteria again with an OR in between and
you will now get MYFLD equal to 123, 124, 125, 126 in your report.



Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)

 

[Gary_Gallant]

RE: More on DW data selection

Mike,

You are correct. In order to do what you are explaining you would have the
change the and/or selection to or on the data selection screen. This field can
be found in the fold area (F4) and should be changed on the second occurrence
of the field. So you example would be:

MYFLD EQ *VALUES 123 124
Or MYFLD EQ *VLAUES 125 126

One important thing to remember with the or statement is that you need to
repeat any other pervious data selections. For example:

MYFL1 EQ *VALUES X Y
And MYFLD EQ *VALUES 123 124
Or MYFLD EQ *VLAUES 125 126
And MYFL1 EQ *VALUES X Y

If you left it as

MYFL1 EQ *VALUES X Y
And MYFLD EQ *VALUES 123 124
Or MYFLD EQ *VLAUES 125 126

The MYFL1 selection would only occur on the records with MYFLD equal to 123 or
124.

Gary