Formula Question

I have a field "Accept" that can be Null or contain either "Y" or "N". In my
test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null. I
want a count of each case in the footer along with some descriptive text. I
tried the formula
=Count(Fields!Accept.Value="Y")
But it returns "4"? The same thing happens if I use
=Count(Fields!Accept.Value="N")
What is wrong in this formula?
Also, I really want the report to display something like: "Number of
Accepts: 2" but if I try to code the field as:
"Number of Accepts: " & =Count(Fields!Accept.Value="Y")
the formula displays as text?
TIA
Waynetry to write:
= "Number of Accepts: " & Sum(IIf(Fields!Accept.Value="Y",1,0))
Good Luck
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:uiB9sAU3FHA.3400@.tk2msftngp13.phx.gbl...
> I have a field "Accept" that can be Null or contain either "Y" or "N". In
my
> test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null. I
> want a count of each case in the footer along with some descriptive text.
I
> tried the formula
> =Count(Fields!Accept.Value="Y")
> But it returns "4"? The same thing happens if I use
> =Count(Fields!Accept.Value="N")
> What is wrong in this formula?
> Also, I really want the report to display something like: "Number of
> Accepts: 2" but if I try to code the field as:
> "Number of Accepts: " & =Count(Fields!Accept.Value="Y")
> the formula displays as text?
>
> TIA
> Wayne
>
>|||Liz;
Thank you very much. I never would have figured that one out. Seems like
making a point the hard way. I've ordered a couple of books that I hope will
explain the logic of creating expressions.
Wayne
"Liz Matyas" <lizmts@.mail.com> wrote in message
news:uK3U8FZ3FHA.1276@.TK2MSFTNGP09.phx.gbl...
> try to write:
> = "Number of Accepts: " & Sum(IIf(Fields!Accept.Value="Y",1,0))
> Good Luck
>
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:uiB9sAU3FHA.3400@.tk2msftngp13.phx.gbl...
>> I have a field "Accept" that can be Null or contain either "Y" or "N". In
> my
>> test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null. I
>> want a count of each case in the footer along with some descriptive text.
> I
>> tried the formula
>> =Count(Fields!Accept.Value="Y")
>> But it returns "4"? The same thing happens if I use
>> =Count(Fields!Accept.Value="N")
>> What is wrong in this formula?
>> Also, I really want the report to display something like: "Number of
>> Accepts: 2" but if I try to code the field as:
>> "Number of Accepts: " & =Count(Fields!Accept.Value="Y")
>> the formula displays as text?
>>
>> TIA
>> Wayne
>>
>>
>|||The Count RDL aggregate function works similar as the Count aggregate in
SQL: it will count all rows that are NOT NULL. The expresson
Fields!Accept.Value="Y" will return a boolean value (true/false) for all
rows, that's why the count results in the value 4.
Besides using =Sum(iif(...)) as shown by Liz, you could also use
=Count(iif(Fields!Accept.Value="Y", 1, Nothing))
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:u8BwZda3FHA.128@.tk2msftngp13.phx.gbl...
> Liz;
> Thank you very much. I never would have figured that one out. Seems like
> making a point the hard way. I've ordered a couple of books that I hope
> will explain the logic of creating expressions.
> Wayne
> "Liz Matyas" <lizmts@.mail.com> wrote in message
> news:uK3U8FZ3FHA.1276@.TK2MSFTNGP09.phx.gbl...
>> try to write:
>> = "Number of Accepts: " & Sum(IIf(Fields!Accept.Value="Y",1,0))
>> Good Luck
>>
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:uiB9sAU3FHA.3400@.tk2msftngp13.phx.gbl...
>> I have a field "Accept" that can be Null or contain either "Y" or "N".
>> In
>> my
>> test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null. I
>> want a count of each case in the footer along with some descriptive
>> text.
>> I
>> tried the formula
>> =Count(Fields!Accept.Value="Y")
>> But it returns "4"? The same thing happens if I use
>> =Count(Fields!Accept.Value="N")
>> What is wrong in this formula?
>> Also, I really want the report to display something like: "Number of
>> Accepts: 2" but if I try to code the field as:
>> "Number of Accepts: " & =Count(Fields!Accept.Value="Y")
>> the formula displays as text?
>>
>> TIA
>> Wayne
>>
>>
>>
>|||Robert;
Thanks for that additional information. It helps me understand the process.
Wayne
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eZK0yma3FHA.3036@.TK2MSFTNGP10.phx.gbl...
> The Count RDL aggregate function works similar as the Count aggregate in
> SQL: it will count all rows that are NOT NULL. The expresson
> Fields!Accept.Value="Y" will return a boolean value (true/false) for all
> rows, that's why the count results in the value 4.
> Besides using =Sum(iif(...)) as shown by Liz, you could also use
> =Count(iif(Fields!Accept.Value="Y", 1, Nothing))
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:u8BwZda3FHA.128@.tk2msftngp13.phx.gbl...
>> Liz;
>> Thank you very much. I never would have figured that one out. Seems like
>> making a point the hard way. I've ordered a couple of books that I hope
>> will explain the logic of creating expressions.
>> Wayne
>> "Liz Matyas" <lizmts@.mail.com> wrote in message
>> news:uK3U8FZ3FHA.1276@.TK2MSFTNGP09.phx.gbl...
>> try to write:
>> = "Number of Accepts: " & Sum(IIf(Fields!Accept.Value="Y",1,0))
>> Good Luck
>>
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:uiB9sAU3FHA.3400@.tk2msftngp13.phx.gbl...
>> I have a field "Accept" that can be Null or contain either "Y" or "N".
>> In
>> my
>> test data I have a total of 4 rows, 2 with "Y", 1 with "N" and 1 Null.
>> I
>> want a count of each case in the footer along with some descriptive
>> text.
>> I
>> tried the formula
>> =Count(Fields!Accept.Value="Y")
>> But it returns "4"? The same thing happens if I use
>> =Count(Fields!Accept.Value="N")
>> What is wrong in this formula?
>> Also, I really want the report to display something like: "Number of
>> Accepts: 2" but if I try to code the field as:
>> "Number of Accepts: " & =Count(Fields!Accept.Value="Y")
>> the formula displays as text?
>>
>> TIA
>> Wayne
>>
>>
>>
>>
>sql

formula not working

This does nothing:
([rush24] + [rush6] + [addLocationsTotal] + 50)

This gives me my total correctly:
([rush24] + [rush6] + 50)

All column are numeric(9) except the "total" column which is numeric(13).

Why is this happening?

I did not quite understand your question, could you describe your issue in more detail?sql

Formula Help

I have a report that I need to take the average of a total(s)...
For example
I have a field that is a sum of units(number) and then I have a field that is a count of payments(number). I need to average these two fields,so that I have the average # of payments?How can I do this?I would try creating a new formula and expand the "REPORT FIELDS" in the tree within the formula editor (2nd one from left) and pull the applicable summary fields in. I'm not positive that would work as I haven't tried it before.|||I've tried that but it gives me an error of

The Summary/Running Total field cannot be created.|||I just tested it in a report I have and it worked just fine. Where are you trying to use it? You will not be able to use it in the details, but it would have to fall in the same group footer as the summary.|||These calculations are in the group footer. I need to average the grand totals.

What formula are you using? These are the two fields that I need to use

(Sum ({CLCHARGE.CUNITS}, {CLPAYMNT.COMPANY}) and
Count({CLPAYMNT.CHGID},{CLPAYMNT.COMPANY})|||Sorry I didn't ask this in the previous post, but what version of CR are you using? I am on 10, so if you are earlier, maybe it doesn't support those calculations in the same way it does for me. If you are 10 or XI, then I would need to ask - did you create formulas for the summaries or did you use the INSERT / SUMMARY from the menu bar? If you created the summaries by letting CR do it via the INSERT / SUMMARY, then you create a separate formula that drags those summaries in to the formula editor (typing a "/" between them), it should work.|||I am using 8.5|||It may be that you can't do it from 8.5. I'm sorry that I couldn't help you.|||I was afraid of that...Thanks for you help anyway.|||Hi there I have an average formula setup in one of my reports using CR 8.5.

whileprintingrecords;

numbervar TotalTsec;
local numbervar AverageFix:=TotalTsec/DistinctCount ({SW_CASE.swCaseId});
numbervar LenOfDay;

Hope this points you in the right direction !

Many Thanks

Formula for running total

Hi,
Probably very simple but I've just started learning this but how would i do a running total in CR11 I have done the basic field but what I need is something like...
If Qty_Field = Price_field then * to give me final price
Can any help me?
ThanksI think you can use this in the Use formula option

Formula for adding two column amts together

Can anyone tell me what formula I need to do to add the amounts from summarized data in one column to the same in another column to get a total for both columns?

I have tried {file.name} + {file.name2} and variations on this (using Sum), but this doesn't add them together into one amount.

Thanks!

Julesuse

summary fields1+summary field2 in formula

ex:
Sum ({@.aa}, {Command.GRPNO})+Sum ({Command.ACCID}, {Command.GRPNO})

Formatting totals with the table footer

Here's a scenario that i'm trying to figure out.

In the table details, i return order number, item, manufacturer, and total cost of the order.

This is what it originally looked like:

Order Number Item Manufacturer Total Order Cost

1 portable DVD Company A $100

1 portable DVD Company B $100

1 portable DVD Company C $100

2 portable DVD Company B $100

2 portable DVD Company D $100

2 portable DVD Company F $100

Grand Total $600

I can get the table to look like this after hiding duplicates:

Order Number Item Manufacturer Total Order Cost

1 portable DVD Company A $100

1 portable DVD Company B $100

1 portable DVD Company C $100

2 portable DVD Company B $100

2 portable DVD Company D $100

2 portable DVD Company F $100

Grand Total $600

The problem is the grand total. It should be $200 but it takes in the all total costs in the row because I have:

=FormatCurrency(Sum(Fields!TotalCost.Value)) in the footer and it'll sum up all.

I'm stumped here. Any suggestions are greatly appreciated.

Thanks a lot for taking the time to read.

Hiding duplicates will invariably give you wrong values especially when adding. I have had the same scenario and I found the answer here on this fourm long time back. You need to do a sum of TotalOrderCost for distinct values of OrderNumber. In the Code block (available from the Report Properties dialog), you would add:

Dim orderIDs As System.Collections.Hashtable
Dim total As Double

Function MyFunc(ByVal orderID As Object, ByVal TotalOrderCost As Obect) As Double
If (orderIDs Is Nothing) Then
orderIDs = New System.Collections.Hashtable
End If
If (orderID Is Nothing) Then
MyFunc = total
Else
If (Not orderIDs.Contains(orderID)) Then
total = total + TotalOrderCost
orderIDs.Add(orderID, TotalOrderCost)
End If
MyFunc = total
End If
End Function

3.) In your report, you add a hidden textbox with the value expression to compute the value:

