Failure in groups

[BOUser0815]

Hello all,

i got a problem with a report. Following field are in:

- Part no.
- Region no.
- Pieces
etc.

I got the region 10, 31, 32, 33, 34, 40 and 41. For the regions 40 and 41 i duplicated the report and filtered each one. But for the other regions, the problem is that it does not group the pieces. For each region, all articles are showed, and that makes a list of 270 pages instead of 80 pages. Can somebody help me? Thank you!

Greets from Germany!

 

[naga5566]

HI ,
Could be bit specific as what you are trying to acheive.

 

[nimmy99]

Is it a numeric field or text field?
If it is text, try trimming the column

 

[DJM99]

I suspect this is related to sycnronization of the data providers/sql.

How many bits of SQL does your report generate? Are all the dimenions in both data providers (if you have more than one).

Darren Marsden

http://www.bimentors.com