Alternate the background color of rows

Hi!

I 'm working whit a matrix.

I want alternate the background color of rows. I did with table, but I don't Know how do I do with matrix. I desire something like this:

column1

column2

row1

data1,1

data1,2

row2

data2,1

data2,2

row3

data3,1

data3,2

Please, if somebody can help me

Thanks

hey there

there is something on this page that may help you

http://blogs.msdn.com/chrishays/

|||

Specifically you want to read this blog article: http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx

-- Robert

|||

Robert, I've used the suggestions in Chris Hay's example. However, it only gets me 90% to where I need.

I cannot get the subtotal background color to alternate. Do you know a way to get this functionality. Kind of pointless and ugly to have everything alternate except the last column or row.

Alternate the background color of rows

Hi!

I 'm working whit a matrix.

I want alternate the background color of rows. I did with table, but I don't Know how do I do with matrix. I desire something like this:

column1

column2

row1

data1,1

data1,2

row2

data2,1

data2,2

row3

data3,1

data3,2

Please, if somebody can help me

Thanks

Please read this blog article: http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx

-- Robert

Alternate the background color of rows

Hi!

I 'm working whit a matrix.

I want alternate the background color of rows. I did with table, but I don't Know how do I do with matrix. I desire something like this:

column1 column2 row1 data1,1 data1,2 row2 data2,1 data2,2 row3 data3,1 data3,2

Please, if somebody can help me

Thanks

hey there

there is something on this page that may help you

http://blogs.msdn.com/chrishays/

|||

Specifically you want to read this blog article: http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx

-- Robert

|||

Robert, I've used the suggestions in Chris Hay's example. However, it only gets me 90% to where I need.

I cannot get the subtotal background color to alternate. Do you know a way to get this functionality. Kind of pointless and ugly to have everything alternate except the last column or row.

alter table

Hi All
How can I Change The column Name in The table whit out drop it
column_b -- to --column_c
ALTER TABLE doc_exa (ADD) column_b VARCHAR(20) NULLUse sp_rename:
EXEC sp_rename 'doc_exa.column_b' 'column_c' 'COLUMN'
But you'll need to modify all references to column_b to use column_c
Hope that helps,
Lubdha|||Hi Taha
Please look up sp_rename in the Books Online.
EXEC sp_rename 'doc_exa.column_b', 'column_c'
HTH
Kalen Delaney, SQL Server MVP
"Taha" <taha105@.hotmail.com> wrote in message
news:%23Iz0WE2jGHA.4504@.TK2MSFTNGP05.phx.gbl...
> Hi All
> How can I Change The column Name in The table whit out drop it
> column_b -- to --column_c
> ALTER TABLE doc_exa (ADD) column_b VARCHAR(20) NULL
>
>|||Thanks For Reply
When The Table Name Like [Table1] Its Work Fine
But When The Name Is [Table_1] Don't Work
Exec sp_rename 'Table1.[MyColumn]', 'NewName', 'COLUMN' Its Work
Exec sp_rename 'Table_1.[MyColumn]', 'NewName', 'COLUMN' Don't Work
Any idea
Thanks
"Taha" <taha105@.hotmail.com> wrote in message
news:%23Iz0WE2jGHA.4504@.TK2MSFTNGP05.phx.gbl...
> Hi All
> How can I Change The column Name in The table whit out drop it
> column_b -- to --column_c
> ALTER TABLE doc_exa (ADD) column_b VARCHAR(20) NULL
>
>|||This is The Message
Either the parameter @.objname is ambiguous or the claimed @.objtype (COLUMN)
is wrong.
"Taha" <taha105@.hotmail.com> wrote in message
news:%23Iz0WE2jGHA.4504@.TK2MSFTNGP05.phx.gbl...
> Hi All
> How can I Change The column Name in The table whit out drop it
> column_b -- to --column_c
> ALTER TABLE doc_exa (ADD) column_b VARCHAR(20) NULL
>
>|||Show us the sp_help output for the table.
HTH
Kalen Delaney, SQL Server MVP
"Taha" <taha105@.hotmail.com> wrote in message
news:OX6sG32jGHA.4512@.TK2MSFTNGP02.phx.gbl...
> This is The Message
> Either the parameter @.objname is ambiguous or the claimed @.objtype
> (COLUMN) is wrong.
>
>
> "Taha" <taha105@.hotmail.com> wrote in message
> news:%23Iz0WE2jGHA.4504@.TK2MSFTNGP05.phx.gbl...
>