=Sum(Code.MyFunc(Fields!OrderID.Value, Fields!TotalOrderCost.Value))

4.)In the footer of the table, you add a textbox with the value expression:

=Code.MyFunc(Nothing, Fields!TotalOrderCost.Value)

to return the total value.

Hope this helps....

|||

Thanks for your help.

I'll give it a try.

Formatting Total of Subtotals in Matrix

Need your help with formating color of subtotal cell.
Here is my scenario:
Matrix with are 2 row's groups:
- RowKat
- RowSubKat
and 2 column's groups:
- ColKat
- ColSubKat
I want to have my subtotal cell of RowKat, in ColKat subtotal scope
(most outer total of subtotals), to be green where it's value is > 55
Is it possible?
KamelIs it possible to define Row Subtotal in scope of Column Subtotal?|||Hi Kamel. I had a similiar scenario some time back. I could not find
anyway of doing this. the most one could do is to format the whole
subtotal, but it can't be conditionally formatted (as in differently
colored column subtotals). I had to modify the dataset-query to have
another row, and then put the conditional formatting in that row.
On Feb 7, 5:45 pm, "kamel" <kwic...@.gmail.com> wrote:
> Need your help with formating color of subtotal cell.
> Here is my scenario:
> Matrix with are 2 row's groups:
> - RowKat
> - RowSubKat
> and 2 column's groups:
> - ColKat
> - ColSubKat
> I want to have my subtotal cell of RowKat, in ColKat subtotal scope
> (most outer total of subtotals), to be green where it's value is > 55
> Is it possible?
> Kamel|||thanks, I try that way...
...but mayby somebody know the trick?|||Is there any way to format that using "InScope" function?

