hi all,
i have 3 matrices in a report. i display the row total for 2 of the
matrices: matrix1, matrix2.
i couldn't show the row total for the third matrix, matrix3 because
it's a precentage field, so the sum of value will be wrong. so i create
a 1x1 table to cater for this total.
the weird thing is even when i place the table next to the matrix3,
align with the row total for matrix1 and matrix2 in layout view, the
table will move further (as if there's a row total) when previewed;
making the row total not aligned.
does anyone has any idea on this?
thanks!Hi!
In the matrix3 is there the percent-value coming direct from the resultset?
If not. And the resultset brings the value from that you calculate the
percent,
then you can solve the problem. Then you can have a row-total.
Use InScope in the formula of the value.
IIF(Inscope("YourRowGroupName") and InScope("YourColGroupName"), Formula for
normal cells (not-total), Formula for cells in Total)
LG HOLAN
"minority" wrote:
> hi all,
> i have 3 matrices in a report. i display the row total for 2 of the
> matrices: matrix1, matrix2.
> i couldn't show the row total for the third matrix, matrix3 because
> it's a precentage field, so the sum of value will be wrong. so i create
> a 1x1 table to cater for this total.
> the weird thing is even when i place the table next to the matrix3,
> align with the row total for matrix1 and matrix2 in layout view, the
> table will move further (as if there's a row total) when previewed;
> making the row total not aligned.
> does anyone has any idea on this?
> thanks!
>|||hi Holan,
yes, the percent-value for matrix3 comes from the dataset.
i'm sorry, i don't quite get what you mean. how can i have a row-total?
thanks!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment