Suppress on Break of a group

[byteias]

CR XI under Oracle 9i.
I need to suppress a subgroup total when subgroup total is equal to group total.
ex. We have Groups that contains only one subgroup and I want to eliminate printing of the subgroup.
Thanks,
Ivan.

 

[lbass]

You could suppress the subgroup section in the section expert by selecting the section->suppress->x+2 and entering:

distinctcount({table.subgroup},{table.higherordergroup}) = 1

-LB

 

[byteias]

I got an error by using distinctcount({table.subgroup},{table.higherordergroup}) = 1. Therefore, by doing the suppress when {table.subgroup}={table.higherordergroup}
it works.
Thanks for your advice.
Ivan.

 

[lbass]

You shouldn't have gotten an error unless you didn't have a group on the higher order group. What was the error message?

-LB

 

[byteias]

lbass,
pointing to my first group:
"This field cannot be summarized"
Thanks.

 

[lbass]

But if you can group on it, you can summarize it. What was the exact formula you used?

-LB

 

[byteias]

distinctcount(GroupName ({XCR_GET_JOB_PLAN.GROUP_NAME},GroupName {XCR_GET_JOB_PLAN.GRP_NAME}) = 1

 

[lbass]

That should have been:

distinctcount({XCR_GET_JOB_PLAN.GROUP_NAME},{XCR_GET_JOB_PLAN.GRP_NAME}) = 1

I have never found a use for the groupname in a formula, and it doesn't belong in this one either...

-LB

 

[byteias]

Thanks..............