Formatting text in a single table cell

I have a two column report. However, in the footer, i'd like to present a
column similar too:
Total spent: $100
Total left: $1,230
So that the NUMBER values on the right are completely right justified, but
the text on the left is actually LEFT justified. Can this type of
formatting occurr within the same cell?
TIA,
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comJustification is done on a per cell basis. What you can do is use a
rectangle that contains two textboxes for each row. This would allow you to
apply the justification as needed.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:%23Kh2U%237fEHA.3476@.tk2msftngp13.phx.gbl...
> I have a two column report. However, in the footer, i'd like to present a
> column similar too:
> Total spent: $100
> Total left: $1,230
> So that the NUMBER values on the right are completely right justified, but
> the text on the left is actually LEFT justified. Can this type of
> formatting occurr within the same cell?
> TIA,
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>

Formatting cents

I am using RS 2000 and I am trying to format a total amount. I want the
total amount to be separted into two separate text boxes, one with dollars
and one with cents. I am able to get the dollars portion but unable to get
the cents portion.
For example: If I have 123.05 I want 123 in box A and 05 in box B. The
problem I have is that instead of 05 I get 5.
This is the expression I am currently using and not getting what I want :
= Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
Any help would be greatly appreciated.
Scott BennettsTry this way
= (Fields!Amount.Value) - INT(Fields!Amount.Value)
Amarnath
"Scott" wrote:
> I am using RS 2000 and I am trying to format a total amount. I want the
> total amount to be separted into two separate text boxes, one with dollars
> and one with cents. I am able to get the dollars portion but unable to get
> the cents portion.
> For example: If I have 123.05 I want 123 in box A and 05 in box B. The
> problem I have is that instead of 05 I get 5.
> This is the expression I am currently using and not getting what I want :
> = Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
> Any help would be greatly appreciated.
> Scott Bennetts

format totals and subtotals on a matrix

i have a matrix with drill down, we have a divisional total, and a sub division total
i would like the background colour on the totals to be the same as the background colour on matrix columns ie division is blue and sub division is grey
--
Many thanks
JezThink of matrix subtotal cells as having two levels of style properties. The
first level deals with the cell that contains the default string "Total".
The second, or value cell, can be reached by clicking the green arrow in the
upper right corner of the Total cell. You will get the results you are
looking for if you set the background color of the group and the subtotal
value cell to the same color.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> i have a matrix with drill down, we have a divisional total, and a sub
division total
> i would like the background colour on the totals to be the same as the
background colour on matrix columns ie division is blue and sub division is
grey
> --
> Many thanks
> Jez|||this worked great thanks for the help, however implementing this has stopped my expression to colour negative figures RED
=IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
it still works on the main body of the matrix, but not the sub totals and totals
and ideas?
Many thanks
Jez
"Bruce Johnson [MSFT]" wrote:
> Think of matrix subtotal cells as having two levels of style properties. The
> first level deals with the cell that contains the default string "Total".
> The second, or value cell, can be reached by clicking the green arrow in the
> upper right corner of the Total cell. You will get the results you are
> looking for if you set the background color of the group and the subtotal
> value cell to the same color.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > i have a matrix with drill down, we have a divisional total, and a sub
> division total
> >
> > i would like the background colour on the totals to be the same as the
> background colour on matrix columns ie division is blue and sub division is
> grey
> > --
> > Many thanks
> >
> > Jez
>
>|||this worked fine, but it has stopped my expression to format negative figures RED
=IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
this still works in the matrix body but not the stub totals and totals
any ideas?
--
Many thanks
Jez
"Bruce Johnson [MSFT]" wrote:
> Think of matrix subtotal cells as having two levels of style properties. The
> first level deals with the cell that contains the default string "Total".
> The second, or value cell, can be reached by clicking the green arrow in the
> upper right corner of the Total cell. You will get the results you are
> looking for if you set the background color of the group and the subtotal
> value cell to the same color.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > i have a matrix with drill down, we have a divisional total, and a sub
> division total
> >
> > i would like the background colour on the totals to be the same as the
> background colour on matrix columns ie division is blue and sub division is
> grey
> > --
> > Many thanks
> >
> > Jez
>
>|||In testing, I've found that formatting the subtotal data cells by clicking the green arrow gives inconsistent results. Specifically, when I use this approach to format both column subtotals as well as row subtotals, I find that rows and column subtotals conflict - giving unpredictable results.
Instead, I read that one person suggested this approach - which worked well for me. Format the matrix data cell with something like:
=iif(InScope("Quarter"), "Transparent", "DarkGray")
Where "Quarter" refers to the group name. This is the only way I found I could get the background color of my subtotal rows and columns to appear the way I wanted.
Bruce Johnson [MSFT] pointed this out as a possible solution at http://sqljunkies.com/Newsgroups/microsoft.public.sqlserver.reportingsvcs/2004/6/30/281309.aspx, adding that such formatting should be more intuitive and he will pass his observations to the development team. In the meantime, however, at least we have an effective workaround.
"jez_UK" wrote:
> this worked fine, but it has stopped my expression to format negative figures RED
> =IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
> this still works in the matrix body but not the stub totals and totals
> any ideas?
> --
> Many thanks
> Jez
>
> "Bruce Johnson [MSFT]" wrote:
> > Think of matrix subtotal cells as having two levels of style properties. The
> > first level deals with the cell that contains the default string "Total".
> > The second, or value cell, can be reached by clicking the green arrow in the
> > upper right corner of the Total cell. You will get the results you are
> > looking for if you set the background color of the group and the subtotal
> > value cell to the same color.
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> > news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > > i have a matrix with drill down, we have a divisional total, and a sub
> > division total
> > >
> > > i would like the background colour on the totals to be the same as the
> > background colour on matrix columns ie division is blue and sub division is
> > grey
> > > --
> > > Many thanks
> > >
> > > Jez
> >
> >
> >|||Just a few comments, which probably explain the "unpredictable" results:
* style properties explicitly defined on the Subtotal element will always
win over styles defined on the _top-level_ reportitem in a matrix cell.
* If a horizontal subtotal intersects with a vertical subtotal and both of
them have explicit styles defined for the same style property, the
horizontal subtotal style will win.
* If the top-level reportitem in a matrix cell is e.g. a rectangle (which
could contain a textbox), only the rectangle's styles are overridden by the
subtotal styles. The styles of contained reportitems are not affected.
Consequently, you might have to consider the case where you use the InScope
approach but - for a particular style property - you have specified an
explicit value on the Subtotal, and the reportitem where you use InScope
expression is the top-level reportitem in a matrix cell.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Berenson" <Mike Berenson@.discussions.microsoft.com> wrote in message
news:BCC09120-A7E2-4858-AD98-948AFD1AB1E9@.microsoft.com...
> In testing, I've found that formatting the subtotal data cells by clicking
the green arrow gives inconsistent results. Specifically, when I use this
approach to format both column subtotals as well as row subtotals, I find
that rows and column subtotals conflict - giving unpredictable results.
> Instead, I read that one person suggested this approach - which worked
well for me. Format the matrix data cell with something like:
> =iif(InScope("Quarter"), "Transparent", "DarkGray")
> Where "Quarter" refers to the group name. This is the only way I found I
could get the background color of my subtotal rows and columns to appear the
way I wanted.
> Bruce Johnson [MSFT] pointed this out as a possible solution at
http://sqljunkies.com/Newsgroups/microsoft.public.sqlserver.reportingsvcs/2004/6/30/281309.aspx,
adding that such formatting should be more intuitive and he will pass his
observations to the development team. In the meantime, however, at least we
have an effective workaround.
> "jez_UK" wrote:
> > this worked fine, but it has stopped my expression to format negative
figures RED
> >
> > =IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
> >
> > this still works in the matrix body but not the stub totals and totals
> >
> > any ideas?
> > --
> > Many thanks
> >
> > Jez
> >
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> > > Think of matrix subtotal cells as having two levels of style
properties. The
> > > first level deals with the cell that contains the default string
"Total".
> > > The second, or value cell, can be reached by clicking the green arrow
in the
> > > upper right corner of the Total cell. You will get the results you are
> > > looking for if you set the background color of the group and the
subtotal
> > > value cell to the same color.
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> > > news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > > > i have a matrix with drill down, we have a divisional total, and a
sub
> > > division total
> > > >
> > > > i would like the background colour on the totals to be the same as
the
> > > background colour on matrix columns ie division is blue and sub
division is
> > > grey
> > > > --
> > > > Many thanks
> > > >
> > > > Jez
> > >
> > >
> > >

Format subtotals in matrix report

How can I make the total in the bottom row of a matrix report bold?
Thanks,
James.Clicking on the small green triangle in the upper right hand corner of a
matrix subtotal cell will expose the subtotal row or columns style
properties in the Properties window.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Gifford" <jamesgifford88@.hotmail.com> wrote in message
news:uuXJMTvqEHA.3896@.TK2MSFTNGP15.phx.gbl...
> How can I make the total in the bottom row of a matrix report bold?
> Thanks,
> James.
>|||Thanks Bruce.
I spent AGES trying to find out how to do this! I will pay more attention to
green triangles in future.
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:OThulvvqEHA.1160@.tk2msftngp13.phx.gbl...
> Clicking on the small green triangle in the upper right hand corner of a
> matrix subtotal cell will expose the subtotal row or columns style
> properties in the Properties window.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "James Gifford" <jamesgifford88@.hotmail.com> wrote in message
> news:uuXJMTvqEHA.3896@.TK2MSFTNGP15.phx.gbl...
> > How can I make the total in the bottom row of a matrix report bold?
> >
> > Thanks,
> >
> > James.
> >
> >
>

Format Sub Total

If I want to change the background colko of a Sub total in a Matrix How do I
do that?
it does not allow me
thanksHi Carlos,
Thanks for your posting!
From your descriptions, I understood that you would like to change the
background color of subtotals. Have I understood you? Correct me if I was
wrong.
Here is Matrix subtotal cells has two levels of style properties. The first
level deals with the cell that contains the default string "Total". The
second, or value cell, can be reached by clicking the green arrow in the
upper right corner of the Total cell. You will get the results you are
looking for if you set the background color of the group and the subtotal
value cell to the same color.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Format matrix subtotal column

I have a matrix that has columns for each quarter of the year and I added a
subtotal colum for the year total. I would like to have the data cells in the
subtotal column be a different color than that of the the quarter columns. I
thought that using the little green triangle in the subtotal cell would work,
but it doesn't. How can I do this?
Thanks...
Regards,
SteveIt is the little green triangle - BackgroundColor in Subtotal properties.
You also have to assign a BackgroundColor for the textbox that is your column
heading.
Do you have some expression overriding it?
daw
"Steve" wrote:
> I have a matrix that has columns for each quarter of the year and I added a
> subtotal colum for the year total. I would like to have the data cells in the
> subtotal column be a different color than that of the the quarter columns. I
> thought that using the little green triangle in the subtotal cell would work,
> but it doesn't. How can I do this?
> Thanks...
> Regards,
> Steve|||For some reason I can't get it to work on a column subtotal, but it works
fine for a row subtotal. No expressions overriding it far as I can see.
The BackgroundColor for the column heading is LightSkyBlue, but changing the
BackgroundColor on the subtotals textbox to, say Red, using the little green
arrow has no effect.
I was able to get it to work by setting the BackgroundColor property in the
data cell, i.e. the one with the sum in it, using this expression:
=iif(InScope("matrix3_ColumnGroup2"),"Quarter totals","Year totals")
Thanks,
Steve
"daw" wrote:
> It is the little green triangle - BackgroundColor in Subtotal properties.
> You also have to assign a BackgroundColor for the textbox that is your column
> heading.
> Do you have some expression overriding it?
> daw
> "Steve" wrote:
> > I have a matrix that has columns for each quarter of the year and I added a
> > subtotal colum for the year total. I would like to have the data cells in the
> > subtotal column be a different color than that of the the quarter columns. I
> > thought that using the little green triangle in the subtotal cell would work,
> > but it doesn't. How can I do this?
> >
> > Thanks...
> >
> > Regards,
> > Steve