To Avoid multiple records in same block

[Jodus]

Hi,
In my Bo XIR2 report there are 4 queries and the one block is populating with multiple records instead of one record based on the key field . but in the query itself working fine, when i'm running the report it happens.

for example there are 3 different records the query returns and all three should go to seperate blocks when displaying based on the key field. but these 3 records coming together for 3 times based on the key field , total 9 times it displays, actual need is one record per key .
The query itself running fine , the problem when i start the report... any suggetions please.

thanks
Jodus

 

[Madawc]

Use Group to combine the multiples. Show the field details in the group header or footer, suppress the detail lines.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP