Formula Help :)

I have a matrix table & have a picture next to table which should display
when the percentage of the 2 colums is less than 5%.
My guess on this formula is which doesnt work.
=IIF sum((count(iif( Fields!SwitchDispId.Value, "QueueCallDetail") = 16),
"b") )/ ((count(iif( Fields!SwitchDispId.Value, "QueueCallDetail") = 1), "b")
IS < .05
Firstly i just want to total the 2 columns (disposition 16 & 1) then get a
percentage.
I would also like to get a percentage om each row as well.
Please help.
Thanks
toddI started trying to write your formula for you this morning, but discovered
I don't really understand what you are trying to do..
If you post more details ( what is the 16 and 1 for? what is "b" for. etc),
someone will be able to help you...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:528A7104-0F8A-45A7-A38A-F0CA7C776C8D@.microsoft.com...
>I have a matrix table & have a picture next to table which should display
> when the percentage of the 2 colums is less than 5%.
> My guess on this formula is which doesnt work.
> =IIF sum((count(iif( Fields!SwitchDispId.Value, "QueueCallDetail") = 16),
> "b") )/ ((count(iif( Fields!SwitchDispId.Value, "QueueCallDetail") = 1),
> "b")
> IS < .05
> Firstly i just want to total the 2 columns (disposition 16 & 1) then get a
> percentage.
> I would also like to get a percentage om each row as well.
> Please help.
> Thanks
> todd|||Sorry wayne. I have a matrix table that has 2 colum groups. Those that have a
number 16 & the second column counts those records with a number 1. the b was
just something that i coped from a different formula.
so in summery i have various groups down the left hand side. at the top of
have a count of the number of 16's in the first column & & a count of the
number 1's in the second column.
These matrix tables are hard to understand..
Thanks
Todd
"Wayne Snyder" wrote:
> I started trying to write your formula for you this morning, but discovered
> I don't really understand what you are trying to do..
> If you post more details ( what is the 16 and 1 for? what is "b" for. etc),
> someone will be able to help you...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Tango" <Tango@.discussions.microsoft.com> wrote in message
> news:528A7104-0F8A-45A7-A38A-F0CA7C776C8D@.microsoft.com...
> >I have a matrix table & have a picture next to table which should display
> > when the percentage of the 2 colums is less than 5%.
> >
> > My guess on this formula is which doesnt work.
> >
> > =IIF sum((count(iif( Fields!SwitchDispId.Value, "QueueCallDetail") = 16),
> > "b") )/ ((count(iif( Fields!SwitchDispId.Value, "QueueCallDetail") = 1),
> > "b")
> > IS < .05
> >
> > Firstly i just want to total the 2 columns (disposition 16 & 1) then get a
> > percentage.
> >
> > I would also like to get a percentage om each row as well.
> >
> > Please help.
> > Thanks
> > todd
>
>

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 Suggestions - Please Help

Hello,

I have a matrix with a dynamic number of columns (1-10). The trouble is that hiding one ore more columns still leaves space reserved for all 10 columns, which is ugly. This is because the size of the TextBox that oversees the columns is not dynamic, and it is set to the size of all 10 text boxes.

In other words, a matrix with 5 columns looks like this:

Item Total

Col1 Col2 Col3 Col4 Col5 Total

5 5 5 5 5 25

While a matrix with 2 columns (the last 3 have visibility set to false) looks like this:

Item Total

Col1 Col2 Total

5 5 25

I am going crazy trying to solve this one. Does anyone have any ideas at all that can help me? Merging all the columns into a single column would not work well for me, as each column is a drill-down for the others. And making each column small (.1in), doesn't work either because there is no "no-wrap" property.

ANY suggestions would be appreciated. How have others dealt with this issue?

Michael

I have also found that the invisible function is SQL reports is no good. What determines how many columns there will be on the report? Can you use that determination to choose between different reports -- say one that is a two column report and another that is a five column report? Don't use invisibility at all.|||

Greg,

That's what I did. I created a small, medium, and large version of my report (1-2, 3-5, 6-10), that seems to be reasonable even when the visibility column is hidden for some of the columns. The problem is that I have a dozen reports I want to use with the variable column in the left axis, and that means I need to create 36 reports instead of 12. Fortunately, the top axis auto-fits items so I only need one report for the top axis, or else I would be in BIG trouble.

sql

Formatting subtotals in Matrix reports

I am trying to alter the color of a cell of a subtotal based on the value of the subtotal.
Example: =IIF(Subtotal.Value < 20 ,"Brown","Blue")
This doesn't work. How do I refer to the value of a subtotal inside an expression' I think it has something to do with InScope(). I have definitely clicked the little green tab and am getting the correct properties window.Please see this posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c9b1dcda-cd35-4669-bb9b-4076ad21ed43
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Getting started and liking it" <Getting started and liking
it@.discussions.microsoft.com> wrote in message
news:5BC824BC-61A2-44A8-BA0B-FD0163954F8E@.microsoft.com...
> I am trying to alter the color of a cell of a subtotal based on the value
of the subtotal.
> Example: =IIF(Subtotal.Value < 20 ,"Brown","Blue")
> This doesn't work. How do I refer to the value of a subtotal inside an
expression' I think it has something to do with InScope(). I have
definitely clicked the little green tab and am getting the correct
properties window.

Formatting Sub Totals in a Matrix

Would some one know how to control the formatting of Matrix Sub totals, such as Border around it, background color and font etc...I can't select the grey textbox that is rendered if sub totals are chosen from the context menu for a group.

Any help will be appreciated.

If you right-click on the green triangle in the corner of the subtotal label and click properties you should be able to access the properties of the subtotal text box (I believe it is actual labeled Subtotal by default).

Hope this helps,

Simone

|||I love this forum....Thanks!!!!!!

Formatting Problem

Hi,

I'm trying to format the output of a report and can't seem to figure out how use the Matrix control to get what I want. Currently, I have it formatted as:

General Information <-- Head
Tag Number Line Size Line Schedule <-- Information

Service P&ID No. Tightness Requirements

Line No. Area Classification Location

Process Data
Fluid Specific Gravity

Transmitter Spec.
Mounting Type

NEMA Rating Power Supplied Analog Outputs

Ideally I'd like to have it formatted as:

General Information <-- Header centered
Tag Number Line Size Line Schedule

Service P&ID No. Tightness Requirements

Line No. Area Classification Location
__ <-- Divider Line between sections

Process Data
Fluid Specific Gravity
__

Transmitter Spec.
Mounting Type

NEMA Rating Power Supplied Analog Outputs

Any ideas or suggestions would be greatly appreciated. This shouldn't be THIS hard to do.

Thanks,

John.

It'll be a lot clearer to understand if you make up your examples in Excel and then just copy paste that into your post.|||

Adam,

Thanks for taking an interest. Ok, here's what's going on: I'm trying to render information where I have multiple (unknown at design time) Catagories which have multiple Attributes (also unknown at design time). The relationship is One Catagory, Many Attributes.

I'm using a Matrix control because it seems to be the Control to use? If it's not, let me know. What I'd like ideally is to: Add a Line to separate the different Catagories (i.e. General Information, Process Data, etc.), and center the Catagory title. Currently I'm forcing the Matrix to wrap at 3 by setting a property in the List Control's "Edit Details Group..." property to: =Ceiling(RowNumber(Nothing)/3). If you have any ideas on how to solve this through the designer, please let me know.

Here's an example of the data as it's currently being rendered:

General Information

Service

P&ID No.

Tightness Requirements

Tag Number

Line Size

Line Schedule

Line No.

Area Classification

Location

Process Data

Fluid

Specific Gravity

Transmitter Spec.

Mounting Type

Model No.

Support Materials

Accuracy

NEMA Rating

Power Supplied

Analog Outputs

Local Display

Operating Range

Dead Weight

Output Signal

Conduit Connection

Live Weight

Gross Weight

Manufacturer

Weigh Cell Data

Mounting

Temperature Compensation

Power Supplied

|||

On a side note, I've tried adding a Line control to the List, but it renders on every line. I also have no way to detect when the last line of a Catagory is being rendered. I've tried every way I can think of using the tool, but it's just not working for me.

TIA,

John.

|||I would suggest placing the matrix inside a list control. Group the list control by category which will result in a separate matrix being rendered per category. You can then place the category in a textbox above the matrix and also inside the list and center it.|||

Adam,

Mad thanks, that did the trick!!

John.

formatting matrix subtotals

Hi,
have had a look at the archives and there is some good info there
about having different formatting for subtotals as compared to the
actual data columns. What I want to do though, is have the same
formatting applied to the subtotals as to the data columns.
I have 9 data columns which all have a formula applied to the font
colour setting along the lines of:
=iif( sum(Fields!PD_Sales_Var_LY.Value) < 0 , "Red","Black")
This works fine in the column and in preview, it works on the subtotals
as well but when I deploy to the server, it loses the formatting on the
subtotals and all numbers are in default "Black"
Any ideas ?
Rgds
GeoffUpdate on this
It appears that the subtotals will only inherit the formatting from
data columns if there is absolutely no formatting applied to the
subtotals themselves. I made the mistake of adding a border property to
the subtotals, thinking it would not affect inheritance of the font
property but obviously it does.
Rgds
Geoff

Formatting in Exported Reports

Hi. I have a matrix report that has very dynamic data attached to it,
specifically text that can vary in length from 5 characters to 100 or more.
I found the best solution for rendering was to keep the actual matrix row and
column widths to a minimum and let the matrix grow as required.
The problem I have run into is, when you export to Excel or PDF, it appears
the export uses these minimum column/row widths, and the report does not look
good and requires alot of formatting by hand (including another problem with
column headings I posted).
So my question is, is there any way to work around this or a best practices?
Any help would definitely be appreciated.Actually, this problem is only in Excel.
"comet61" wrote:
> Hi. I have a matrix report that has very dynamic data attached to it,
> specifically text that can vary in length from 5 characters to 100 or more.
> I found the best solution for rendering was to keep the actual matrix row and
> column widths to a minimum and let the matrix grow as required.
> The problem I have run into is, when you export to Excel or PDF, it appears
> the export uses these minimum column/row widths, and the report does not look
> good and requires alot of formatting by hand (including another problem with
> column headings I posted).
> So my question is, is there any way to work around this or a best practices?
> Any help would definitely be appreciated.sql

Formating drill down on SubTotal Column in Matrix

Hello Experts,

I have a Matrix in my report where on each each cell i have a drill down to another report. The Matrix also has SubTotal Column getting generated.

But the Problem is the drill down report gets carried on the SubTotal column also and the user gets vage results as proper information is not passed to another report.

Is there a way through which if its a subTotal cell then i can hide the drill down. some IIF() condition is there is

I appreciate if somebody can help me address this problem.

/Soni

The jump to report EXPRESSION should be something like:

=IIF(InScope("matrix1_YourGroupName"), "Other report name", Nothing)

Formating drill down on SubTotal Column in Matrix

Hello Experts,

I have a Matrix in my report where on each each cell i have a drill down to another report. The Matrix also has SubTotal Column getting generated.

But the Problem is the drill down report gets carried on the SubTotal column also and the user gets vage results as proper information is not passed to another report.

Is there a way through which if its a subTotal cell then i can hide the drill down. some IIF() condition is there is

I appreciate if somebody can help me address this problem.

/Soni

The jump to report EXPRESSION should be something like:

=IIF(InScope("matrix1_YourGroupName"), "Other report name", Nothing)

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

Format expression returned a data type that is not valid

Hi,
I'm new on Reporting Services 2005 and would apreciate your help.
I'm trying to format a textbox in a matrix report to present an ABS value.
I've tried several formulas but I'm getting this warning :
"The Format expression used in textbox â'SALDO_PERIODOâ' returned a data type
that is not valid."
The textbox value is Sum(Fields!SALDO_PERIODO.Value and the format formula
I'm using is =Abs(Sum(Fields!SALDO_PERIODO.Value, "SALDOS"))
Thanks,
--
NSThe format code property has to evaluate to a string. Also, the format code
property uses .NET formatcode string. Please check MSDN for details:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nuno Santos" <NunoSantos@.discussions.microsoft.com> wrote in message
news:E6AC8CC1-61A1-4418-9982-691755C7C550@.microsoft.com...
> Hi,
> I'm new on Reporting Services 2005 and would apreciate your help.
> I'm trying to format a textbox in a matrix report to present an ABS value.
> I've tried several formulas but I'm getting this warning :
> "The Format expression used in textbox 'SALDO_PERIODO' returned a data
> type
> that is not valid."
> The textbox value is Sum(Fields!SALDO_PERIODO.Value and the format formula
> I'm using is =Abs(Sum(Fields!SALDO_PERIODO.Value, "SALDOS"))
> Thanks,
> --
> NS