Select Case

[klaidlaw]

I am using Crystal Reports 11 Release 2

I want order lines 10, 11 ,12 to be exculded form the report when the sales order 11059 comes up I wasn't sure if anyone could help me. Thanks

 

[Turkbear]

Hi,
Can you identify which lines (records) are 10,11,12?

If it is a numeric value in a field then this should work as a record selection formula:

If {Tablename.SalesOrderField} = '11059'
 then
Not {Tablename.LineNumberField} in (10,11,12)
Else
True

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[CoSpringsGuy]

do you want other values associated with records contain those line numbers or do you want them completely not included?

you could either use a record selection as indicated by Turk or suppress them in the section expert so that values can be used for other functions if needed.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection