Showing posts with label series. Show all posts
Showing posts with label series. Show all posts

Thursday, March 8, 2012

Check box insert question

I have 3 tables - Data, Facility and FacilityKey

The FacilityKey table will hold the Data ID and Facility ID based on a series of check boxes on a form.

My question is what is the best way to do the insert into the FacilityKey table from the form? If 5 facilities are checked I don't want to do 5 separate calls to the database for inserts, but I'm a bit confused on what the best method would be.

Thank you!I can't really think of any other way. You're going to need to call 5 INSERT statements, each inserting a single row. You can use the one connection to do this. To be honest, I don't think SQL Server is going to struggle with this.

Cheers
Ken

Posted by Rhonda at 9:31 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Saturday, February 25, 2012

chart Y-Axis dynamic maximum

Hello,
I got a bar chart, it shows percentages up to...yes 100%.
Usually, their is a series which are 20-30%, but once in a while
I get one value which is 100%.
If I leave the maximum unset...the bar chart resizes so that the area
show differences better for 20-30% series, however if a single 100%
value comes then the upper limit of the Y-Axis goes above 100%.
If I set the maximum then obviously the series of 20-30% look all
small...
Any ideas for putting in some expression into the maximum?
Thanks,
MattUnfortunately you cannot use expressions for the max and min (I too wanted
this). This feature will be available in RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1116341493.581592.139110@.f14g2000cwb.googlegroups.com...
> Hello,
> I got a bar chart, it shows percentages up to...yes 100%.
> Usually, their is a series which are 20-30%, but once in a while
> I get one value which is 100%.
> If I leave the maximum unset...the bar chart resizes so that the area
> show differences better for 20-30% series, however if a single 100%
> value comes then the upper limit of the Y-Axis goes above 100%.
> If I set the maximum then obviously the series of 20-30% look all
> small...
> Any ideas for putting in some expression into the maximum?
> Thanks,
> Matt
>
Posted by Rhonda at 9:59 PM 0 comments
Labels: , , , , , , , , , , , , , ,

Chart with 3 year series

Hello
I have a dataset with a date field and a value field. I wish to display the
value fields for current year as well as the previous 2 years together with
different colours on the same month interval on the X-axis. Can someone lend
a hand on how to do this?
thanks in advance
Chris PulfordExample is attached below. The basic idea is to group by months on the
categories and group by year on the series.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="Sales">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style />
<Legend>
<Visible>true</Visible>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Color>Brown</Color>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Pastel</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitPrice.Value *
Fields!Quantity.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Style>
<BorderWidth>
<Default>6pt</Default>
</BorderWidth>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title>
<Style />
</Title>
<Style />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>100</PointWidth>
<Type>Line</Type>
<Title>
<Caption>Sales</Caption>
<Style>
<FontSize>14pt</FontSize>
<FontWeight>700</FontWeight>
</Style>
</Title>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="Sales_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Month(Fields!OrderDate.Value)</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Month(Fields!OrderDate.Value)</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=MonthName(Month(Fields!OrderDate.Value))</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Height>6.125in</Height>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="Sales_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Year(Fields!OrderDate.Value)</GroupExpression>
</GroupExpressions>
</Grouping>
<Label />
</DynamicSeries>
</SeriesGrouping>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Sales</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundGradientEndColor>White</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title>
<Style />
</Title>
<Style />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<MinorTickMarks>Outside</MinorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>6.5in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>da5964d0-11a7-4e51-9b22-cc4fa55fdd7a</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="Quantity">
<DataField>Quantity</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="OrderDate">
<DataField>OrderDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT [Order Details].UnitPrice, [Order
Details].Quantity, Orders.OrderDate
FROM Orders INNER JOIN
[Order Details] ON Orders.OrderID = [Order
Details].OrderID</CommandText>
<Timeout>30</Timeout>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>bc811835-2302-4f9e-9c89-a99d4d3f5fd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
</Report>
Posted by Rhonda at 9:58 PM 0 comments
Labels: , , , , , , , , , , , , , , ,

Friday, February 24, 2012

Chart Series with Different Scales

Hi all,
If you have a chart and want to relate to different series, that have
different scales ie Number of Sales, and Revenue, per Day. Can you have
different axis scales so that 'number of sales ' is not scaled down to near
invisiblity.
I'm Working arround it by having two charts, but there should be a way to
have the two series on the same bar-chart.
AdrianSorry, secondary y-axis is currently not supported. Using two charts - as
you are already doing - is the best approach at this point.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"AdrianJMartin" <AdrianJMartin@.discussions.microsoft.com> wrote in message
news:2B313783-46EF-4942-80CE-AC193555E1D4@.microsoft.com...
> Hi all,
> If you have a chart and want to relate to different series, that have
> different scales ie Number of Sales, and Revenue, per Day. Can you have
> different axis scales so that 'number of sales ' is not scaled down to
> near
> invisiblity.
> I'm Working arround it by having two charts, but there should be a way to
> have the two series on the same bar-chart.
>
> Adrian|||I want to write an expression on major grid line how do i write
"Robert Bruckner [MSFT]" wrote:
> Sorry, secondary y-axis is currently not supported. Using two charts - as
> you are already doing - is the best approach at this point.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "AdrianJMartin" <AdrianJMartin@.discussions.microsoft.com> wrote in message
> news:2B313783-46EF-4942-80CE-AC193555E1D4@.microsoft.com...
> > Hi all,
> > If you have a chart and want to relate to different series, that have
> > different scales ie Number of Sales, and Revenue, per Day. Can you have
> > different axis scales so that 'number of sales ' is not scaled down to
> > near
> > invisiblity.
> >
> > I'm Working arround it by having two charts, but there should be a way to
> > have the two series on the same bar-chart.
> >
> >
> > Adrian
>
>|||I was able to develop a way to simulate a second y axis. In my case the data
source was a cube. I had two types of series, one with large, whole numbers,
and one with percentages, which caused the percentages to be at the zero
point when displayed with the other type of series. My solution was to write
a calculated member that found the maximum value of the whole number series
for all rows, and to round that value up to the next highest number.
Therefore, if the series returned 8,235 as the maximum value in any row, the
result of my calculated member would be 9,000. The 9,000 value of the
calculated member was returned for every row. In the graph I used the value
property of the percentage series to multiply the actual value by my
calculated member value. I used the label property to obtain the actual
percentage value. Thus, 80% became .8 * 9000 for plotting purposes, but the
data point label said 80%. The result was a successful combination of the
two very different types of series. The only thing that I could not do
without a true second y axis was having the tick marks and labels of a second
axis along the right side of the graph.
--
Brian C. Berg
MCSE+I, MCDBA
Berg Information Technology, Inc.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" wrote:
> Sorry, secondary y-axis is currently not supported. Using two charts - as
> you are already doing - is the best approach at this point.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "AdrianJMartin" <AdrianJMartin@.discussions.microsoft.com> wrote in message
> news:2B313783-46EF-4942-80CE-AC193555E1D4@.microsoft.com...
> > Hi all,
> > If you have a chart and want to relate to different series, that have
> > different scales ie Number of Sales, and Revenue, per Day. Can you have
> > different axis scales so that 'number of sales ' is not scaled down to
> > near
> > invisiblity.
> >
> > I'm Working arround it by having two charts, but there should be a way to
> > have the two series on the same bar-chart.
> >
> >
> > Adrian
>
>
Posted by Rhonda at 1:57 AM 0 comments
Labels: , , , , , , , , , , , ,

chart series with different colors

