Change in legend of chart based on values?

I am developing a chart with type as column and subtype as stacked. The values (different columns from my dataset) are shown as series in the chart. If I have an entire column with no values, nothing in shown in the graph but the column name comes in the legend. I do not want to show the particular column in legend if all the values in that column are 0 or null. Is it possible through an expression or any other way?

Please let me know.

Thanks in advance !!!

If you use a dynamic series grouping in the chart and you want to get rid of a particular series grouping instance, you could use a filter expression on the series grouping, e.g.
Filter expression: =Sum(Fields!Name.Value, "DynamicSeriesGroupingName")
Filter operator: >
Filter value: =0

Again, the filter approach will only work in the case of dynamic series groupings.

-- Robert

Change font size w/ expression?

Hi I have a chart whose title I would like to format w different font sizes.
The chart title is:
<caption>="This is the chart main text" + vbcrlf +
First(Fields!subtitle.Value, "Text")</caption>
The main chart title is hard coded and the second line is a field.
I would like to change the font size on that second line. Is there a way to
reference the <caption> line in <style><fontsize> and parse through it?
I'm thinking this isn't possible, but why not ask.
Thanks!
MarcusOn Nov 27, 3:56 pm, Marcus K <Marc...@.discussions.microsoft.com>
wrote:
> Hi I have a chart whose title I would like to format w different font sizes.
> The chart title is:
> <caption>="This is the chart main text" + vbcrlf +
> First(Fields!subtitle.Value, "Text")</caption>
> The main chart title is hard coded and the second line is a field.
> I would like to change the font size on that second line. Is there a way to
> reference the <caption> line in <style><fontsize> and parse through it?
> I'm thinking this isn't possible, but why not ask.
> Thanks!
> Marcus
You will most likely want to create a custom ASP.NET application that
reads in the RDL file (possibly as an XML Document) and parses the XML
tags and writes the file back out -and/or- read the RDL file in via
Streamreader and assigns it to a string and then does a string replace
of the fontsize in the tags and then writes the file back out via
Streamwriter. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique, but thats outside the scope of my knowledge.
Any chance there is a way to do it within the rdl?
"EMartinez" wrote:
> On Nov 27, 3:56 pm, Marcus K <Marc...@.discussions.microsoft.com>
> wrote:
> > Hi I have a chart whose title I would like to format w different font sizes.
> > The chart title is:
> >
> > <caption>="This is the chart main text" + vbcrlf +
> > First(Fields!subtitle.Value, "Text")</caption>
> >
> > The main chart title is hard coded and the second line is a field.
> >
> > I would like to change the font size on that second line. Is there a way to
> > reference the <caption> line in <style><fontsize> and parse through it?
> >
> > I'm thinking this isn't possible, but why not ask.
> >
> > Thanks!
> > Marcus
>
> You will most likely want to create a custom ASP.NET application that
> reads in the RDL file (possibly as an XML Document) and parses the XML
> tags and writes the file back out -and/or- read the RDL file in via
> Streamreader and assigns it to a string and then does a string replace
> of the fontsize in the tags and then writes the file back out via
> Streamwriter. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Change colour of "Interlaced strips" in chart?

Is it possible to change the colour of the interlaced strips? I can change
the default background colour, but haven't found a setting for the alternate
colour. I need to have two light colours, as the default gray is a bit dark
for some printers.
All help appreciated!
Kaisa M. LindahlThe color for interlaced strips is determined automatically by the chart
control based on the background / plotarea color. Did you try adjusting the
plotarea color of the chart?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:%23$kOwzTBFHA.1260@.TK2MSFTNGP12.phx.gbl...
> Is it possible to change the colour of the interlaced strips? I can change
> the default background colour, but haven't found a setting for the
alternate
> colour. I need to have two light colours, as the default gray is a bit
dark
> for some printers.
> All help appreciated!
> Kaisa M. Lindahl
>|||I noticed that the colour changes a bit when I change the colour in plot
area. Unfortunately, it doesn't change enough.
In the end, we just skipped the interlacing all together.
Kaisa M. Lindahl
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OiM2S8kBFHA.3120@.TK2MSFTNGP12.phx.gbl...
> The color for interlaced strips is determined automatically by the chart
> control based on the background / plotarea color. Did you try adjusting
the
> plotarea color of the chart?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:%23$kOwzTBFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > Is it possible to change the colour of the interlaced strips? I can
change
> > the default background colour, but haven't found a setting for the
> alternate
> > colour. I need to have two light colours, as the default gray is a bit
> dark
> > for some printers.
> >
> > All help appreciated!
> >
> > Kaisa M. Lindahl
> >
> >
>

