我用Rave5制作报表,用RAVE模拟显示正常,可程序调用为何数据就显示为“invalid” My_Select := 'SELECT jinfeidaihao as JFDH, sbgm_time as GMRQ, sb_name as SMMC, xinhao as SBXH, guige as SBGG,count(*) as SHULIANG ,' +
' sum(danjia) as HJ FROM 设备表 ' +
' where zhuxiao_time is null and sbgm_time between '''+ sDateEdit1.EditText + ''' and '''+ sDateEdit2.EditText +''''+
' group by sb_name, xinhao, guige, jinfeidaihao, sbgm_time' +
' Order By SBGM_time DESC'; ADOQuery1.Active := false;
ADOQuery1.SQL.Clear ;
ADOQuery1.SQL.Add(My_Select);
ADOQuery1.Active := True;
RvProject1.ProjectFile := ExtractFileDir(Application.Exename)+'\报表\经费统计.rav';
RvProject1.ExecuteReport('Report2') ; // 打开指定的报表
RvProject1.Close ;
恳请朋友们帮我分析一下,谢谢。
[email protected]
' sum(danjia) as HJ FROM 设备表 ' +
' where zhuxiao_time is null and sbgm_time between '''+ sDateEdit1.EditText + ''' and '''+ sDateEdit2.EditText +''''+
' group by sb_name, xinhao, guige, jinfeidaihao, sbgm_time' +
' Order By SBGM_time DESC'; ADOQuery1.Active := false;
ADOQuery1.SQL.Clear ;
ADOQuery1.SQL.Add(My_Select);
ADOQuery1.Active := True;
RvProject1.ProjectFile := ExtractFileDir(Application.Exename)+'\报表\经费统计.rav';
RvProject1.ExecuteReport('Report2') ; // 打开指定的报表
RvProject1.Close ;
恳请朋友们帮我分析一下,谢谢。
[email protected]
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货