Formula Question???? 1

[MrWilly]

I am looking to create a formula (in Select Expert) that will display records based on a value in a particular field.

For example:
If I have two transaction records in a history table, each one is a distinct record with a different value in the 'type' column (x and y), what is the formula to tell crystal to only display the record with 'x' in the type column (suppress the 'y' record)?

If there is only one record (type = y), this should show.

Can anyone help?

Crystal 8.0, SQL 7.0 database.
Muchos Gracias!

 

[synapsevampire]

Use the record selection criteria (Report->Edit Selection Criteria->Record):

{MyTable.MyType} <> 'Y'

or use:

{MyTable.MyType} = 'X'

The first filters out the Y's, the latter gives you only X's

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[MrWilly]

Thanks for the prompt reply!

Is is possible to create a variable statement that will check for a 'Y' record and if it does not find one - it will display the 'X' record?
But, if it does find one, it will supress the 'X' record and only display the 'Y'.

 

[synapsevampire]

Sure:

An easy way is to sort on the value field, now place something like this in the suppress of the value field:

If next({whatever uniquely qualifies these 2 records as a set}) = {whatever uniquely qualifies these 2 records as a set}
and
next({value}) = &quot;Y&quot;

This will check the next record for the value of Y and suppress the X it if it exists, otherwise it will show Y because the suppression formula won't work on the 'Y'.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

just to qualify what SV has said....this is not done in the Record Select...rather you would process this formula in a section of the report

The reason for this is that Crystal doesn't know what the next record is until all of the data has been brought in. Jim Broadbent

 

[MrWilly]

Thanks! I really appreciate the help!

But...

I am having trouble entering the formaula SV provided in the Suppress(No Drill Down) formula screen on the Section Expert of the Details section.

I have entered the following:

if next ({tblxxxReference}) = {tblxxxReference}
and
next ({tblxxxType}) = 'X'

Error check is telling me I need a 'then' statement after the 'X'.

Please let me know if I'm way off here....

Many thanks!

 

[Naith]

Remove the 'If' from SynapseVampire's formula.

 

[MrWilly]

ah geez. thanks!

 

[dgillz]

As Naith said removing the &quot;if&quot; is the answer. These types of formulas are booleans, they must evalaute to either true or false. In your case it will suppress the fields if the formula evalautes to true. With an &quot;If&quot; at the begining of the formula, it does not evaluate to anything, hence the error. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[synapsevampire]

Ooops, sorry about the if, I should have tested...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com