Hello,
I wonder if it is possible to have better control over the colours than just
selecting the palette?
My problem is that I have several charts showing the same data series in
different time periods. But for some reason the same series get different
colours in the different charts. The report would look much more appealing
if the colours were consistent.
Many thanks in advance.
Best regards,
Vemund HagaHi Venmund,
Thanks for your post.
From your descriptions, I understood that you would like to set the colors
in the report manually when those series to be the same. Have I understood
you? Correct me if I was wrong.
Based on my scope, unfortunately, I am afraid SQL Server 2000 Reporting
Services only supports palette color selection. Additional functionality in
this area is still under consideration
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||"Vemund Haga" wrote:
> Hello,
> I wonder if it is possible to have better control over the colours than just
> selecting the palette?
You can manually set the colour of each series in the graph properties. See
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Hi Glenn
I'm having this same problem and after reading some other related posts I
came to the following conclusion:
Although one can write an expression to control the colors in the Fill
property of the Series Style but this expression will have to be based on the
fixed number of possible values in the Series Groups. The expression can end
with "Transparent" value if non of the conditions in the expression are
satisfied but that is about it.
Is this correct?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||"Shawn Kralj" wrote:
> Although one can write an expression to control the colors in the Fill
> property of the Series Style but this expression will have to be based on the
> fixed number of possible values in the Series Groups. The expression can end
> with "Transparent" value if non of the conditions in the expression are
> satisfied but that is about it.
> Is this correct?
I'm sorry, but I'm not quite understanding what you are trying to do here.
Why don't you explain what you want to obtain instead, the desired effect.
--
Glenn F. Henriksen
http://www.henriksen.no/|||Hi Venmund,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. Have you read
the blog Glenn provided? We appreciate your patience and look forward to
hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Glenn
I have a Series Group in my report based on Sales Category field values.
There are 5 sales categories, and if I want to assign custom color to chart
bars for each category my expression will have to include a logical test and
assignment of custom color for each category.
I did get it to work but I want to make sure I'm doing it in the most
efficient way. I assigned a number to each category in my query (from 1 to 5)
and I can now use a Choose method to assign colors easily.
My expression is as follows:
=choose(First(Fields!SalesCategoryCode.Value, "chart1_SeriesGroup1"),
"Navy", "White", "Blue", "Yellow", "Black")
Is this the best way of doing it?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Shawn Kralj" wrote:
> > Although one can write an expression to control the colors in the Fill
> > property of the Series Style but this expression will have to be based on the
> > fixed number of possible values in the Series Groups. The expression can end
> > with "Transparent" value if non of the conditions in the expression are
> > satisfied but that is about it.
> >
> > Is this correct?
> I'm sorry, but I'm not quite understanding what you are trying to do here.
> Why don't you explain what you want to obtain instead, the desired effect.
> --
> Glenn F. Henriksen
> http://www.henriksen.no/|||Hi Genn
I have a series group in the report. I customized the color of each bar,
and it looks exactly like what i need in VS.net. After I depolyed to the
report server, however, it ignored the customized color and used default
color instead. Is there any way to solve the problem'
Thanks a lot.
Sean
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Are you sure you have SP1 installed on the report server (not only on the
report designer machine)?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:2DB7DF0D-419D-424C-A924-B61786518442@.microsoft.com...
> Hi Genn
> I have a series group in the report. I customized the color of each bar,
> and it looks exactly like what i need in VS.net. After I depolyed to the
> report server, however, it ignored the customized color and used default
> color instead. Is there any way to solve the problem'
> Thanks a lot.
> Sean
> "Glenn F. Henriksen" wrote:
> > "Vemund Haga" wrote:
> > > Hello,
> > > I wonder if it is possible to have better control over the colours
than just
> > > selecting the palette?
> >
> > You can manually set the colour of each series in the graph properties.
See
> >
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.
Showing posts with label palette. Show all posts
Showing posts with label palette. Show all posts
Saturday, February 25, 2012
Sunday, February 19, 2012
Chart Custom Series Color Problem
We want to use the default palette for all series groups except the first
one, but when we change the bar color of
the first group, all the groups suddenly become the color we set. This works
fine if we change the background for any other group (not the first group).
Is there any way to get around this?
Example:
This makes all of the columns for all of the groups Orange (#FF9933)
=IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
"#FF9933","Transparent")
This works as expected - except it is on the second group.
=IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
"#FF9933","Transparent")
The data that we want to have custom colored has to be the first set.I'm not sure I understand the issue correctly - but the aggregate scope in
the expression seems incorrect. Instead of scoping with the category
grouping, you should scope with the series grouping (assuming there is a
series grouping in the chart).
E.g.:
=IIF( First(Fields!NUM.Value, "chart1_SeriesGroup1") = "2",
"#FF9933","Transparent")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"debra doty" <debradoty@.discussions.microsoft.com> wrote in message
news:27C5AC1A-8AAC-41A6-BF0B-29FC932AC720@.microsoft.com...
> We want to use the default palette for all series groups except the first
> one, but when we change the bar color of
> the first group, all the groups suddenly become the color we set. This
works
> fine if we change the background for any other group (not the first
group).
> Is there any way to get around this?
> Example:
> This makes all of the columns for all of the groups Orange (#FF9933)
> =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
> "#FF9933","Transparent")
> This works as expected - except it is on the second group.
> =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
> "#FF9933","Transparent")
> The data that we want to have custom colored has to be the first set.
>|||Sorry, I copy/pasted my last desperate attempt at getting this to work.
We did use the series grouping scope, it didn't make any difference. In one
report, we group the data by the day of week. The week starts on Sun. We
want all columns in the Sun group to have a backgroud of orange and the rest
of the week to use the default palette. If we make Tues orange this works
fine - but because Sun is the first group, all the columns in all the groups
become orange.
"Robert Bruckner [MSFT]" wrote:
> I'm not sure I understand the issue correctly - but the aggregate scope in
> the expression seems incorrect. Instead of scoping with the category
> grouping, you should scope with the series grouping (assuming there is a
> series grouping in the chart).
> E.g.:
> =IIF( First(Fields!NUM.Value, "chart1_SeriesGroup1") = "2",
> "#FF9933","Transparent")
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "debra doty" <debradoty@.discussions.microsoft.com> wrote in message
> news:27C5AC1A-8AAC-41A6-BF0B-29FC932AC720@.microsoft.com...
> > We want to use the default palette for all series groups except the first
> > one, but when we change the bar color of
> > the first group, all the groups suddenly become the color we set. This
> works
> > fine if we change the background for any other group (not the first
> group).
> > Is there any way to get around this?
> >
> > Example:
> > This makes all of the columns for all of the groups Orange (#FF9933)
> > =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
> > "#FF9933","Transparent")
> >
> > This works as expected - except it is on the second group.
> > =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
> > "#FF9933","Transparent")
> >
> > The data that we want to have custom colored has to be the first set.
> >
>
>
one, but when we change the bar color of
the first group, all the groups suddenly become the color we set. This works
fine if we change the background for any other group (not the first group).
Is there any way to get around this?
Example:
This makes all of the columns for all of the groups Orange (#FF9933)
=IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
"#FF9933","Transparent")
This works as expected - except it is on the second group.
=IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
"#FF9933","Transparent")
The data that we want to have custom colored has to be the first set.I'm not sure I understand the issue correctly - but the aggregate scope in
the expression seems incorrect. Instead of scoping with the category
grouping, you should scope with the series grouping (assuming there is a
series grouping in the chart).
E.g.:
=IIF( First(Fields!NUM.Value, "chart1_SeriesGroup1") = "2",
"#FF9933","Transparent")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"debra doty" <debradoty@.discussions.microsoft.com> wrote in message
news:27C5AC1A-8AAC-41A6-BF0B-29FC932AC720@.microsoft.com...
> We want to use the default palette for all series groups except the first
> one, but when we change the bar color of
> the first group, all the groups suddenly become the color we set. This
works
> fine if we change the background for any other group (not the first
group).
> Is there any way to get around this?
> Example:
> This makes all of the columns for all of the groups Orange (#FF9933)
> =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
> "#FF9933","Transparent")
> This works as expected - except it is on the second group.
> =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
> "#FF9933","Transparent")
> The data that we want to have custom colored has to be the first set.
>|||Sorry, I copy/pasted my last desperate attempt at getting this to work.
We did use the series grouping scope, it didn't make any difference. In one
report, we group the data by the day of week. The week starts on Sun. We
want all columns in the Sun group to have a backgroud of orange and the rest
of the week to use the default palette. If we make Tues orange this works
fine - but because Sun is the first group, all the columns in all the groups
become orange.
"Robert Bruckner [MSFT]" wrote:
> I'm not sure I understand the issue correctly - but the aggregate scope in
> the expression seems incorrect. Instead of scoping with the category
> grouping, you should scope with the series grouping (assuming there is a
> series grouping in the chart).
> E.g.:
> =IIF( First(Fields!NUM.Value, "chart1_SeriesGroup1") = "2",
> "#FF9933","Transparent")
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "debra doty" <debradoty@.discussions.microsoft.com> wrote in message
> news:27C5AC1A-8AAC-41A6-BF0B-29FC932AC720@.microsoft.com...
> > We want to use the default palette for all series groups except the first
> > one, but when we change the bar color of
> > the first group, all the groups suddenly become the color we set. This
> works
> > fine if we change the background for any other group (not the first
> group).
> > Is there any way to get around this?
> >
> > Example:
> > This makes all of the columns for all of the groups Orange (#FF9933)
> > =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
> > "#FF9933","Transparent")
> >
> > This works as expected - except it is on the second group.
> > =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
> > "#FF9933","Transparent")
> >
> > The data that we want to have custom colored has to be the first set.
> >
>
>
Chart Color Sequence (Default Palette)
Hi,
Does anyone know where I can get the series color sequence for the
chart generated? For example, if I have 2 items on the chart, the first
one is in green and the next one will be in blue.
Thanks.
-- JordanMost of the provided chart color palettes have 16 distinct colors. As you
have noticed, the default palette always start with green, blue, magenta,
etc.
Every chart series (essentially legend item) gets its own color. The
following blog article shows an example of how to use your own color
palette. It also uses a custom legend that this is probably not what you are
looking for - you could just rely on the built-in chart legend.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
You can also download my sample from the blog article.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jordan" <jordanm@.37.com> wrote in message
news:1119838129.392646.116360@.g43g2000cwa.googlegroups.com...
> Hi,
> Does anyone know where I can get the series color sequence for the
> chart generated? For example, if I have 2 items on the chart, the first
> one is in green and the next one will be in blue.
> Thanks.
> -- Jordan
>|||Hi,
Thanks for your reply. I came across your article and it sort of gives
me an idea on how to achieve my required report format (stacked chart
and line). I am using the default color palette and I need to know the
color sequence so that I can built my own legend to represent the chart
generated. I need to know at least 30 of the first color sequence in
order for my charts and legend to display correctly.
Thanks.
Jordan|||Hello Robert,
I'm running RS SP2 and have long known how to easily specify certain
colors be assigned to specic colors. What I have not figured out is how to
make these programatically assigned series colors semi-transparent like the
default series colors in a stacked bar chart. Is this possible?|||Sorry, semi-transparent colors are not possible through RDL at this point.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Parker" <BrianParker@.discussions.microsoft.com> wrote in message
news:DD7D9299-87A8-4625-97FF-7178DB004A9A@.microsoft.com...
> Hello Robert,
> I'm running RS SP2 and have long known how to easily specify certain
> colors be assigned to specic colors. What I have not figured out is how
> to
> make these programatically assigned series colors semi-transparent like
> the
> default series colors in a stacked bar chart. Is this possible?
Does anyone know where I can get the series color sequence for the
chart generated? For example, if I have 2 items on the chart, the first
one is in green and the next one will be in blue.
Thanks.
-- JordanMost of the provided chart color palettes have 16 distinct colors. As you
have noticed, the default palette always start with green, blue, magenta,
etc.
Every chart series (essentially legend item) gets its own color. The
following blog article shows an example of how to use your own color
palette. It also uses a custom legend that this is probably not what you are
looking for - you could just rely on the built-in chart legend.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
You can also download my sample from the blog article.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jordan" <jordanm@.37.com> wrote in message
news:1119838129.392646.116360@.g43g2000cwa.googlegroups.com...
> Hi,
> Does anyone know where I can get the series color sequence for the
> chart generated? For example, if I have 2 items on the chart, the first
> one is in green and the next one will be in blue.
> Thanks.
> -- Jordan
>|||Hi,
Thanks for your reply. I came across your article and it sort of gives
me an idea on how to achieve my required report format (stacked chart
and line). I am using the default color palette and I need to know the
color sequence so that I can built my own legend to represent the chart
generated. I need to know at least 30 of the first color sequence in
order for my charts and legend to display correctly.
Thanks.
Jordan|||Hello Robert,
I'm running RS SP2 and have long known how to easily specify certain
colors be assigned to specic colors. What I have not figured out is how to
make these programatically assigned series colors semi-transparent like the
default series colors in a stacked bar chart. Is this possible?|||Sorry, semi-transparent colors are not possible through RDL at this point.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Parker" <BrianParker@.discussions.microsoft.com> wrote in message
news:DD7D9299-87A8-4625-97FF-7178DB004A9A@.microsoft.com...
> Hello Robert,
> I'm running RS SP2 and have long known how to easily specify certain
> colors be assigned to specic colors. What I have not figured out is how
> to
> make these programatically assigned series colors semi-transparent like
> the
> default series colors in a stacked bar chart. Is this possible?
Subscribe to:
Posts (Atom)