hello, my english is not to well.
i Have a chart (columns) I need set de colors of my columns
How can a do that?
thanks !chart properties-> Data tab ->
Add values -> select that value -> click on Edit button
it will popup another window-> there select apperance tab-> there click on
series style button->it will popup another window -> there select your own
color
Regards,
Sri
"Lorein" wrote:
> hello, my english is not to well.
> i Have a chart (columns) I need set de colors of my columns
> How can a do that?
> thanks !|||Hello Sriman, thanks for your answer.
I don´t have that option in Data tab => values => Edit =>apperance
I am developing the report with Microsoft Visual Studio .Net 2003,
Perhaps for that reason I do not have the option, can be?
thanks again !!!!
Lorein.
"Sriman" wrote:
> chart properties-> Data tab ->
> Add values -> select that value -> click on Edit button
> it will popup another window-> there select apperance tab-> there click on
> series style button->it will popup another window -> there select your own
> color
> Regards,
> Sri
> "Lorein" wrote:
> > hello, my english is not to well.
> > i Have a chart (columns) I need set de colors of my columns
> > How can a do that?
> > thanks !
Posted by Rhonda at 1:57 AM 0 comments
Labels: , , , , , , , , , ,

Chart Series Total

I have a chart on one of my reports that has two series as a stracked bar
chart, and displays two point labels on each bar for the series value. What
I'd like to do is show the series value as a percentage relative to the total
bar value. The real problem here is I don't know how to get programmatically
get at the value shown in the point label, since this value calculated by
reporting services and not in my query (i.e. my query returns the total for
each bar, and SRS breaks it down into the two series values).
Any help would be appreciated.I haven't done many charts but can't you reference the label by
ReportItems!LabelName.Value.....I don't know if this is what you are looking
for.
"blabore" wrote:
> I have a chart on one of my reports that has two series as a stracked bar
> chart, and displays two point labels on each bar for the series value. What
> I'd like to do is show the series value as a percentage relative to the total
> bar value. The real problem here is I don't know how to get programmatically
> get at the value shown in the point label, since this value calculated by
> reporting services and not in my query (i.e. my query returns the total for
> each bar, and SRS breaks it down into the two series values).
> Any help would be appreciated.
Posted by Rhonda at 1:57 AM 0 comments
Labels: , , , , , , , , , , , , , , ,

chart series

Is it possible to chart one data series as a line and another as a bar on the
same graph. Other tools allow this and I have been asked to do it - I dont
see how it is possible since you define the graph as either line or bar to
begin with.Yes, you can do that. Create your column chart. Then go to the chart
properties dialog. In the dialog go to the Data tab and edit the properties
of your trend data series. The "Edit chart value" dialog should pop up. In
this dialog go to the Appearance tab and select "Plot data as line".
You can also check the following KB article:
http://support.microsoft.com/kb/842422
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:EAE49F79-5B1D-4E42-850B-6C08671546CA@.microsoft.com...
> Is it possible to chart one data series as a line and another as a bar on
> the
> same graph. Other tools allow this and I have been asked to do it - I
> dont
> see how it is possible since you define the graph as either line or bar to
> begin with.
Posted by Rhonda at 1:57 AM 0 comments
Labels: , , , , , , , , , , ,

chart series

Hi,
I have create a report which contains a chart.
The series gets populated with the correct data but at the end of each
series, there is a text "Series 1" joined to the end of the actual text.
How is it possible to make sure the word "Series 1" does not appear at the
end of each series line?
ThanksProblem solved by restarting the machine.
"farshad" wrote:
> Hi,
> I have create a report which contains a chart.
> The series gets populated with the correct data but at the end of each
> series, there is a text "Series 1" joined to the end of the actual text.
> How is it possible to make sure the word "Series 1" does not appear at the
> end of each series line?
> Thanks
Posted by Rhonda at 1:57 AM 0 comments
Labels: , , , , , , , , , , , ,

Chart Question

