INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Conditional Row Suppression

Conditional Row Suppression

(OP)
Appreciate any ideas or guidance.
I want to conditionally suppress rows based on current record compared to previous or next record. Whatever is easiest. Explored several write-ups using next and previous and can't seem to get this working.
My sample data is attached.
I have 2 columns, server and application
in some conditions, my server does not have an application.
in other conditions, i have multiple entries and i wish to remove the entry where there is blank row for the application where there is a 2nd or 3rd rows showing a unique application.

I do not want to blank out all rows that do not carry an application. Only those that the server name repeats itself and the first row for the application is blank.

Thank you in advance for suggestions.

RE: Conditional Row Suppression

Create a formula field

@Server&App
{serverfield}&" "& if isnull{applicationfield}then "" else {applicationfield}

Group on @Server&App
(suppress detail)
to get a list of all the servers and the applications, inc server if no application
There's more than one way but if you just want a big list of unique values quickly, this will do it.

RE: Conditional Row Suppression

smmedeiros:

Did NickieP's help? If so, it is polite to acknowledge the poster's assistance (the Great Post purple star is a good way to do so), and also helps others to know if the proposed solution worked or not. Failure to at least acknowledge and thank those trying to help may result in them deciding not to assist you in the future.

If it didn't work or didn't provide the result you were looking for an explanation might mean someone else can help you.

RE: Conditional Row Suppression

(OP)
Thank you for the nudge pmax9999 - unfortunately, I was redirected on a different priority and have not had a chance to try the suggested solution. When I do, I will update accordingly.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close