|
|
You're in the
sql server reporting services
group:Changing the color of the series label
sql server reporting services:
would like to make one data point stand out based on a parameter that is passed in. I have already set up the color schemes for the series to do this inside the chart but would like the label to make that distinction as well. For example I would like to set the series label to red for one data point while all of the other labels would be black. Is this possible?
If you have at least RS 2000 SP1 installed, you can edit the data point
label properties (font, color, etc.) and use expressions to determine the color based on certain conditions. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Todd" <Todd@discussions.microsoft.com> wrote in message news:EAEF7051-1909-4CD8-93D8-F6842C2887B9@microsoft.com... >I am able to change the colors of the series inside the graph, however I > would like to make one data point stand out based on a parameter that is > passed in. I have already set up the color schemes for the series to do > this > inside the chart but would like the label to make that distinction as > well. > > For example I would like to set the series label to red for one data point > while all of the other labels would be black. Is this possible? > > Thanks
I am running with SP2 and have attempted to put in the code to make this
happen but it renders all of the labels with the color not just the one that I am looking for. I have tested the snippet of code elsewhere and it works fine. It seems as if the chart rendering looks at the first attribute passed for the series labels and stops looking at the attributes for the rest of the data points. [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> If you have at least RS 2000 SP1 installed, you can edit the data point > label properties (font, color, etc.) and use expressions to determine the > color based on certain conditions. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Todd" <Todd@discussions.microsoft.com> wrote in message > news:EAEF7051-1909-4CD8-93D8-F6842C2887B9@microsoft.com... > >I am able to change the colors of the series inside the graph, however I > > would like to make one data point stand out based on a parameter that is > > passed in. I have already set up the color schemes for the series to do > > this > > inside the chart but would like the label to make that distinction as > > well. > > > > For example I would like to set the series label to red for one data point > > while all of the other labels would be black. Is this possible? > > > > Thanks > >
Does the chart have a series grouping?
If yes, then assuming you have a series grouping called "ProductCategory", you have to use a style color expression with an aggregate function: = iif(First(Fields!Abc.Value, "ProductCategory") > 10, "Red", Nothing) 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). -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Todd" <Todd@discussions.microsoft.com> wrote in message news:3048F968-1AA1-474D-9EEA-4C985F5DC1DA@microsoft.com... >I am running with SP2 and have attempted to put in the code to make this > happen but it renders all of the labels with the color not just the one > that > I am looking for. I have tested the snippet of code elsewhere and it > works > fine. It seems as if the chart rendering looks at the first attribute > passed > for the series labels and stops looking at the attributes for the rest of > the > data points. > > "Robert Bruckner [MSFT]" wrote: > >> If you have at least RS 2000 SP1 installed, you can edit the data point >> label properties (font, color, etc.) and use expressions to determine the >> color based on certain conditions. >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Todd" <Todd@discussions.microsoft.com> wrote in message >> news:EAEF7051-1909-4CD8-93D8-F6842C2887B9@microsoft.com... >> >I am able to change the colors of the series inside the graph, however I >> > would like to make one data point stand out based on a parameter that >> > is >> > passed in. I have already set up the color schemes for the series to >> > do >> > this >> > inside the chart but would like the label to make that distinction as >> > well. >> > >> > For example I would like to set the series label to red for one data >> > point >> > while all of the other labels would be black. Is this possible? >> > >> > Thanks >> >> >>
No, The chart does not have series grouping. I also wonder if I have
communicated this effectively. I am talking about the labels on the x-axis. I am only concerned with the series labels not data point labels. Does this help to clarify? [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Does the chart have a series grouping? > > If yes, then assuming you have a series grouping called "ProductCategory", > you have to use a style color expression with an aggregate function: > = iif(First(Fields!Abc.Value, "ProductCategory") > 10, "Red", Nothing) > > 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). > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Todd" <Todd@discussions.microsoft.com> wrote in message > news:3048F968-1AA1-474D-9EEA-4C985F5DC1DA@microsoft.com... > >I am running with SP2 and have attempted to put in the code to make this > > happen but it renders all of the labels with the color not just the one > > that > > I am looking for. I have tested the snippet of code elsewhere and it > > works > > fine. It seems as if the chart rendering looks at the first attribute > > passed > > for the series labels and stops looking at the attributes for the rest of > > the > > data points. > > > > "Robert Bruckner [MSFT]" wrote: > > > >> If you have at least RS 2000 SP1 installed, you can edit the data point > >> label properties (font, color, etc.) and use expressions to determine the > >> color based on certain conditions. > >> > >> -- Robert > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> "Todd" <Todd@discussions.microsoft.com> wrote in message > >> news:EAEF7051-1909-4CD8-93D8-F6842C2887B9@microsoft.com... > >> >I am able to change the colors of the series inside the graph, however I > >> > would like to make one data point stand out based on a parameter that > >> > is > >> > passed in. I have already set up the color schemes for the series to > >> > do > >> > this > >> > inside the chart but would like the label to make that distinction as > >> > well. > >> > > >> > For example I would like to set the series label to red for one data > >> > point > >> > while all of the other labels would be black. Is this possible? > >> > > >> > Thanks > >> > >> > >> > >
Sorry, the individual x-axis labels share the same color and font settings.
-- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Todd" <Todd@discussions.microsoft.com> wrote in message news:7391723B-1CAB-4990-A5A7-E41A41DAF65E@microsoft.com... > No, The chart does not have series grouping. I also wonder if I have > communicated this effectively. I am talking about the labels on the > x-axis. > I am only concerned with the series labels not data point labels. Does > this > help to clarify? > > "Robert Bruckner [MSFT]" wrote: > >> Does the chart have a series grouping? >> >> If yes, then assuming you have a series grouping called >> "ProductCategory", >> you have to use a style color expression with an aggregate function: >> = iif(First(Fields!Abc.Value, "ProductCategory") > 10, "Red", Nothing) >> >> 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). >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Todd" <Todd@discussions.microsoft.com> wrote in message >> news:3048F968-1AA1-474D-9EEA-4C985F5DC1DA@microsoft.com... >> >I am running with SP2 and have attempted to put in the code to make this >> > happen but it renders all of the labels with the color not just the one >> > that >> > I am looking for. I have tested the snippet of code elsewhere and it >> > works >> > fine. It seems as if the chart rendering looks at the first attribute >> > passed >> > for the series labels and stops looking at the attributes for the rest >> > of >> > the >> > data points. >> > >> > "Robert Bruckner [MSFT]" wrote: >> > >> >> If you have at least RS 2000 SP1 installed, you can edit the data >> >> point >> >> label properties (font, color, etc.) and use expressions to determine >> >> the >> >> color based on certain conditions. >> >> >> >> -- Robert >> >> This posting is provided "AS IS" with no warranties, and confers no >> >> rights. >> >> >> >> >> >> "Todd" <Todd@discussions.microsoft.com> wrote in message >> >> news:EAEF7051-1909-4CD8-93D8-F6842C2887B9@microsoft.com... >> >> >I am able to change the colors of the series inside the graph, >> >> >however I >> >> > would like to make one data point stand out based on a parameter >> >> > that >> >> > is >> >> > passed in. I have already set up the color schemes for the series >> >> > to >> >> > do >> >> > this >> >> > inside the chart but would like the label to make that distinction >> >> > as >> >> > well. >> >> > >> >> > For example I would like to set the series label to red for one data >> >> > point >> >> > while all of the other labels would be black. Is this possible? >> >> > >> >> > Thanks >> >> >> >> >> >> >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |