How to use Fields or ReportItems value in charts

Hi, all. I am doing a financial report needs to show last 10 yrs history data. The end year is the last year of the current year. How can I set the minumum and maximun with Year(Now) fucntion for the x-axis, to represent the years? Is there any way to use Fields value for the chart minumum and maximun?

Yes this is possible in RS 2005 (but not in RS 2000). Axis settings such as min/max/crossat/major interval/minor interval can be expression-based. Just type in the expression as e.g. =Year(Now)

-- Robert

|||Thanks Robert. Actually I want to put the Year(Now)(2006) as maximun and Year(Now) -10(1996) as Minimun. However, the data I have are bewteen 1998 and 2002, so the chart still shows data from 1998 to 2002. Can I set exactly 10 years on the chart? Even thought there're no data at 2006 and 1996?|||

This should work fine if the x-axis is set to use "numeric / time-scale values" and the category grouping expression evaluates to either integer values or DateTime objects.

-- Robert