Group header doesn't always display

[llarose]

I have a report that the group header doesn't always display. This is a packing slip that is grouped by container ID. The problem is that when there is only one carton id it does not display, if there is more than one carton id then they all display. I think that I know why but don't know how to fix it.
In the case of the one carton id. The record that contains the carton id is otherwise blank like a summary record and all the other records contain the item information belonging to the summary record.
If each item is tied to a container than they print correctly. I have tried to create two summary lines to get the container id to print but it never does display - always blank.

 

[Madawc]

If your table has a mix of summary records and detail records, then I suggest you add the table twice, the second time as an alias. Then link. This should mean that each detail line has a carton ID.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

What do you WANT to display when there is no container ID?

Create a formula like this:

if isnull({table.containerID}) then
{table.cartonID} else //or whatever field should display
{table.containerID}

Group on this formula.

-LB

 

[llarose]

I found out what the problem was - it uses XML also which I was not aware of or trained in. I was trying to do it all through Crystal and sql. There are internal sorts being done that I could not see.

Thanks for responding to my cry for help. It is much more complicated for this newby crystal report writer.