Filtering out Data (1 Viewer)

[babypink2807]

Hi all

I am so new to Crytal Reports if I were a chicken I would be alittle yellow chick (sorry)

I have created a report as follows (yes I know its simple but tok me ages!)

if{STOCK.CURRDEPOT}="01" then "Normanton" else
if{STOCK.CURRDEPOT}="02" then "Warrington" else
if{STOCK.CURRDEPOT}="04" then "Port Talbot" else
if{STOCK.CURRDEPOT}="05" then "Durham" else
if{STOCK.CURRDEPOT}="06" then "Konstructa" else
if{STOCK.CURRDEPOT}="07" then "AW Blake" else
if{STOCK.CURRDEPOT}="08" then "Hitchin" else
if{STOCK.CURRDEPOT}="10" then "Atlas CopCo" else
if{STOCK.CURRDEPOT}="12" then "Mobile Freezers" else
if{STOCK.CURRDEPOT}="14" then "ATR Aberdeen" else
if{STOCK.CURRDEPOT}="17" then "Toveys" else
if{STOCK.CURRDEPOT}="19" then "KDM Hire Ireland" else
if{STOCK.CURRDEPOT}="20" then "Torlundy" else
if{STOCK.CURRDEPOT}="21" then "Hill Top Farm" else
if{STOCK.CURRDEPOT}="22" then "Gibsons of Kendal" else
if{STOCK.CURRDEPOT}="23" then "Glasgow" else
"No Depot"

This runs all stock and all I want it to show is the items that fall into certain Product Groups, the field for that is PGROUP and put the following on

{STOCK.PGROUP}="0100" OR
{STOCK.PGROUP}="0600"

Of course its still running the whole stock list, please help its driving me nuts!

Thanks

 

[kevlray]

I am assuming that the first formula was just for displaying the values in a more human format.

The second formula (from what I understand) is your selection formula.

But you say your are still getting records that are not part of the selection formula?