Matrix with one repeating group (above it) -> REP-1510 Group manager :

[vchen7]

Hi,
I have a problem with my matrix.

The following matrix is working fine :

|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)



I would like to add a break group above this matrix, to display the type :


Type : Type1

|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)


---------------------------------------------------------------------------------
/*******************************************************************************/
---------------------------------------------------------------------------------

Type : Type2

|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)


Everything compiles fine.
At execution, the first pages are calculated fine, but the last page goes in exception :
REP 1510 : Groupe Manager : unable to calculate the 'X = A - Sum(B)' column.

I tried to put columns : A, Sum(B), X at the same level, another error comes.

Any help/hint/advise would be appreciated.

Thanks,
Vincent

 

[nagornyi]

Try calculating grand total for X using Sum(X) column rather then X column.
Here is what Metalink says about this error:

PROBLEM DESCRIPTION:
====================

You have a summary column that is sourced to a item in another group
within a matrix report. An error is encountered:
REP-1510: Group Manager: value of calculation not found.

SOLUTION DESCRIPTION:
=====================

This is not the proper way to create a count in a matrix report. The
count must be sourced to an item within the group.
Create a summary column and source it to an item within the same
group of the matrix report.

 

[vchen7]

Hi nagornyi,
Thanks for reply.
I finally used formula column in which I recalculate without using any other summary columns, using database columns only.

This is a bug that has no solution.

Vincent