Showing a field that does not belong in my group?

[ibn2VB]

In my database I have a field lets say for rejects.
I created a Group based on my reject field.
My Group should only show data from my rejected records.
I keep getting a field to show up in the reject Group
that has no reject data in the reject field.

I hope I was able to explain this problem in a clear way.

Thanks

 

[SmpTraining]

You have not told Crystal to select only records where there is 'reject' data. You have simply told Crystal to group records with the same 'reject' data together and that includes missing reject data.

You need to add a line to the select expert to tell crystal to ignore records without reject information. Exactly how you do this will depend on whether the reject field is blank or NULL when empty.

Try each of these selections in turn....

A) reject field <> &quot;&quot;
B) not isnull(reject field)

...one should work! Steve Phillips, Crystal Consultant

 

[ibn2VB]

After responding to the prior code suggestion.
I have tried this and my database has many reports,
once I insert this code---My reports that have no
rejects no longer are viewable.
The one thing I did notice is that the unwanted field
happen to always be in the first record of the report.