Showing posts with label colors. Show all posts
Showing posts with label colors. Show all posts

Tuesday, February 14, 2012

Colors in legend does not match bar graph

Hi

I have a bar graph with custom colors applied to it.
The custom colors displays nicely in the bar graph, but not in the legend.

The legend displays a mix of some of the "correct" custom colors, and some of the "wrong" standard colors. The colors in the legend vary, depending on the parameters passed to the report. Sometimes legend colors are all right, other times all wrong but must times a mix of right and wrongs.

The value for the custom color of the graph is retrieved from a field in the dataset. However I doubt that this is the cause of the error because, the bar graph colors are correct at all times, and I have validated thet correct color names are actually in the dataset.

Hope someone can help me out with this one...

/Henrik

The legend color always depends on the color of the first datapoint in a chart series.

Also, is a series grouping present in the chart? In that case you have to make sure that e.g. instead of using =Code.PickColor( Fields!ResultSort.Value), you should use this expression that uses the First() aggregate: =Code.PickColor(First(Fields!ResultSort.Value, "chart1_SeriesGroup1")

The important part is the aggregate scope which has to be identical to the chart series grouping name. Just using the First aggregate without the scope will give you incorrect results, because the aggregate will be just scoped for every chart datapoint (and therefore null if you don't have any datapoints for a particular series group / category group combination).

Another option you may consider is using a "custom legend" which is not drawn inside the chart but created by a table besides the chart. My sample and instructions for this can be found in the following blog article:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

-- Robert

|||

Thanks a lot Robert.
It was the aggregate scope I was missing. It's all working fine now.

/Henrik

|||

Does this apply for Gray Scale? I am having trouble when I set a chart to use Gray Scale the legend shows the first set of patterns but the remaining patterns are all random. I tried adding the scope to the Data section of the chart but it doesn't change the behavior with Gray Scale. Also, if it's a bug, is there a way that I can specify fill patterns in case I write a function to pick the pattern based on the series? Thanks!

Colors in legend does not match bar graph

Hi

I have a bar graph with custom colors applied to it.
The custom colors displays nicely in the bar graph, but not in the legend.

The legend displays a mix of some of the "correct" custom colors, and some of the "wrong" standard colors. The colors in the legend vary, depending on the parameters passed to the report. Sometimes legend colors are all right, other times all wrong but must times a mix of right and wrongs.

The value for the custom color of the graph is retrieved from a field in the dataset. However I doubt that this is the cause of the error because, the bar graph colors are correct at all times, and I have validated thet correct color names are actually in the dataset.

Hope someone can help me out with this one...

/Henrik

The legend color always depends on the color of the first datapoint in a chart series.

Also, is a series grouping present in the chart? In that case you have to make sure that e.g. instead of using =Code.PickColor( Fields!ResultSort.Value), you should use this expression that uses the First() aggregate: =Code.PickColor(First(Fields!ResultSort.Value, "chart1_SeriesGroup1")

The important part is the aggregate scope which has to be identical to the chart series grouping name. Just using the First aggregate without the scope will give you incorrect results, because the aggregate will be just scoped for every chart datapoint (and therefore null if you don't have any datapoints for a particular series group / category group combination).

Another option you may consider is using a "custom legend" which is not drawn inside the chart but created by a table besides the chart. My sample and instructions for this can be found in the following blog article:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

-- Robert

|||

Thanks a lot Robert.
It was the aggregate scope I was missing. It's all working fine now.

/Henrik

|||

Does this apply for Gray Scale? I am having trouble when I set a chart to use Gray Scale the legend shows the first set of patterns but the remaining patterns are all random. I tried adding the scope to the Data section of the chart but it doesn't change the behavior with Gray Scale. Also, if it's a bug, is there a way that I can specify fill patterns in case I write a function to pick the pattern based on the series? Thanks!

Colors in CR ...

Hi.

Is there a way ( most likely, but I'm unaware of ) to change the color of just a part of the text in Cr ?

For example: I have a filed which contains the word : Excellent ..

How can I tell Cr to print/display the word in black, except for the last two letters nt, which should be printed/displayed in, say, red ?

Thnx.If it's just a plain text field then yes, it's quite easy - just highlight the letters of the field you want in a different colour, and select Text Formatting.

However, I'm assuming you want it to be one of the dynamic database fields. There doesn't appear to be any functions in Formula Editor that are capable of changing text colour, so I don't think it is possible.

(One idea I had was to split the field into two separate formulas, but it doesn't appear that I can join the result of two text formulas back together. Perhaps you can build on this idea to come up with a solution).

Colors in Charts

Hi Ng,
I was wondering if there is a way to change the colors of the bars in a
chart. Or the colors of the pieces in a cake chart?
Thank in Advance
G. SchmelzerYou can control this from Chart properties dialog -> Data tab -> Values ->
Edit... -> Edit Chart Value dialog -> Appearance tab -> Series Style...
button -> Fill tab.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Georg Schmelzer" <asdf@.adsf.de> wrote in message
news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Hi Ng,
> I was wondering if there is a way to change the colors of the bars in a
> chart. Or the colors of the pieces in a cake chart?
> Thank in Advance
> G. Schmelzer
>|||Note: this will require SP1 installed on clients (report designer) and
report server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> You can control this from Chart properties dialog -> Data tab -> Values ->
> Edit... -> Edit Chart Value dialog -> Appearance tab -> Series Style...
> button -> Fill tab.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > Hi Ng,
> >
> > I was wondering if there is a way to change the colors of the bars in a
> > chart. Or the colors of the pieces in a cake chart?
> >
> > Thank in Advance
> >
> > G. Schmelzer
> >
> >
>|||Thank You.
The specified color on the "fill tab" is used for all chart items (f.e. all
bars, cake pieces, etc...). Let's say I want to change the color of bar1 to
red, bar2 to green and bar3 to pink. I would be like a user designed
"palette". But I found no information wether or how I can do this. Any Idea?
Thanks in advance
G. Schmelzer
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> Note: this will require SP1 installed on clients (report designer) and
> report server.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > You can control this from Chart properties dialog -> Data tab ->
Values ->
> > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series Style...
> > button -> Fill tab.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > Hi Ng,
> > >
> > > I was wondering if there is a way to change the colors of the bars in
a
> > > chart. Or the colors of the pieces in a cake chart?
> > >
> > > Thank in Advance
> > >
> > > G. Schmelzer
> > >
> > >
> >
> >
>|||Write an expression for Fill Color. You could use Choose() function:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctchoose.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Georg Schmelzer" <asdf@.adsf.de> wrote in message
news:%239AdRUheEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Thank You.
>
> The specified color on the "fill tab" is used for all chart items (f.e.
all
> bars, cake pieces, etc...). Let's say I want to change the color of bar1
to
> red, bar2 to green and bar3 to pink. I would be like a user designed
> "palette". But I found no information wether or how I can do this. Any
Idea?
> Thanks in advance
> G. Schmelzer
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
> Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> > Note: this will require SP1 installed on clients (report designer) and
> > report server.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
message
> > news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > > You can control this from Chart properties dialog -> Data tab ->
> Values ->
> > > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series
Style...
> > > button -> Fill tab.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > Hi Ng,
> > > >
> > > > I was wondering if there is a way to change the colors of the bars
in
> a
> > > > chart. Or the colors of the pieces in a cake chart?
> > > >
> > > > Thank in Advance
> > > >
> > > > G. Schmelzer
> > > >
> > > >
> > >
> > >
> >
> >
>|||It worked out fine.
Thanks a lot to you guys!!!
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> schrieb im
Newsbeitrag news:%23GTGGNoeEHA.2396@.TK2MSFTNGP11.phx.gbl...
> Write an expression for Fill Color. You could use Choose() function:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctchoose.asp.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> news:%239AdRUheEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > Thank You.
> >
> >
> > The specified color on the "fill tab" is used for all chart items (f.e.
> all
> > bars, cake pieces, etc...). Let's say I want to change the color of bar1
> to
> > red, bar2 to green and bar3 to pink. I would be like a user designed
> > "palette". But I found no information wether or how I can do this. Any
> Idea?
> >
> > Thanks in advance
> >
> > G. Schmelzer
> >
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
> > Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> > > Note: this will require SP1 installed on clients (report designer) and
> > > report server.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
> message
> > > news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > > > You can control this from Chart properties dialog -> Data tab ->
> > Values ->
> > > > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series
> Style...
> > > > button -> Fill tab.
> > > >
> > > > --
> > > > Ravi Mumulla (Microsoft)
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > > > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi Ng,
> > > > >
> > > > > I was wondering if there is a way to change the colors of the bars
> in
> > a
> > > > > chart. Or the colors of the pieces in a cake chart?
> > > > >
> > > > > Thank in Advance
> > > > >
> > > > > G. Schmelzer
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi Ng,
I was wondering if there is a way to change the orientation of headings on
X-axis of a chart from horizontal to vertical?
Please reply on this site or at the foll: email id : sp_kamath@.hotmail.com
Thank in Advance
SPK|||In RS 2000 the orientation of x-axis labels is determined automatically
based on the amount of space available. If labels cannot be drawn
horizontally in one line, and also not in two lines, they will be rotated
by -90 degrees.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SanjayK" <SanjayK@.discussions.microsoft.com> wrote in message
news:F876F44C-CEA6-4D90-9A73-A9C6721A563D@.microsoft.com...
> Hi Ng,
> I was wondering if there is a way to change the orientation of headings
on
> X-axis of a chart from horizontal to vertical?
> Please reply on this site or at the foll: email id : sp_kamath@.hotmail.com
> Thank in Advance
> SPK
>|||Hi Ng,
I was wondering if there is a way to display headings on Z axis of graph
since I am not getting any headings on this axis.
Please reply to this post or mail me at sp_kamath@.hotmail.com
Thank in Advance
Sanjay K|||Headings on the Z-axis are not available. You may want to look into using
the legend to provide a description for the series along the Z-axis.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SanjayK" <SanjayK@.discussions.microsoft.com> wrote in message
news:596FB267-23AE-4D98-A399-B5C76AF50000@.microsoft.com...
> Hi Ng,
> I was wondering if there is a way to display headings on Z axis of graph
> since I am not getting any headings on this axis.
> Please reply to this post or mail me at sp_kamath@.hotmail.com
> Thank in Advance
> Sanjay K
>|||Hi,
Even i want different bars to have customized colors but i am unable to set
it. Ravi has asked to use choose function.But i am unable to use it. please
let me know how to use it. You can mail me at kiran_nandedkar@.rediffmail.com
or reply at same post
Thanks in advance
Kiran
"Georg Schmelzer" wrote:
> It worked out fine.
> Thanks a lot to you guys!!!
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> schrieb im
> Newsbeitrag news:%23GTGGNoeEHA.2396@.TK2MSFTNGP11.phx.gbl...
> > Write an expression for Fill Color. You could use Choose() function:
> >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctchoose.asp.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > news:%239AdRUheEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > Thank You.
> > >
> > >
> > > The specified color on the "fill tab" is used for all chart items (f.e.
> > all
> > > bars, cake pieces, etc...). Let's say I want to change the color of bar1
> > to
> > > red, bar2 to green and bar3 to pink. I would be like a user designed
> > > "palette". But I found no information wether or how I can do this. Any
> > Idea?
> > >
> > > Thanks in advance
> > >
> > > G. Schmelzer
> > >
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
> > > Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> > > > Note: this will require SP1 installed on clients (report designer) and
> > > > report server.
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
> > message
> > > > news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > > > > You can control this from Chart properties dialog -> Data tab ->
> > > Values ->
> > > > > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series
> > Style...
> > > > > button -> Fill tab.
> > > > >
> > > > > --
> > > > > Ravi Mumulla (Microsoft)
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > > > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > > > > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > > > Hi Ng,
> > > > > >
> > > > > > I was wondering if there is a way to change the colors of the bars
> > in
> > > a
> > > > > > chart. Or the colors of the pieces in a cake chart?
> > > > > >
> > > > > > Thank in Advance
> > > > > >
> > > > > > G. Schmelzer
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Colors hadling with ReportViewer

Hello,
My doubt is how to change in a LocalReport environment the text color of a
textbox of a report depending on certain condition at runtime.
I will thank any help.
Sincerely,
Arturo Carrión
at Tiempo HardHello Arturo,
My understanding of this issue is: You have a reportviewer control using
the Local Report. And you want to control the color of a textbox in the
runtime. If I misunderstood your concern, please feel free to let me know.
Based on my research, you could only control the color in the report. You
could use the Expression to control the color.
Expressions Commonly Used in Reporting Services
http://msdn2.microsoft.com/en-us/ms157328.aspx
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Thanks Wei,
Until this moment, I have not been able to enter the link that you gave me
because it gives an error of "Server is too busy".
I will try it later, then I tell you.
Sincerely,
Arturo Carrión
at Tiempo Hard
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escribió en el mensaje
news:bmTJvs%23THHA.1860@.TK2MSFTNGHUB02.phx.gbl...
> Hello Arturo,
> My understanding of this issue is: You have a reportviewer control using
> the Local Report. And you want to control the color of a textbox in the
> runtime. If I misunderstood your concern, please feel free to let me know.
> Based on my research, you could only control the color in the report. You
> could use the Expression to control the color.
> Expressions Commonly Used in Reporting Services
> http://msdn2.microsoft.com/en-us/ms157328.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Jackpot!
I realized that most properties of a textbox accept an expression instead a
value.
Thanks, Wei
<tiempotecnologia@.newsgroup.nospam> escribió en el mensaje
news:eaynrmEUHHA.1636@.TK2MSFTNGP02.phx.gbl...
> Thanks Wei,
> Until this moment, I have not been able to enter the link that you gave me
> because it gives an error of "Server is too busy".
> I will try it later, then I tell you.
> Sincerely,
> Arturo Carrión
> at Tiempo Hard
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> escribió en el mensaje
> news:bmTJvs%23THHA.1860@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Arturo,
>> My understanding of this issue is: You have a reportviewer control using
>> the Local Report. And you want to control the color of a textbox in the
>> runtime. If I misunderstood your concern, please feel free to let me
>> know.
>> Based on my research, you could only control the color in the report. You
>> could use the Expression to control the color.
>> Expressions Commonly Used in Reporting Services
>> http://msdn2.microsoft.com/en-us/ms157328.aspx
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community 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.
>|||Hello Arturo,
Glad to hear the information is helpful.
If you have any question, please feel free to let me know.
Have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community 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.

Colors for Line Chart

Hi,
I have created a line chart with 3 different datafields. I want them to
have the colors yellow for the first, red for the second and blue for the
third. Is there anyway we can manipulate the colors on the chart? If there
is, can you kindly tell me how or point me in the direction of how to do
that?
Thank You,
RickyYou will need to have SP1 of RS 2000 installed on the server and designer
machines. In particular, read the following section of the SP1 readme file
about using colors in charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ricky" <kmeas1@.gmail.com> wrote in message
news:Oj5gfVHPFHA.3380@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have created a line chart with 3 different datafields. I want them to
> have the colors yellow for the first, red for the second and blue for the
> third. Is there anyway we can manipulate the colors on the chart? If
> there is, can you kindly tell me how or point me in the direction of how
> to do that?
> Thank You,
> Ricky
>

colors

Does anyone know if you can update background colors in RS 2005 using hex
values? It looks like you can only assign named colors. When I go to
custom colors and use the palette and assign a custom color, RS puts a hex
value in the expressio box, but it returns an error that it is an
un-recognized color.
Thanks
BillBill,
In theory you can use an expression for the background colour.
I have tried expressions like =rgb(255,0,255) which the Expression
Editor accepts as a syntactically correct expression. Stylistically
it's a bit overpowering! :)
However, although the expression shows in the textbox for the
BackgroundColor property in the Properties pane it is ignored when
previewing.
I assume it is a bug in September CTP.
Andrew Watt
MVP - InfoPath
On Mon, 17 Oct 2005 22:54:18 -0700, "wsaHarem" <spammers@.screwYou.com>
wrote:
>Does anyone know if you can update background colors in RS 2005 using hex
>values? It looks like you can only assign named colors. When I go to
>custom colors and use the palette and assign a custom color, RS puts a hex
>value in the expressio box, but it returns an error that it is an
>un-recognized color.
>Thanks
>Bill|||A color value in RDL is a either a color name or a hex HTML color string of
the form #HHHHHH. See also:
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/colors/colors.asp
If you want to use the RGB function, you would need to convert the resulting
integer into a string. I.e.
=String.Format("#{0:x6}",RGB(255, 0, 255))
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:m8i9l1l10dtp2c27q35bpdmmujkleb97mf@.4ax.com...
> Bill,
> In theory you can use an expression for the background colour.
> I have tried expressions like =rgb(255,0,255) which the Expression
> Editor accepts as a syntactically correct expression. Stylistically
> it's a bit overpowering! :)
> However, although the expression shows in the textbox for the
> BackgroundColor property in the Properties pane it is ignored when
> previewing.
> I assume it is a bug in September CTP.
> Andrew Watt
> MVP - InfoPath
>
> On Mon, 17 Oct 2005 22:54:18 -0700, "wsaHarem" <spammers@.screwYou.com>
> wrote:
>>Does anyone know if you can update background colors in RS 2005 using hex
>>values? It looks like you can only assign named colors. When I go to
>>custom colors and use the palette and assign a custom color, RS puts a hex
>>value in the expressio box, but it returns an error that it is an
>>un-recognized color.
>>Thanks
>>Bill
>|||Thanks, Robert.
Unfortunately the Expression Editor doesn't like your code (or my
attempts to correct it). Versions which the Expression Editor likes
seem to be ignored in display.
Nor have I found a way to express a custom colour using the Hex
notation that actually displays.
Any further suggestions?
Thanks
Andrew Watt
MVP - InfoPath
On Tue, 18 Oct 2005 19:54:20 -0700, "Robert Bruckner [MSFT]"
<robruc@.online.microsoft.com> wrote:
>A color value in RDL is a either a color name or a hex HTML color string of
>the form #HHHHHH. See also:
>http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/colors/colors.asp
>If you want to use the RGB function, you would need to convert the resulting
>integer into a string. I.e.
>=String.Format("#{0:x6}",RGB(255, 0, 255))
>
>-- Robert
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:m8i9l1l10dtp2c27q35bpdmmujkleb97mf@.4ax.com...
>> Bill,
>> In theory you can use an expression for the background colour.
>> I have tried expressions like =rgb(255,0,255) which the Expression
>> Editor accepts as a syntactically correct expression. Stylistically
>> it's a bit overpowering! :)
>> However, although the expression shows in the textbox for the
>> BackgroundColor property in the Properties pane it is ignored when
>> previewing.
>> I assume it is a bug in September CTP.
>> Andrew Watt
>> MVP - InfoPath
>>
>> On Mon, 17 Oct 2005 22:54:18 -0700, "wsaHarem" <spammers@.screwYou.com>
>> wrote:
>>Does anyone know if you can update background colors in RS 2005 using hex
>>values? It looks like you can only assign named colors. When I go to
>>custom colors and use the palette and assign a custom color, RS puts a hex
>>value in the expressio box, but it returns an error that it is an
>>un-recognized color.
>>Thanks
>>Bill
>|||The expression is valid - just try to run the report. The expression editor
marking the expression as invalid at design time is a bug.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:vifcl1t2g9o34g6utcdsphe3u1rq6vkcqn@.4ax.com...
> Thanks, Robert.
> Unfortunately the Expression Editor doesn't like your code (or my
> attempts to correct it). Versions which the Expression Editor likes
> seem to be ignored in display.
> Nor have I found a way to express a custom colour using the Hex
> notation that actually displays.
> Any further suggestions?
> Thanks
> Andrew Watt
> MVP - InfoPath
> On Tue, 18 Oct 2005 19:54:20 -0700, "Robert Bruckner [MSFT]"
> <robruc@.online.microsoft.com> wrote:
>>A color value in RDL is a either a color name or a hex HTML color string
>>of
>>the form #HHHHHH. See also:
>>http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/colors/colors.asp
>>If you want to use the RGB function, you would need to convert the
>>resulting
>>integer into a string. I.e.
>>=String.Format("#{0:x6}",RGB(255, 0, 255))
>>
>>-- Robert
>>This posting is provided "AS IS" with no warranties, and confers no
>>rights.
>>
>>
>>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>>news:m8i9l1l10dtp2c27q35bpdmmujkleb97mf@.4ax.com...
>> Bill,
>> In theory you can use an expression for the background colour.
>> I have tried expressions like =rgb(255,0,255) which the Expression
>> Editor accepts as a syntactically correct expression. Stylistically
>> it's a bit overpowering! :)
>> However, although the expression shows in the textbox for the
>> BackgroundColor property in the Properties pane it is ignored when
>> previewing.
>> I assume it is a bug in September CTP.
>> Andrew Watt
>> MVP - InfoPath
>>
>> On Mon, 17 Oct 2005 22:54:18 -0700, "wsaHarem" <spammers@.screwYou.com>
>> wrote:
>>Does anyone know if you can update background colors in RS 2005 using
>>hex
>>values? It looks like you can only assign named colors. When I go
>>to
>>custom colors and use the palette and assign a custom color, RS puts a
>>hex
>>value in the expressio box, but it returns an error that it is an
>>un-recognized color.
>>Thanks
>>Bill
>>
>|||Thanks, Robert.
There also seem to be bugs in the Layout tab and in the Preview tab
relating to this.
I will wait and see what the situation is in RTM then, if necessary,
post some bugs to Product Feedback Center then.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 09:29:49 -0700, "Robert Bruckner [MSFT]"
<robruc@.online.microsoft.com> wrote:
>The expression is valid - just try to run the report. The expression editor
>marking the expression as invalid at design time is a bug.
>-- Robert
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>news:vifcl1t2g9o34g6utcdsphe3u1rq6vkcqn@.4ax.com...
>> Thanks, Robert.
>> Unfortunately the Expression Editor doesn't like your code (or my
>> attempts to correct it). Versions which the Expression Editor likes
>> seem to be ignored in display.
>> Nor have I found a way to express a custom colour using the Hex
>> notation that actually displays.
>> Any further suggestions?
>> Thanks
>> Andrew Watt
>> MVP - InfoPath
>> On Tue, 18 Oct 2005 19:54:20 -0700, "Robert Bruckner [MSFT]"
>> <robruc@.online.microsoft.com> wrote:
>>A color value in RDL is a either a color name or a hex HTML color string
>>of
>>the form #HHHHHH. See also:
>>http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/colors/colors.asp
>>If you want to use the RGB function, you would need to convert the
>>resulting
>>integer into a string. I.e.
>>=String.Format("#{0:x6}",RGB(255, 0, 255))
>>
>>-- Robert
>>This posting is provided "AS IS" with no warranties, and confers no
>>rights.
>>
>>
>>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
>>news:m8i9l1l10dtp2c27q35bpdmmujkleb97mf@.4ax.com...
>> Bill,
>> In theory you can use an expression for the background colour.
>> I have tried expressions like =rgb(255,0,255) which the Expression
>> Editor accepts as a syntactically correct expression. Stylistically
>> it's a bit overpowering! :)
>> However, although the expression shows in the textbox for the
>> BackgroundColor property in the Properties pane it is ignored when
>> previewing.
>> I assume it is a bug in September CTP.
>> Andrew Watt
>> MVP - InfoPath
>>
>> On Mon, 17 Oct 2005 22:54:18 -0700, "wsaHarem" <spammers@.screwYou.com>
>> wrote:
>>Does anyone know if you can update background colors in RS 2005 using
>>hex
>>values? It looks like you can only assign named colors. When I go
>>to
>>custom colors and use the palette and assign a custom color, RS puts a
>>hex
>>value in the expressio box, but it returns an error that it is an
>>un-recognized color.
>>Thanks
>>Bill
>>
>

colors

Hello is there any way in a text box to make the text different colors?
For example,
if you have "Hello World"
I'd like "Hello" to be red and "World" to be green.
Thanks,No, the format applies to the whole control.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--

Coloring the mx value in a record set

Hi,
I have a simple report that displays several records having 2 fields, date
field and Quantity field
I ma,aged to alternate the colors of line (RosntBrown and black) bu I need
also to display the max Qty in a color different of the other ones, how this
can be achieved
ThanksHello eliassal,
You could add an Expression in the backgroundColor properties of the
textbox like this:
=IIF(ReportItems!Quantity.Value=MAX(Fields!Quantity.Value),"Black","Transpar
ent")
If is the max Qty, the background will be black and other will be
Transparent.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||So many thankls, it works like a charm. Now, how about displaying different
colors for Max and Min values for the same text box. can we use 2 expressions
at the same time on the same textbox containing thye field.
Thanks
"Wei Lu [MSFT]" wrote:
> Hello eliassal,
> You could add an Expression in the backgroundColor properties of the
> textbox like this:
>
> =IIF(ReportItems!Quantity.Value=MAX(Fields!Quantity.Value),"Black","Transpar
> ent")
> If is the max Qty, the background will be black and other will be
> Transparent.
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Hello eliassal,
Of course. You could do like this:
=IIF(ReportItems!Quantity.Value=MAX(Fields!Quantity.Value),"Black",IIF(Repor
tItems!Quantity.Value=min(fields!Quantity.Value),"Red","Transparent"))
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi, I was in vacation, I will check next week and let you know
Thanks
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>

Sunday, February 12, 2012

Color of the text inside a textbox

Hi,
is there any way by which i can give different colors to the text inside a
same textbox'
thanks
AtulNo, RS 2000 does not support this. It is on the wish list, basically we
plan to support RTF at some point.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Atul" <atul.anjankar@.approva.net> wrote in message
news:ea$RylMXEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> is there any way by which i can give different colors to the text inside a
> same textbox'
> thanks
> Atul
>|||No.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Atul" <atul.anjankar@.approva.net> wrote in message
news:ea$RylMXEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> is there any way by which i can give different colors to the text inside a
> same textbox'
> thanks
> Atul
>

Color of graphs

Hi,
Is it possible to change the colors of the graphs? Specially the series?
FréYes.
"Frederik Vanderhaeghe" <frederikvanderhaeghe@.gmail.com> wrote in message
news:uJxfU%23gjGHA.4504@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Is it possible to change the colors of the graphs? Specially the series?
> Fré
>|||And how?
Fré
"Tim Dot NoSpam" <Tim.NoSpam@.hughes.net> wrote in message
news:efOvK8ijGHA.4972@.TK2MSFTNGP05.phx.gbl...
> Yes.
> "Frederik Vanderhaeghe" <frederikvanderhaeghe@.gmail.com> wrote in message
> news:uJxfU%23gjGHA.4504@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> Is it possible to change the colors of the graphs? Specially the series?
>> Fré
>