Hi,
I am kind of grouping some data into series.
My question is :
1. How can i change different colors for the series ? (1 color for each)
2. How can i adjust the space between one series and the other.
(right now they are evenly spced out and are very small to see)
Thanks
RP> 1. How can i change different colors for the series ? (1 color for each)
Hi RP,
Make sure that you have installed RS SP1 on the client and server side. When
you install SP1 on the client side you will have one extra button for
setting individual color for each data. You can find the button in chart
properties, tab Data. Select data series and click Edit. Then click
Appearance/Series Style... In the Fill tab you can control the color for
this data.
HTH,
--
Martin Kulov
http://www.codeattest.com/blogs/martin
MCAD Charter Member
MCSD.NET Early Achiever
MCSD|||Thanks Martin,
I installed SP2 and I see this button. I am still not sure how I can change
the color on a pie chart.
I am trying to change the color on each individual pie in the pie chart.
For example I have two inputs for the pie
Channel and Count
Channel1 - 100
Channel2 - 250
Channel3 - 400
how can I change colors on each pie which is Channel1, channel2 and
channel3'
Thank you for your help.
Chandra.
"Martin Kulov" <kulov@.bezbokluk.abv.bg> wrote in message
news:O9dZrIzgFHA.1148@.TK2MSFTNGP12.phx.gbl...
> > 1. How can i change different colors for the series ? (1 color for each)
> Hi RP,
> Make sure that you have installed RS SP1 on the client and server side.
When
> you install SP1 on the client side you will have one extra button for
> setting individual color for each data. You can find the button in chart
> properties, tab Data. Select data series and click Edit. Then click
> Appearance/Series Style... In the Fill tab you can control the color for
> this data.
> HTH,
> --
> Martin Kulov
> http://www.codeattest.com/blogs/martin
> MCAD Charter Member
> MCSD.NET Early Achiever
> MCSD
>
Posted by Rhonda at 1:56 AM 0 comments
Labels: , , , , , , , , , ,

Chart legend wrapping

We have very long names for our series that appear in a chart legend so they
appear cut off with an ellipsis (three dots ...) at the end. We noticed
though that if we specify a \n in any one of the series names then they will
all wrap over two lines!
Ideally we would like the series names to all wrap over two lines in the
legend without having to specify \n in one of then - otherwise we would need
to carefully calculate where to add the \n
Is this possible to configure so that the metric names will automatically
wrap over two lines?You could write a function which uses GDI calls to calculate the actual
width of string glyphs based on font name, etc. However, the GDI calls are
usually not 100% accurate.
Another option to consider is to "draw" the legend by using a table report
item, rather using the built-in legend of the chart. Please check this
related newsgroup posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=ef87e605-48af-4c87-ac3f-ad43cd5fb1fc&sloc=en-us
Also check this blog posting which includes a link to a sample report.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:DDB98FDE-3FC8-4926-B318-BD89E7BF0B07@.microsoft.com...
> We have very long names for our series that appear in a chart legend so
> they
> appear cut off with an ellipsis (three dots ...) at the end. We noticed
> though that if we specify a \n in any one of the series names then they
> will
> all wrap over two lines!
> Ideally we would like the series names to all wrap over two lines in the
> legend without having to specify \n in one of then - otherwise we would
> need
> to carefully calculate where to add the \n
> Is this possible to configure so that the metric names will automatically
> wrap over two lines?
Posted by Rhonda at 1:54 AM 0 comments
Labels: , , , , , , , , , , , , , ,

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.
> >
>
>
Posted by Rhonda at 2:14 AM 0 comments
Labels: , , , , , , , , , , , , , ,

Chart Colors

Does anyone know of a way you can customise the colors used for different
series in a chart using Reporting Services. Or is there any way to create a
customised palette to use. There only appears to be a set group of colors to
choose from but I want to use specific colors for specific data series.Install RS 2000 SP1 if you have not yet done, and please read this section
in the SP1 readme about using colors in charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
You may also search this newsgroup for chart color related posting. You
should find several posted examples.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Hines" <Joel Hines@.discussions.microsoft.com> wrote in message
news:E17477B8-A076-4113-AEF1-9A3B126D6ABA@.microsoft.com...
> Does anyone know of a way you can customise the colors used for different
> series in a chart using Reporting Services. Or is there any way to create
a
> customised palette to use. There only appears to be a set group of colors
to
> choose from but I want to use specific colors for specific data series.
Posted by Rhonda at 2:13 AM 0 comments
Labels: , , , , , , , , , , , ,

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?
Posted by Rhonda at 2:13 AM 0 comments
Labels: , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)