Only show the max revision # for records that are in D,E,F, or P 1

[willz99ta]

Hi and thanks for your help,

I am not sure how to write this report I was given. I was thinking it could be done with a group selection formula, but I don't understand that part of Crystal well.

I would only like the report to show the records with the maximum "PORevision.PO_Revision" number where the "PORevision.Issue_Meth" IN ["D","E","F","P"]

If the "PORevision.Issue_Meth" was not one of the numbers above, I am trying to have the report show the record where the "PORevision.PO_Revision" number is one less.

Note: I am pulling all of my hair out with this bugger.

Thanks for your help,
Will

 

[lbass]

One less than what?

Please show some sample records and then show what you would want displayed for the same set of records.

-LB

 

[willz99ta]

Currently I am getting this:

Recrd Purchorder.PO_Revision PORevision.PORevision IssMtd
1234 1 0 D
1234 1 1 F

4321 1 0 F
4321 1 1 NULL

What I am looking for is this:

Recrd Purchorder.PO_Revision PORevision.PORevision IssMtd
1234 1 1 F

4321 1 0 F

 

[lbass]

Insert a group on {table.Rcrd} and then create a formula like this:

//{@PORev}:
if isnull({PORevision.IssMtd}) then
{PORevision.PORevision}-1 else
if {PORevision.IssMtd} in ["D","E","F","P"] then
{PORevision.PORevision}

In the group selection formula area, use:

{PORevision.PORevision} = maximum({@PORev},{table.Rcrd})

-LB

 

[willz99ta]

Perfect! I really owe you one LBass. If you are in Fort Worth hit me up for a whiskey+coke sometime.