Change color in a chart

Does anyone know how to change a chart color in reporting services?
I need a different color from colors available in the palette.
Thanks in advance,
ELEN.type into the related property box the color rather than use the pallet
eg Beside BackgroudColor there might be a [] Transparent
just type in #12ff21
ELEN wrote:
> Does anyone know how to change a chart color in reporting services?
> I need a different color from colors available in the palette.
> Thanks in advance,
> ELEN.|||You also need to make sure you have SP2 installed

Change chart type dynamically from Column to Line graph?

I am developing several charts with column type and sub type as stacked. There is a requirement from the users that they want an option to choose the type of chart.

Is it possible to change chart type dynamically from say Column type to Line type based on user option in front-end?

Any help will be appreciated.

Thanks in advance !!

The closest you can get directly in RS at this point is to define multiple charts with different types and conditionally only show one of the charts based on a parameter selection.

-- Robert

|||

I have the same problem.

I created 5 charts on one report. but i dont want to execute the report for each change.

all the charts are using the same dataset.

Can i show /Hide all the charts except the choosen one by clicking on a textbox?

thanks

|||

Yes you could do that by adding a drillthrough navigation action on the textbox. Add a drillthrough parameter which determines which chart should be shown in the drillthrough target report. Note that you could also setup the navigation action to drill to the current report with a certain parameter value.

More information about drillthrough reports is available here: http://msdn2.microsoft.com/en-us/library/aa337167.aspx

-- Robert

|||

thanks Robert.

but, by using the drillthrough option, i actually execute again the same report, and again i execute the sql store-procedure.

i want to avoid it: one time execution and after it all the graphs changes will be on the client side.

does it doable?

thanks.

Yuval

Change chart type dynamically from Column to Line graph?

I am developing several charts with column type and sub type as stacked. There is a requirement from the users that they want an option to choose the type of chart.

Is it possible to change chart type dynamically from say Column type to Line type based on user option in front-end?

Any help will be appreciated.

Thanks in advance !!

The closest you can get directly in RS at this point is to define multiple charts with different types and conditionally only show one of the charts based on a parameter selection.

-- Robert

|||

I have the same problem.

I created 5 charts on one report. but i dont want to execute the report for each change.

all the charts are using the same dataset.

Can i show /Hide all the charts except the choosen one by clicking on a textbox?

thanks

|||

Yes you could do that by adding a drillthrough navigation action on the textbox. Add a drillthrough parameter which determines which chart should be shown in the drillthrough target report. Note that you could also setup the navigation action to drill to the current report with a certain parameter value.

More information about drillthrough reports is available here: http://msdn2.microsoft.com/en-us/library/aa337167.aspx

-- Robert

|||

thanks Robert.

but, by using the drillthrough option, i actually execute again the same report, and again i execute the sql store-procedure.

i want to avoid it: one time execution and after it all the graphs changes will be on the client side.

does it doable?

thanks.

Yuval

change chart color

Hello,

Is it possible to specify color in more detail in the switch statement?

not "yellow" or "red" but I want to determine the colors by "RGB-values"...

hope everyone understands my problem

regards,

Rhapsy

Not sure I understand your question, but you can specify colors as RGB values like HTML colors. Instead of specifying a color by name, you specify it as RGB values, e.g.:

#00FF00

-- Robert

|||

Hi Rhapsy,

This is what I use for charts

Put this in the code window (Reports/Properties/Code). you can use RGB values or colour names

Public Function Qtr_Colour(Quarter as String) As string

Dim Bar_Colour as String

Select Case Quarter

Case "Qtr 1"

Bar_Colour = "#CCCCCC"

Case "Qtr 2"

Bar_Colour = "#333333"

Case "Qtr 3"

Bar_Colour = "#FFCC00"

Case "Qtr 4"

Bar_Colour = "Silver"

Case "Qtr +"

Bar_Colour = "LightYellow"

Case Else

Bar_Colour = "#FFFFFF"

