Group doesn't show records with the same ID.

[Jason30]

Hi all,

The result in a group doesn't show all the records. It seems that it doesn't print the records with the same location ID.

The option 'print repeated values' is ON for each field in the group.

Group 1 Expression: location_id

Query: ORDER BY location_id, name

Query result:

• 5, Mark, street 10, USA
• 5, Mark, street 10, France 
• 7, Steven, street 80, England
• 8, Jason, street 55, Italy

Group result

• 5, Mark, street 10, France
• 7, Steven, street 80, England
• 8, Jason, street 55, Italy

The following result is left out in the group:

• 5, Mark, street 10, USA

Obviously it has something to do with the same location_id and name, but I can't figure out why.

Does anyone have an idea?

Thanks in advance for any help/tip.

[hozawa]

Seems like there's something wrong with your jrxml. Can't say anything further because I've been doing something similar and haven't encountered a problem like yours.

[dohungnd94]

The problem may be your current band cannot display full the records. Set your current group is float and check Stretch with overflow. Cheers

[Jason30]

Thanks a lot, stretch with overflow and float did the trick!