I have a report that I need to suppress a field that does not print a specific variable. Let me try to explain. in my report in Group Header 2 i have initials of a user and the report compares a few code numbers and if they don't match I print Verify on the form for that specific clients initials in the Group 2 header. I have tried all combinations of suppression and I either get all initials or none regardless of the variable "Verify"

So what I want is if the report does not show verify (meaning codes match) then suppress the initials on the header, if the report prints Verify then show the initials in group header. When I use this in the suppress formula {@Verify-code} <> "Verify" I get no initials in the header if I use {@Verify-code} = "Verify" I get everyone's initials and most are blank pages because I only show the pages that have Verify. FYI I separate the pages so that only one Client initial is on a page... I hope I explained this well enough, I have been working this issue for a few days and cannot get it.
Example

DTM 5/27/14
8:30
Code 12345 service 134556   Verify
9:00
Code 12345 Service 12345     "" (this I suppress because no verify)
10:00
Code 12345 service 134556   Verify

---New Page-- These pages (initials) should not show because there is no verify this is where the problem lies how can I suppress these blank pages?
JEM

TGM

EMG

TAM
8:30
Code 12345 service 134556   Verify
9:00
Code 12345 Service 12345     "" (this I suppress because   no verify)
10:00
Code 12345 service 134556   Verify

Edited by musicman - 28 May 2014 at 3:49am

Thanks for the fast reply DBlank. I edited my original post. My verify code is just if statements to compare 2 codes which that works perfectly. When the codes don't match I print Verify on the report. so what I want is if the report does not have Verify for one of the user initials suppress all data which it does but it still puts the initails on the top of the page, this is what I need to suppress is the initials in Group header 2 depending on the field (@verify) in the details. is Crystal hierarchical meaning I cannot suppress something in the header in relationship to a field in the details?

Well sort of, I think :) but opposite if 1 of the details don't match I print verify (I want to show this) but for all the columns for that specific users initials have no Verify or the codes match I want to suppress that users initials I think what is happening when i put my suppress code in is that it evaluates True all the time regardless if I print Verify or not. if I use {@Verify-code} <> "Verify" (which is the text of a field I put on the form) I get no initials in the header (that means it is evaluating True all the time regardless of the @Verify-Code") if I use {@Verify-code} = "Verify" I get everyone's initials so it is evaluating false. Can I actually key off of a field by what is in the textbox? as you can tell i'm new to this. I am a VB and .Net developer but got placed on the Crystal project...

your evaluation is only looking at the first row of the group.

Thanks DBlank I took your advise to have a flag field and still no joy. What I did is use a running total and summarized on the @Verify-Code variable using a distinct Type Summary and I Evaluate for each record and reset on the change on Group ID (initials) which is great as the total changes with every different initial this gives me a count of either 1 or 2 so my suppress formula is {#RTotal3}= 1 (which I get a 1 if there is no Verify displayed on the page) so one would think it should suppress the initials but it still suppresses all the initials in that field regardless of the RTotal. I have tried {#RTotal3}<=1 also with no joy any help would be appreciated not sure why Crystal Reports has to be so difficult. Basically all I want is IF the Page has even 1 row with the word Verify show the initials of the user if the data for that users page does not have the word Verify on it then suppress the initials. I have it working for the data on the page so if there is a verify on the page then it is blank but for some reason trying to suppress the group header with the initials just wont work either is suppresses all or none. very frustrating but thanks again for your help on this...