backgroundcolor in groups

Hello,
There are 3 groups in my table. The second and third group are hidden and
can be drilled down. I have a code to set alternate color for backgroundcolor
of each rows (the first group). The code is "= iif(RunningValue(
Fields!uniqueID.Value, CountDistinct, Nothing) mod 2, "white", "yellow")".
However, some rows can not return alternate color. The report looks like that:
row1 (backgroundcolor is white)
row2 (backgroundcolor is yellow)
row3 (backgroundcolor is white)
row4 (backgroundcolor is white)
row5 (backgroundcolor is yellow)
Does anybody know how to set alternate color for groups?
Thanks!The RunningValue runs based on the details, but you are using the value to
determine the color of groups. If one group contains an even number of
details, the next group will have the same backgroundcolor as the previous
group.
At this point, there is no predefined aggregate function available that
would just count the groups. However, you may want to read this article
which explains the steps necessary to get this working:
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:C44CDF74-4505-47C7-B7EB-F53F788698EF@.microsoft.com...
> Hello,
> There are 3 groups in my table. The second and third group are hidden and
> can be drilled down. I have a code to set alternate color for
backgroundcolor
> of each rows (the first group). The code is "= iif(RunningValue(
> Fields!uniqueID.Value, CountDistinct, Nothing) mod 2, "white", "yellow")".
> However, some rows can not return alternate color. The report looks like
that:
> row1 (backgroundcolor is white)
> row2 (backgroundcolor is yellow)
> row3 (backgroundcolor is white)
> row4 (backgroundcolor is white)
> row5 (backgroundcolor is yellow)
> Does anybody know how to set alternate color for groups?
> Thanks!
>
>|||Thanks for your help! It works after I change my code to
"= iif(RunningValue(Fields!uniqueID.Value & Fields!group1.Value,
CountDistinct, Nothing) mod 2, "white", "yellow")".
Jean
"Robert Bruckner [MSFT]" wrote:
> The RunningValue runs based on the details, but you are using the value to
> determine the color of groups. If one group contains an even number of
> details, the next group will have the same backgroundcolor as the previous
> group.
> At this point, there is no predefined aggregate function available that
> would just count the groups. However, you may want to read this article
> which explains the steps necessary to get this working:
> http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:C44CDF74-4505-47C7-B7EB-F53F788698EF@.microsoft.com...
> > Hello,
> >
> > There are 3 groups in my table. The second and third group are hidden and
> > can be drilled down. I have a code to set alternate color for
> backgroundcolor
> > of each rows (the first group). The code is "= iif(RunningValue(
> > Fields!uniqueID.Value, CountDistinct, Nothing) mod 2, "white", "yellow")".
> > However, some rows can not return alternate color. The report looks like
> that:
> >
> > row1 (backgroundcolor is white)
> > row2 (backgroundcolor is yellow)
> > row3 (backgroundcolor is white)
> > row4 (backgroundcolor is white)
> > row5 (backgroundcolor is yellow)
> >
> > Does anybody know how to set alternate color for groups?
> >
> > Thanks!
> >
> >
> >
> >
>
>sql

Background Color Return:

I am writing a report that I need to return a background color for a cell in
a table. The background color depends on what color is named in another
cell. For example, if the cell (Quality_status.value) displays the word
Green then the cell (Quanity_status.value) background color needs to be
Green. I have tried several IIF expressions in the BackgroundColor
properties but none of them seem to work. Please help!!
--
Sincerely,
Debo
--
Sincerely,
DeboThe only supported property of a field is Value. Therefore you can't do it.
HTH
Charles Kangai, MCT, MCDBA
"Debo" wrote:
> I am writing a report that I need to return a background color for a cell in
> a table. The background color depends on what color is named in another
> cell. For example, if the cell (Quality_status.value) displays the word
> Green then the cell (Quanity_status.value) background color needs to be
> Green. I have tried several IIF expressions in the BackgroundColor
> properties but none of them seem to work. Please help!!
> --
> Sincerely,
> Debo
> --
> Sincerely,
> Debo|||I went to a textbox properties, background color, scrolled to the top to
add an expression. and did
=iif(fields!CompanyName.Value = "Alfred's","Red","Green") and it worked
have you tried
=(fields!Quality_status.Value)
--
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
"Debo" <debo@.discussions.microsoft.com> wrote in message
news:835302E4-20F1-4D56-A738-9954ED6B346E@.microsoft.com...
> I am writing a report that I need to return a background color for a cell
in
> a table. The background color depends on what color is named in another
> cell. For example, if the cell (Quality_status.value) displays the word
> Green then the cell (Quanity_status.value) background color needs to be
> Green. I have tried several IIF expressions in the BackgroundColor
> properties but none of them seem to work. Please help!!
> --
> Sincerely,
> Debo
> --
> Sincerely,
> Debo|||Hi Wayne,
I thought Debo was trying to read the BackColor property, and you cannot
read any property of a textbox except Value. Of course if you enter the name
of the color in words in a textbox, then you can do it, because you are
reading the Value property.
Cheers
Charles Kangai, MCT, MCDBA
ps - good to hear from you Wayne!
"Wayne Snyder" wrote:
> I went to a textbox properties, background color, scrolled to the top to
> add an expression. and did
> =iif(fields!CompanyName.Value = "Alfred's","Red","Green") and it worked
> have you tried
> =(fields!Quality_status.Value)
> --
> 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
> "Debo" <debo@.discussions.microsoft.com> wrote in message
> news:835302E4-20F1-4D56-A738-9954ED6B346E@.microsoft.com...
> > I am writing a report that I need to return a background color for a cell
> in
> > a table. The background color depends on what color is named in another
> > cell. For example, if the cell (Quality_status.value) displays the word
> > Green then the cell (Quanity_status.value) background color needs to be
> > Green. I have tried several IIF expressions in the BackgroundColor
> > properties but none of them seem to work. Please help!!
> > --
> > Sincerely,
> >
> > Debo
> > --
> > Sincerely,
> >
> > Debo
>
>

