Hi, I'm using Crystal Reports 2008. Have problem with grouping the data by name. The problem is next:

For example let say that I have this returned from command that I have generated in Database Expert.

date      | id | Name (can be null)
---------------------------------
3/20/2010 | 1 | null
3/21/2010 | 2 | A
3/21/2010 | 3 | B
3/22/2010 | 4 | null

Report should be in group by name, showing for each date in the range 20~22

A
------
3/20/2010 | 1
3/21/2010 | 2
3/22/2010 | 4

B
-----
3/20/2010 | 1
3/21/2010 | 3
3/22/2010 | 4

I don't have idea how to group them for the range when Name is null. Will appreciate if someone give me a hint.

Edited by kirildzolev - 26 Mar 2010 at 3:22am

Thanks for your replay.

As it is now, yes I get the null values in separate group and it shouldn't be like that. I don't need group which contain the null values.

I think I describe the problem badly.
Groups are by name and in every group there is a range date from-to. In every group(Name) I need this range from-to.
So, even if there is no name on 3/20/2010 and 3/22/2010, this rows will appear in both group A & B

This report is for attendance for employee in/out. If nobody has been on that date then it is NULL value.

For each employee there is same range of dates from/to with value(hours) if he was in or null if he hasn't

So even if on date 20th A has been and B not, both dates should appear on groups but for A there will be value and for B there will be null.

- How do I exclude the NULLS

Sorry if I ask basic questions, I am new at this