Hi everyone!
Is it possible to changes the background color for each row? People coding
asp.net would know this as "AlternatingItemStyle" in a datagrid.
Can this be done using the VS IDE or do I have to go behind the code in the
rdl file?
Best Regards
Jesper.Hello Jesper,
you can put the following into the Background-property in VS IDE:
Backgroundcolor
=IIF(RowNumber("<table1>") Mod 2, "<color1>", "<color2>")
That's all.
Stefan
"Jesper Jensen" <jbj@.union.dk> schrieb im Newsbeitrag
news:egG1HdNrHHA.1204@.TK2MSFTNGP04.phx.gbl...
> Hi everyone!
> Is it possible to changes the background color for each row? People coding
> asp.net would know this as "AlternatingItemStyle" in a datagrid.
> Can this be done using the VS IDE or do I have to go behind the code in
> the rdl file?
> Best Regards
> Jesper.
>|||Hello Stefan
So simple and so powerfull.
Thank you very much!!!!!
Best Regards
Jesper
"Stefan" <stefan@.nospam.nospam> wrote in message
news:eqki9NOrHHA.1168@.TK2MSFTNGP03.phx.gbl...
> Hello Jesper,
> you can put the following into the Background-property in VS IDE:
> Backgroundcolor
>
> =IIF(RowNumber("<table1>") Mod 2, "<color1>", "<color2>")
>
> That's all.
>
> Stefan
>
> "Jesper Jensen" <jbj@.union.dk> schrieb im Newsbeitrag
> news:egG1HdNrHHA.1204@.TK2MSFTNGP04.phx.gbl...
>> Hi everyone!
>> Is it possible to changes the background color for each row? People
>> coding asp.net would know this as "AlternatingItemStyle" in a datagrid.
>> Can this be done using the VS IDE or do I have to go behind the code in
>> the rdl file?
>> Best Regards
>> Jesper.
>
Showing posts with label colors. Show all posts
Showing posts with label colors. Show all posts
Wednesday, March 7, 2012
Sunday, February 19, 2012
Different Colors for Values
Hi NG,
i want different colors for the values in my drilldown-tables
i.e.
if value < 0 the values should be red
if value > 0 the values should be black
any suggests?
frankHI
Go to Properties > Color > Expression
And type: =iif(value < 0, â'redâ', â'blackâ')
:-)
"Frank Matthiesen" wrote:
> Hi NG,
> i want different colors for the values in my drilldown-tables
> i.e.
> if value < 0 the values should be red
> if value > 0 the values should be black
> any suggests?
>
> frank
>
>|||Soan wrote:
> Go to Properties > Color > Expression
> And type: =iif(value < 0, "red", "black")
oh man...so easy!
top...thx a lot
frank|||Folks,
I can't get line color changes to appear in a line chart. Did SP1 provide
color control for the Line chart as well?
Thanks,
Chris
"Frank Matthiesen" wrote:
> Soan wrote:
> > Go to Properties > Color > Expression
> > And type: =iif(value < 0, "red", "black")
> oh man...so easy!
> top...thx a lot
> frank
>
>|||For line charts, the line border color property is what you are looking for.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:D655C59C-1B8F-4BC3-A9D3-6FD3CA409F79@.microsoft.com...
> Folks,
> I can't get line color changes to appear in a line chart. Did SP1 provide
> color control for the Line chart as well?
> Thanks,
> Chris
> "Frank Matthiesen" wrote:
> > Soan wrote:
> > > Go to Properties > Color > Expression
> > > And type: =iif(value < 0, "red", "black")
> >
> > oh man...so easy!
> > top...thx a lot
> >
> > frank
> >
> >
> >
i want different colors for the values in my drilldown-tables
i.e.
if value < 0 the values should be red
if value > 0 the values should be black
any suggests?
frankHI
Go to Properties > Color > Expression
And type: =iif(value < 0, â'redâ', â'blackâ')
:-)
"Frank Matthiesen" wrote:
> Hi NG,
> i want different colors for the values in my drilldown-tables
> i.e.
> if value < 0 the values should be red
> if value > 0 the values should be black
> any suggests?
>
> frank
>
>|||Soan wrote:
> Go to Properties > Color > Expression
> And type: =iif(value < 0, "red", "black")
oh man...so easy!
top...thx a lot
frank|||Folks,
I can't get line color changes to appear in a line chart. Did SP1 provide
color control for the Line chart as well?
Thanks,
Chris
"Frank Matthiesen" wrote:
> Soan wrote:
> > Go to Properties > Color > Expression
> > And type: =iif(value < 0, "red", "black")
> oh man...so easy!
> top...thx a lot
> frank
>
>|||For line charts, the line border color property is what you are looking for.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:D655C59C-1B8F-4BC3-A9D3-6FD3CA409F79@.microsoft.com...
> Folks,
> I can't get line color changes to appear in a line chart. Did SP1 provide
> color control for the Line chart as well?
> Thanks,
> Chris
> "Frank Matthiesen" wrote:
> > Soan wrote:
> > > Go to Properties > Color > Expression
> > > And type: =iif(value < 0, "red", "black")
> >
> > oh man...so easy!
> > top...thx a lot
> >
> > frank
> >
> >
> >
different colors for a matrix
Hi.
I have a matrix containing 3 row groups and 2 column groups and of course a detail area.
I want to show the detail area in different colors according to the row number.For example
1. row -->blue
2. row -->green
3. row -->blue
I have a matrix containing 3 row groups and 2 column groups and of course a detail area.
I want to show the detail area in different colors according to the row number.For example
1. row -->blue
2. row -->green
3. row -->blue
4. row -->green
5. row -->blue
6. row -->green
and so this goes....
I used the =IIF(RunningValue(FieldName, CountDistinct, "matrix1") Mod 2 , color1, color2)
for the detail's backgroundColor property
But it didn't work as I want.This caused a result like this:
1. row -->blue
2. row -->blue
3. row -->blue
4. row -->green
5. row -->blue
6. row -->green
.......
And I didn't understand how it works.
How could I do this.Which group name should I use in the formula?
Or do you have another idea for this problem?
Hi,
Chris Hayes blog has all the details you need:
http://blogs.msdn.com/chrishays/
Regards,
Sanjay
Subscribe to:
Posts (Atom)