SSRS 2008 R2 - Line chart labels - visibility based on expression?

I would like to control the visibility of a data label in a line chart using an expression. For example, I have a requirement to show the data label for two compariable data points in a line chart where the horizontal axis is time (Q1, Q2, Q3,
etc...) and the data points are determined based on a selected parameter. The basic idea is that a user can select to view Q3 as the end point of reporting and the chart will graph a complete time line (e.g. FY 2001 thru FYXX
Q3) but only show the label for Q3 and prior year Q3.

I have tried to build an expression in the visibility property of 'Chart Series Labels' but this does not appear to work.

More Related Resource Links

Hi,
Any one pls tel me how to do the single line divider in Column chart in SSRS 2008
example:
---------
| |
| 20 |
----------
| 100 |
| |
-------------------------------
i want to show the above example.
Thanks in advance
Regards,
Abdul2010

Hello,
I want to check weather a chart is hidden or displayd by using the Expression of a Text Box that toggles display of that chart.
Therefore I need to call the chart in the Expression. Something like this:
=IIF(ReportItems!Chart2.Hidden = False ...
But obviously charts are not regarded as report items by ssrs!?!?
Thanks
Axel

I want to plot series in a line Graph on UTC time which has to be placed on Primary category axis. The secondary category axis should just display the correspoding PST time(No series need to be plotted on this). Is there a way to achive this?

I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other.
http://oi54.tinypic.com/2vifrb9.jpg

Is there a way to split the chart and show it on different pages.? Thanks in Advance :)

Hi,
Any one pls tell me how to show dual values in Column chart Y axis.
Example:
Im showing Total Number of clients in the Y axis of column chart
My Requirement is
In that Y axis column chart also i want to show differently of Inactive clients from total number of clients.
how to do this pls help me.
Thanks in advance.
TotalnumberOf clients : 1000
InActive Clients : 200 among TotalnumberofClients

SSRS 2008
When I toggle row (detail) visibility off, my subtotals are zero. My subtotals are correct when I toggle visibility on.
I am using custom aggredate functions to producte the subtotals.
It appears my custom functions are not called when visibilty is off
How can I work around this?
Thanks in advance for your help

Hi,
I want to display 2 different colrs on the same bar in range bar chart.
My chart is displaying project risks (MS project kind of chart). Each risk has its own start date, end date.
In case of dependent risks, the start date of dependent risk becomes the end date of the risk on which it depends.
Each risk has 2 parts. Lost opportunity & Remaining opportunity. I want to display Lost in red & remaining in Green.
Can I display 2 different colors on the same bar?
Regards,
Neeraj

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

Hi,I have created a chart of type 3D pie.ÃÂ I put a String field for Category and Sum(numeric field) for Data.I wanted to show the legend as Category field and Data field and it's displaying as i set.Now how to make alignment of Data in legend, so that my numeric fields should align Right and String field should align Left.ÃÂ I can make whole legend alignment but I want to make only the numeric field in the legend to align Right.Is it possible or there any work around?Please let me know.

0
Hi Sorna,
I want data in this format as below
|
| b________
b________
| a_____
a________
|_____________________________________________
0 1 2 3 6
7 24
time
X- axis -- Time
Y - Stand jsut for single name.showing dotted but consider as simple y axis.
Name A suppose to perform two work a,b and he perform a in 2Am to 3Am while b in 6 Am to 7 Am,now i want to create the bar chart as above please suggest how to do.
I have seen this url ::http://www.sqlservercentral.com/arti