Matrix Sub Total

Hi Experts...
I am using a matrix report. I am showing the subtotals of one of the columns
and it is comming correctly on the Right hand side of the column. My problem
is that I want the sub total to appear on the Left hand side of the selected
column insted of the Right side.
Is there any quick way of achieving this? Can anybody give a suggestion for
this?
Thanks
GaneshHi, Ganesh.
On the upper right corner of the subtotal cell, you should see a green
triangle.
Right-click over that triangle and select "Properties" (it should be
the only option enabled).
Then look for a property named "Position" set to the value "After".
You can switch it to "Before" and voil=E1. :)
Regards, Paulo Cunha|||thanks Paulo for the reply..it was really helpful
"Paulo X" <pjmcunha@.gmail.com> wrote in message
news:1141646924.794781.114380@.j33g2000cwa.googlegroups.com...
Hi, Ganesh.
On the upper right corner of the subtotal cell, you should see a green
triangle.
Right-click over that triangle and select "Properties" (it should be
the only option enabled).
Then look for a property named "Position" set to the value "After".
You can switch it to "Before" and voilá. :)
Regards,
Paulo Cunhasql

Matrix Report Column break in PrintPreview

Hi,

I have a problem in matrix report printpreview where the Column break doesn't happen correctly in printpreview. Some columns go to the next page. Is there any solution to fix this problem.

Below is an example, while print preview some columns are displayed in the next page. I want all the 4 columns to fit in one page.

Name
-----------
Col1|Col2|Col3|Col4

set the width of the matrix to 8.5 or less...

|||

Try to adjust your matrix chart size

Matrix export to Excel format difficulty

I made a matrix report with drilldown.

My users like to export it to excel and work with it there.

The + signs don't lie up correctly when it is exported- you have to click the '+' one row up from what you really want to expand it.

Any tips on getting the right data lined up with the right '+' on export? Thanks

How are you exporting it to excel? When I use the standard export method in Report Server, it works fine.|||The user chooses 'excel' format and then clicks export.|||

Try changing your subtotal rows Position property to "Before" instead of "After". You can get to this property by clicking on the green triangle in the corner of the subtotal row, it's in the Layout category.

|||Make sure the toogle item property is set properly.

Matrix - SubTotal not giving the total correctly

Hi All,
I have a simple Matrix Report
DC-1 DC-2
AA 10 20
BB 20 12
CC 30 55
When I add a subtotal to the report both (row and column) it result the total
of the first row or a column, something like this
DC-1 DC-2 Total
AA 10 20 10
BB 20 12 20
CC 30 55 30
Total 10 20 10
How do i solve this
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1It seems like the matrix cell contains an expression like =Fields!Abc.Value.
Also, in report designer you should get a warning about a field used in a
matrix cell without aggregate function.
A matrix cell (and subtotal cell) will usually cover more than one data row
(after grouping). Using an expression like =Fields!Abc.Value will however
only return the first row (and this is what you see in the subtotal cells).
You need to change the cell expression to e.g. =Sum(Fields!Abc.Value)
Then, the subtotal cells will show the Sum of the values also.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BALAJI K via SQLMonster.com" <u5178@.uwe> wrote in message
news:5556507f491a4@.uwe...
> Hi All,
> I have a simple Matrix Report
> DC-1 DC-2
> AA 10 20
> BB 20 12
> CC 30 55
> When I add a subtotal to the report both (row and column) it result the
> total
> of the first row or a column, something like this
> DC-1 DC-2 Total
> AA 10 20 10
> BB 20 12 20
> CC 30 55 30
> Total 10 20 10
> How do i solve this
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1|||Thanks Robert
it worked, I have a one more thing to do now , Say I need to show one more
row in my Matrix where I need to the Variance
Like this
DC-1 DC-2 Total
AA 10 20 10
BB 20 12 20
CC 30 55 30
Total 10 20 10
Variance (10 -Field!Rtotal.Value) (20 -Field!Rtotal.Value) (30-Field!Rtotal.
Value)
How do I achieve this
Balaji
Robert Bruckner [MSFT] wrote:
>It seems like the matrix cell contains an expression like =Fields!Abc.Value.
>Also, in report designer you should get a warning about a field used in a
>matrix cell without aggregate function.
>A matrix cell (and subtotal cell) will usually cover more than one data row
>(after grouping). Using an expression like =Fields!Abc.Value will however
>only return the first row (and this is what you see in the subtotal cells).
>You need to change the cell expression to e.g. =Sum(Fields!Abc.Value)
>Then, the subtotal cells will show the Sum of the values also.
>-- Robert
>> Hi All,
>[quoted text clipped - 16 lines]
>> How do i solve this
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1