Data that Does not fit a Group

[gazza11]

I am using groups to display specific records but there are some records that are not in any group. These records just appear without any "Group Name" at the top of the report.
Is it possible to stop these from appearing? If so can you please advise me how I go about doing it. I am relatively new to Crystal but learning fast.

 

[Transcend]

Hi there

the reason this is happening is because you are grouping on a field right? Obviously the records appearing at the top in no group have no data for the group.

For example, if you are grouping on a description field, the records in the table that do not have anything in that field will not be in any groups.

So you need to either

1)make sure all records have data in that field
or
2)group on a field for which ALL records have information

Transcend

 

[BarbaraFuhrmann]

If you want to omit the records, that have no data in the field you group on, you can subpress it by formatting the section under condition isnull({data_field}).

Good luck
Barbara

 

[gazza11]

Thanks Barbara - yes I need to omit the records. I can see how your formula works - mine is slightly different. Each employees record (in Employee Table) has a CompID field which relates to another Table (Company)that contains CompID and Company. I am Grouping on the Employee Table, CompID but under Group options in "Change Group Option", I have checked customise group name field and then selected Company.company. Employees that are not allocated a company have "0" (zero) in the Employee.CompID field.

I tried modifying your formula to ({employee.CompID})=0, but did not work. Can you advise exactly where I need to go to enter this formula. I was selecting the Group Header field - right clicking and format field. Then entering formula opposite 'Suppress". This appears to be incorrect.

Please help.

 

[CrystalVis]

You can try something like

isnull{Employee.CompId} or {Employee.CompId} = ''

What about the linking between the Employee and Company tables? Are they equal join?