Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Row Suppression

Status
Not open for further replies.

smmedeiros

Technical User
Feb 21, 2008
74
US
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.
 
 http://files.engineering.com/getfile.aspx?folder=6ebf1bbe-a0a3-42a8-82a4-eb70d5bad329&file=TekTipSample.xlsx
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.
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top