Background Color for SQL Server Management Console

I am new to SQL server 2005 and I was wondering if there was a way to visually tell what server you are connected to other than the tab loacted at the top of the page. Something like changing the background color of the editor to red if you are connected to a production server so hopefully the user will not make unapproved changes in production. Please let me know if there is some feature like this out there. Thanks.There is no such feature.|||

Funnily enough, I was thinking along exactly the same lines as Jason. If no feature exists is it possible to do it programmatically, as an add-in? eg create an event handler that would set the background colour whenever a connection is made or changed, depending on the server or database connected to?

This strikes me as more the sort of thing for an add-in than a core feature.|||

Please post your feature requests at:

Suggestions for SQL Server

http://connect.microsoft.com/sqlserver

If enough folks like the idea, it may be incorporated in a feature set.

sql

Background Color for SQL Server Management Console

I am new to SQL server 2005 and I was wondering if there was a way to visually tell what server you are connected to other than the tab loacted at the top of the page. Something like changing the background color of the editor to red if you are connected to a production server so hopefully the user will not make unapproved changes in production. Please let me know if there is some feature like this out there. Thanks.There is no such feature.|||

Funnily enough, I was thinking along exactly the same lines as Jason. If no feature exists is it possible to do it programmatically, as an add-in? eg create an event handler that would set the background colour whenever a connection is made or changed, depending on the server or database connected to?

This strikes me as more the sort of thing for an add-in than a core feature.|||

Please post your feature requests at:

Suggestions for SQL Server

http://connect.microsoft.com/sqlserver

If enough folks like the idea, it may be incorporated in a feature set.

Background color for each first row in groups

I have a report that groups on departments. I want the first row for each
group to be light gray, while the row below it are white. Any suggestions?
ThanksIt has been a little while since you posted this question, but I think I have
an answer I discovered while researching a solution to one of my problems.
The RowNumber aggregate function might be helpful to you. Try the following
somewhere in your report to verify this will help:
RowNumber("group_name")
Try concatinating that to a text field on the row you want the coloring to
ultimately be on; I believe you will find that the first record in each group
has a 1. Presuming it does give you a 1 where you want it to be, all you
need to do then is select the row in question, and place the following
expression in the Background Color field (or any othr formatting field, like
Font Weight or Font Style):
=IIF( RowNumber("group_name") = 1 , "Light Gray" , "White" )
"PatNUFC" wrote:
> I have a report that groups on departments. I want the first row for each
> group to be light gray, while the row below it are white. Any suggestions?
> Thanks

Background color differences between Visual Studio & Reporting Services

I'm trying to deploy a report to Reporting Services, but I've found that there's a behaviour difference Visual Studio and Reporting Services with the Matrix control for the subtotals.

For the background color for the "textbox" on the cells, I've used the folowing expression:

=Iif(Fields!ID__vs_YAGO.Value < 1, "Red"

,Iif(Fields!ID__vs_YAGO.Value < 1.02, "Yellow"

,"GreenYellow"))

The individual cells alternate colors, based on the value in the cell. In Visual Studio, the Subtotal cells also alternate colors (which is correct). But when the report is deployed to Reporting Services, The Subtotal cells have a transparent background. (Incorrect).

If I set the same expression into the background setting for the Subtotal cells, the expression is evaluated once for the entire row and the entire row has the same color (different Subtotal lines will alternate). This is the same in both Visual Studio and Reporting Services.

I'm using SP2, 2005 (32 bit for Reporting Services). To ensure full compatibility, I've editted / deployed the report all on the same machine.

Does anyone know of this problem and how to resolve it?

Additional: In testing the various output formats, it seems to be a bug in the HTML rendering engine. PDF amd TIFF work fine. I believe Excel export uses either part of the HTML rendering engine or pieces of the same code base.

P.S. I'm detecting other reporting differences between Visual Studio and Reporting Services, such as how "null key records" (from Analysis Services) are handled in groups. Is there a compatibility list published somewhere?

I've been having the same issues. I have been pulling my hair out for weeks.

Things to add:

I noticed that when deployed to Reporting Services, if you export to a TIFF or PDF, you will get the intended result. However, displayed on the web, and when exported to excel, it gives the above problems.

Background color differences between Visual Studio & Reporting Services

I'm trying to deploy a report to Reporting Services, but I've found that there's a behaviour difference Visual Studio and Reporting Services with the Matrix control for the subtotals.

For the background color for the "textbox" on the cells, I've used the folowing expression:

=Iif(Fields!ID__vs_YAGO.Value < 1, "Red"

,Iif(Fields!ID__vs_YAGO.Value < 1.02, "Yellow"

,"GreenYellow"))

The individual cells alternate colors, based on the value in the cell. In Visual Studio, the Subtotal cells also alternate colors (which is correct). But when the report is deployed to Reporting Services, The Subtotal cells have a transparent background. (Incorrect).

If I set the same expression into the background setting for the Subtotal cells, the expression is evaluated once for the entire row and the entire row has the same color (different Subtotal lines will alternate). This is the same in both Visual Studio and Reporting Services.

I'm using SP2, 2005 (32 bit for Reporting Services). To ensure full compatibility, I've editted / deployed the report all on the same machine.

Does anyone know of this problem and how to resolve it?

Additional: In testing the various output formats, it seems to be a bug in the HTML rendering engine. PDF amd TIFF work fine. I believe Excel export uses either part of the HTML rendering engine or pieces of the same code base.

P.S. I'm detecting other reporting differences between Visual Studio and Reporting Services, such as how "null key records" (from Analysis Services) are handled in groups. Is there a compatibility list published somewhere?

I've been having the same issues. I have been pulling my hair out for weeks.

Things to add:

I noticed that when deployed to Reporting Services, if you export to a TIFF or PDF, you will get the intended result. However, displayed on the web, and when exported to excel, it gives the above problems.

background color change in table

Hello,

I have a table with a large detail section where i display numeric information

like this

accounting info help discount common

15 20 6 17 23

10 6 9 22 8

1 6 2 7 45

...

...

...

if the list is one page long the data is difficult to read

is there a way to work with two background colors (yellow and white) and that

the background changes automatically (yellow white yellow white ....)

i know i have to work with an expression in my background property of my textcell or row

but i haven't figured out yet how to do the change (i think by odd an even rows ... but that's just

a guess).

Can anybody give me some info ...

Thanks already

Vincent

It's possilble. The expression you are looking for is described in the following post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=483177&SiteID=1

Good luck,

Simone

sql

background color and background image after SP1

Hi,
after installing sp1 for sql server 2005 the properties "background
color" and "background image" do not show in HTML. They do show in TIF
or PDF export. Also the header and footer are rendered correctly in
HTML. Only the body of the report is always white!
Any suggestions?
Thank you
BennoI too am having this problem. I have found the following on the MS site. I
believe this applies to the problem, however, I have not tried this solution.
http://support.microsoft.com/?kbid=921395
"Benno" wrote:
> Hi,
> after installing sp1 for sql server 2005 the properties "background
> color" and "background image" do not show in HTML. They do show in TIF
> or PDF export. Also the header and footer are rendered correctly in
> HTML. Only the body of the report is always white!
> Any suggestions?
> Thank you
> Benno
>

Bacground Color of group

How do a change the alternate rows within a group.
ie i am grouping in a product type that also has a product numbers & value
on the same line. Since there is more than 1 product type there is multiple
rows within the group.
I have tried the formula iif(rownumber(nothing) Mod 2, "Red", "White")
But this doesnt seem to work.Although I do not know the answer, perhaps the problem is related to
rownumber(nothing)... I think the rownumber function applies to rows in the
data set... and I wonder if the GROUP lines do not get a rownumber with
(nothing) as the parameter... You might add the function to display in the
group field to check its value...
--
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:23069475-AA6E-42BA-9211-321A65D4C3CE@.microsoft.com...
> How do a change the alternate rows within a group.
> ie i am grouping in a product type that also has a product numbers & value
> on the same line. Since there is more than 1 product type there is
> multiple
> rows within the group.
> I have tried the formula iif(rownumber(nothing) Mod 2, "Red", "White")
> But this doesnt seem to work.|||Thanks Wayne,
I would have thought this to be a common problem...
"Wayne Snyder" wrote:
> Although I do not know the answer, perhaps the problem is related to
> rownumber(nothing)... I think the rownumber function applies to rows in the
> data set... and I wonder if the GROUP lines do not get a rownumber with
> (nothing) as the parameter... You might add the function to display in the
> group field to check its value...
> --
> 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:23069475-AA6E-42BA-9211-321A65D4C3CE@.microsoft.com...
> > How do a change the alternate rows within a group.
> >
> > ie i am grouping in a product type that also has a product numbers & value
> > on the same line. Since there is more than 1 product type there is
> > multiple
> > rows within the group.
> >
> > I have tried the formula iif(rownumber(nothing) Mod 2, "Red", "White")
> >
> > But this doesnt seem to work.
>
>