matrix layoout problem

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!

Matrices in reporting services

Hello All,

I am attempting to produce a Summary report that will detail all financial losses incurred by a company. These losses are seperated into categories and each category has two types, direct and indirect. To date I have employed the use of multiple matrices.

The problem is that if the company has incurred no losses for a specific category then this will cause the matrix to automatically cater for the lack of this column. However I want this to show up regardless of there being data...

I cannot employ the use of tables...as it simply does not work!

Does anyone have any suggestions? Ideas?

All would be appreciated!!

Thanks

JrDevRon,

You could return "Zeros" or Blank space in your SQL where no losses occur for specific categories. This is ensure that you always return all categories regardless.

Ham

|||

Hi Ham,

Thanks for the reply!

I have this implemented already and this works fine when at least one of the cells in the same column/row has been populated. If there is no data for a specific column then the whole thing disappears regardless...this is something I do not want.

Right now I have it this way and giving me a subtotal, I also then have another row detailing the recovered amounts which apply to my categories below my subtotal, obviously due to restrictions I have to use a second matrix for this information. I then subtract the corresponding information from the subtotal. But due to the above problem these columns do not always line up on the report...

I know this sounds convoluted and more complex than it probably needs to be but I would be appreciative of any help...

Thank you all!!

Matrices & Totals

I have a matrix with two levels of row grouping and one level of column
grouping. For each cell I need to show the percentage of the group subtotal.
Here's an example.
CG1 CG2 CG3
# % # % # %
RG1 RG11 50 50% 20 10% 400 20%
RG12 20 20% 80 40% 300 15%
RG13 30 30% 100 50% 1300 65%
Total 100 33% 200 40% 2000 12%
RG2 RG21 10 5% 50 17% 1000 7%
RG22 30 15% 60 20% 2000 13%
RG23 40 20% 70 23% 3000 20%
RG24 60 30% 80 27% 4000 27%
RG25 60 30% 40 13% 5000 33%
Total 200 67% 300 60% 15000 88%
Grand Total 300 100% 500 100% 17000 100%
I've stuck with formula to calculate %.
Please, help!
--
Thanks,
IDhi,
Its hard to get the total from the report .. I had the same problem. What I
did, I took the total of the each rowm from the Query itself and in the
report screen, in the % cell, I did
Fields!RG!.Value/Fields!Total.Value and put its format P2.
it was working fine with these expression.
try this...
Bismi
"exkievan" wrote:
> I have a matrix with two levels of row grouping and one level of column
> grouping. For each cell I need to show the percentage of the group subtotal.
> Here's an example.
>
> CG1 CG2 CG3
> # % # % # %
> RG1 RG11 50 50% 20 10% 400 20%
> RG12 20 20% 80 40% 300 15%
> RG13 30 30% 100 50% 1300 65%
> Total 100 33% 200 40% 2000 12%
> RG2 RG21 10 5% 50 17% 1000 7%
> RG22 30 15% 60 20% 2000 13%
> RG23 40 20% 70 23% 3000 20%
> RG24 60 30% 80 27% 4000 27%
> RG25 60 30% 40 13% 5000 33%
> Total 200 67% 300 60% 15000 88%
> Grand Total 300 100% 500 100% 17000 100%
> I've stuck with formula to calculate %.
> Please, help!
> --
> Thanks,
> ID|||Thanks, Bismi. I did it the same way. I thought there's a way to do it on the
report.
--
Thanks,
ID
"Bismi" wrote:
> hi,
> Its hard to get the total from the report .. I had the same problem. What I
> did, I took the total of the each rowm from the Query itself and in the
> report screen, in the % cell, I did
> Fields!RG!.Value/Fields!Total.Value and put its format P2.
> it was working fine with these expression.
> try this...
> Bismi
> "exkievan" wrote:
> > I have a matrix with two levels of row grouping and one level of column
> > grouping. For each cell I need to show the percentage of the group subtotal.
> >
> > Here's an example.
> >
> >
> > CG1 CG2 CG3
> > # % # % # %
> > RG1 RG11 50 50% 20 10% 400 20%
> > RG12 20 20% 80 40% 300 15%
> > RG13 30 30% 100 50% 1300 65%
> > Total 100 33% 200 40% 2000 12%
> > RG2 RG21 10 5% 50 17% 1000 7%
> > RG22 30 15% 60 20% 2000 13%
> > RG23 40 20% 70 23% 3000 20%
> > RG24 60 30% 80 27% 4000 27%
> > RG25 60 30% 40 13% 5000 33%
> > Total 200 67% 300 60% 15000 88%
> > Grand Total 300 100% 500 100% 17000 100%
> >
> > I've stuck with formula to calculate %.
> >
> > Please, help!
> > --
> > Thanks,
> >
> > ID