Charts and colour control

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.