Sujit

• Sep 23rd, 2006

 

Can you be more specific as to what exactly you are looking for, and example will be of great help in understanding your issue.

Fazalhusein Z Patvi

• Mar 16th, 2007

 

A very common problem.

There are 2 reasons. 

1. The query itself is returning multiple rows.  That is the result set does not contain single distinct rows but multiple rows.
 
Eg:

Country             State                   City                      Schools
INDIA                  GUJ                    AHM                        40
INDIA                  GUJ                    AHM                        50
INDIA                  GUJ                    AHM                        60

2.  BO has the tendency to sum up numbers if all the cols are of type text..
So in above case we


Country             State                   City                      Schools
INDIA                  GUJ                    AHM                        150

Hope this clarifies..

kalpesh_geek

 Profile Answers by kalpesh_geek 

• Aug 21st, 2007

 

By default, the 'Avoid Duplicate Row Aggregation'  option is disabled. Your problem may be due to this option. To enable this, right click on the block, format table and select this option