Conditional Suppression of details section 2

[BreffniK]

Hello and thanks for taking the time to read my question.

Backround:
I am developing a multiple record report that will return 1 or 2 rows per every Domain Name (unique identifier). All of the information in each row returned will be identical with the exception of the Status field. The value for the Status field will always be set equal to 'Required' or 'Completed'.

Question:

How may I conditionally suppress the row where Status = 'Required' only if the exact same row exists with Status = 'Completed'? If just one or the other exist, I do not want to suppress either.

Any help or advice would be greatly appreciated!

Thanks!

 

[synapsevampire]

Group by the Domain.

Sort by the Status and then use something like the following in the Right click the section and select format section->X 2 next to suppress:

previous({table.domain}) = {table.domain}

That way if there's more than one of any domain it will take the first, and since C comes before R, it will suppress and Required when there's a Completed.

Another means might be to use a Group Selection Formula which contains:

{table.status} = minimum({table.status},{table.domain})

-k

 

[synapsevampire]

I should further qualify that if you use the Group Selection means, the rows won't be returned to the report, so no suppression is required.

-k

 

[hilfy]

Use something like the following in the suppression:

{table.field1} = Next({table.field1}) and
{table.field2} = Next({table.field2}) and...
for each field except the status. This is assuming that the "Completed" record comes after the "Required" record. If it's the other way around, use Previous() instead of Next().

-D