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 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