Hi
I have a similar issue which still is happening after the latest update - build 2821.
I have a MSColumnLineDY chart which looks 12 months into the future. I also link a popup report from this chart.
I find that the first couple of months the tooltips and the report linking works correctly but it gradually gets offset to the left and eventually disappears after about 6 months in the future.
Any thoughts?
Jake
select 'dbr.chart', 'MSColumnLineDY','Expected Hand Overs by Month';
select 'dbr.chart.options','imagechart';
select 'dbr.chart.options', 'padding_top',20;
select 'dbr.chart.options', 'title_font','Courier';
select 'dbr.chart.options', 'title_color','Blue';
select 'dbr.chart.options', 'title_font_size',15;
select 'dbr.chart.options','showvalues',0;
select 'dbr.chart.options','legend.position','bottom';
select 'dbr.chart.options','chart.scale',35;
select 'dbr.hidecolumns', 'MonthStart';
select 'dbr.chart.options', 'title_color','#8F0008';
select 'dbr.report', 'sp_DBR_Linked_EXPHOD','popup', 'inMon=MonthStart';
SELECT
date_format(t.Plot_ExpHOD,'%b') as 'Mon',
'Sales Value',
sum(t.Plot_ExpSP) as 'Exp Sales Value',
cast( date_format( t.Plot_ExpHOD, '%Y-%m-01') as date ) as 'MonthStart'
FROM
hilmark.tblsitesplotsjake t
WHERE
t.Plot_ExpHOD >= cast(date_format(now(),'%Y-%m-%01') as date)
group by date_format(t.Plot_ExpHOD,'%b')
union
SELECT
date_format(t.Plot_ExpHOD,'%b') as 'Mon',
'Handovers',
count(t.tblContractXidJobNo) AS 'Exp HandOvers',
cast( date_format( t.Plot_ExpHOD, '%Y-%m-01') as date ) as 'MonthStart'
FROM
hilmark.tblsitesplotsjake t
WHERE
t.Plot_ExpHOD >= cast(date_format(now(),'%Y-%m-%01') as date)
group by date_format(t.Plot_ExpHOD,'%b')
ORDER BY 4;
