Hi, we have a data set which consists of time data. We have two columns, the first is the date/time of the record (EventDate), the second is a cut down text field displaying the month and year of the record (Month). Using the Month column as a category, we produce a chart with data grouped into months on the X axis.

What we would like is to have a title to display something like "Displaying data as at: ", where is the largest date in our data set. This way, when new records are added, the graphs will update to inform the user of the date most recent record that was used to create the chart (as well as labelling charts if users take copies, to show how old the chart is).

I tried doing this with the expresion: ="As at: "&MAX(Fields!EventDate)
Where EventDate is the data/time record, however I get an invalid cast from DateTime to Double.

If this can't be done as an expresion, I imagine it is possible with code injection, however the SharePoint Vision documentation has very little to say about code injection or the available classes/methods/properties. I tried looking in the .NET Vision documentation, which contains documentation on available classes, however I can't find the NRSChartCodeContext class, or what's available in that class.

From looking at examples, I've determined that I can get access to the NSeries object for each series in the chart, but this contains the double value used by the chart to display its points/lines/bars/etc. What I think I need is the NDataSeries for the data/time column, so I can find the largest value in the series and display that, but I'm not sure if I can get to it within the code injection context.

Any help would be appreciated.