grouping when results with blank

[sameer11]

using cr 8.5 ver

I have 2 groups and 1st group is based on a formula as

@Ref Group 1

if {tab.field1} = ' ' or {tab.field1} = '' then
' No Values' // space, so it is placed as first group value
else
{tab.field1}

{tab.field2} group 2

I have to display the report and then prin the number of count {tab.field2} for each value of group1

when ' No Value' for group 1 Iam unable to print the Group footer with the count of group2 values. Though it does the count for other values in group1.

How can I display the count of group2 for group1 when the result is ' No value' and why does this happen.

Any help is greatly appericated.

Thanks
Sameer

 

[sameer11]

Any advices please....

Ex of how the report should look

department :No Values //GH
emp id: 1

emp id :2

emp id :3

Number of id's for No value : 3 //GF


Department : Issues
emp id 12
details
empid 4
details
Number of id's for Issues : 2

Thanks,

 

[sameer11]

Thanks, I figured. I wass using some suppressing logic and total forgot about it.

 

[BobSuruncle]

If there's no data, Crystal can't create groups on it.

The only way it could work is if your data is like this:

Dept Emp SomeField
1 1 Blah
1 2 Blah Blah
1 3 Blah Blah Blah
1 yada
2 yada yada
3 yada yada yada


Bob Suruncle

 

[synapsevampire]

I think that's too many yadas, Bob, it couldn't possibly work

I gather that "Thanks, I figured. I wass using some suppressing logic and total forgot about it." means that you figured it out.

Showing how a report should look but not the data to support it leaves too much to the imagination.

And this "How can I display the count of group2 for group1 when the result is ' No value' and why does this happen." just doesn't make sense.

Group2 for Group1???

Group1 isn't a part of group2, so one doesn't show in the other, if that's what you mean.

-k