End Select

Return Bar_Colour

End Function

Then reference it in the formatting area of your chart data item (chart properties/data:values/edit/appearance/series style/ fill) like this...

=code.Qtr_Colour(Fields!Quarter.Value)

Hope that's of interest to you.

99

|||hello,

thank you for your answers. they are both helpful and that exactly what i'm loking for ...

thanks,

rhapsy

Chaging the Min and Max Scale of a Chart at run time

I have a stored procedure which will bring me back the Min, Max and Mean of different result sets. What I want to do with the Y-Axis is set the Min scale value of the chart to be Min -%5 and the Max scale value to be Max + 5%.

Is there a way to change the Y-Axis values at report run time without spitting my own RDL?

In RS 2005, the Min/Max/CrossAt/MajorInterval/MinorInterval settings can be expression based. Note that by using an aggregate function such as first you can even reference certain values from another dataset than the chart is bound to. For example, you could use an expression similar to:

=CDbl(First(Fields!MinValue.Value, "StoredProcDataset")) - 0.05

-- Robert

|||That's great Robert but it's not apparent seeing that it doesn't follow the usual standard of having the combo box with the <expression> as a selection. Worked for me though and I thank you.|||

Hi!

I want to change my y-axis into always showing integers, start with zero and show an y-axis longer than the maximum value of the points.
How do I do that in csharp?

My code is like this now: (Chart looks ok for values between 0 and 25, but makes a chart with a max value 1 have an Y axis that is divided into 0.1 and up to 1.0 ):

chartGraf.Axis.Y.TickmarkStyle = AxisTickStyle.Smart;

chartGraf.Axis.Y.LineThickness = 1;

chartGraf.Axis.Y.RangeMin = 0;

if ( MyMaximumValue < 3) {

chartGraf.Axis.Y.RangeMax = 3;

}

-Heidi

Chaging the Min and Max Scale of a Chart at run time

I have a stored procedure which will bring me back the Min, Max and Mean of different result sets. What I want to do with the Y-Axis is set the Min scale value of the chart to be Min -%5 and the Max scale value to be Max + 5%.

Is there a way to change the Y-Axis values at report run time without spitting my own RDL?

In RS 2005, the Min/Max/CrossAt/MajorInterval/MinorInterval settings can be expression based. Note that by using an aggregate function such as first you can even reference certain values from another dataset than the chart is bound to. For example, you could use an expression similar to:

=CDbl(First(Fields!MinValue.Value, "StoredProcDataset")) - 0.05

-- Robert

|||That's great Robert but it's not apparent seeing that it doesn't follow the usual standard of having the combo box with the <expression> as a selection. Worked for me though and I thank you.|||

Hi!

I want to change my y-axis into always showing integers, start with zero and show an y-axis longer than the maximum value of the points.
How do I do that in csharp?

My code is like this now: (Chart looks ok for values between 0 and 25, but makes a chart with a max value 1 have an Y axis that is divided into 0.1 and up to 1.0 ):

chartGraf.Axis.Y.TickmarkStyle = AxisTickStyle.Smart;

chartGraf.Axis.Y.LineThickness = 1;

chartGraf.Axis.Y.RangeMin = 0;

if ( MyMaximumValue < 3) {

chartGraf.Axis.Y.RangeMax = 3;

}

-Heidi

Category color for specific category

Hi,
I have a bar chart with a catagory on the x axis
I would like to make the color change on the label for a specific label on
the bar
thanksHere are a couple of blogs that cover this:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
http://www.cubido.at/Default.aspx?tabid=176&EntryID=29
Larry
"Tango" wrote:
> Hi,
> I have a bar chart with a catagory on the x axis
> I would like to make the color change on the label for a specific label on
> the bar
> thanks

Categorise Bar Chart

How to create a bar chart by setting the static category myself?

I mean, for example, I have a dataset which record the number of coins different people have.

I would like to draw a bar chart which shows 3 bars with the following 3 different categories:

1) n < 5,

2) n >= 5 and n <10,

3) n>=10.

where n is the number of coins.

How can this be expressed in the categories grouping?

Thanks in advance.

Sorry, this is currently not directly supported through chart groupings. You would need to write the query (or add a calculated field on the dataset) so that you get this categorization in the data and then use those fields in the chart.

-- Robert