Report Datasource is SQL server. I want to Hide/supress the header and footer of a group if the data field value that group is based on is a certain value is met. I am trying this in the section expert and if i try the test the GroupName ({dbfield}) or if i used a share variable from the details line I get an invalid group condition. I it impossible to conditionally supress a group header/footer?

I select the field from the list. I have tried both database and report fields and I get the error The field name is not known

The field is numeric so I have {SIT_TLM.TLM_JLM_NO}=0

Thank You, you are absolutely righ, it does work. I just cant get it to work in the report designer of Visual Basic . NET 2008. but in CR XI work flawlessly. It is either a Microsoft n e u t e r ed feature or a bug in Crystal, where if you add a field to a report it is not seen by function editor. I will try it again in MS VB by creating a new report and see if it works.