Group not sorting correctly

[haneen97]

Hi, CR 8.5

I have a report that is grouping two levels of data. It looks like the data is not sorting. I get the top group repeated which means it is showing each time the sub group is changing. I am looking to get the main group once with all the attached sub groups. I have my group set up correctly, I think. I have the same logic in 6 other reports but this one is not working. I deleted the groups and rebuilt them again but to no avail.

Please help.

Mo

 

[synapsevampire]

I think that you misunderstand what a Group is, and the hierarchical nature of them.

If you have 2 groups, one is the outer group of the other, so the inner group will iterate through all of the data that relates to the outer grouping.

So you should see what you call a top group (that's the outer group) stay the same for those in the inner group for that level.

Rather than thrying to explain how you think things should work, or how you think you should meet requirements, try posting technical information:

Database/connectivity used
Example data (show tables/fields/data)
Expected output

-k

 

[haneen97]

Raw data:

Aaa 1111 dddc
Aaa 1111 ddcc
Aaa 2222 dccc
Aaa 2222 cccc
Bbb 3333 zzzx
Bbb 3333 zzxx
Bbb 4444 zxxx
Bbb 4444 xxxx

Expected report

G1…..G2….Count
Aaa
………1111....2
………2222…2
Bbb
……….3333 ..2
……….4444...2

Current output

G1…….G2…Count
Aaa
………1111....1
………2222…1
Aaa

………1111....1
………2222…1
Bbb
……….3333 ..1
……….4444...1
Bbb
……….3333 ..1
……….4444...1


Hope this makes sense

Mo

 

[synapsevampire]

I would guess that some fields are padded with spaces or some such.

This could probably be resolved by using a SQL Expression on the database, or to use TRIM() function in a formula and then group by that.

Note that they may be case sensitive as well.

-k

 

[haneen97]

Absolutly. That worked. Thank you very much.

Mo