Grouping data in report

[kveni]

I need to group the data in two based on a condition. ie., I want to group all the parents who have less than 3 children in X group and parents who have 3 or more in group Y ?? How do I do this?

 

[skrandel]

You really can't do this at the report level. This sort of activity should happen at the query level. You likely need a union query and a couple of subqueries.

Steve Krandel
VERITAS Software

 

[kveni]

Can we do it at the universe level?

I need to display both the X and y grps of data under one column grp.

 

[skrandel]

Without seeing your database, it's very hard to see.

You could define an object called GROUPING
CASE
When Children < 3 then "X"
else "Y"
end

This is how I "bucket" data. You just can't use this method if you have to aggregate before you group.

Steve Krandel
VERITAS Software

 

[sh4kil]

If the number of children is returned in the result set then it should be possible to bucket the data using a variable, i.e. If Children < 3 Then "X" Else "Y"

Put the variable in a block and use a break, or maybe you could use it to Section but not tried it.