我现在有一个adoquery控件在主窗口中,我现在想要把这个adoquery查询出的结果显示在一个报表中如何来做.
其中sql语句如下:
select a.c_article_no as 货号,b.c_dealer as 供应商,a.c_date as 日期,round(sum(c_total),2) as "总价 ""元""" from t_pos_detail a,t_dealer_detail b where Fdate >=:Fdate and LDate <=:LDate and RTRIM(LTRIM(a.c_article_no))=RTRIM(LTRIM(b.c_article_no)) group by a.c_article_no,b.c_dealer,c_date
其中sql语句如下:
select a.c_article_no as 货号,b.c_dealer as 供应商,a.c_date as 日期,round(sum(c_total),2) as "总价 ""元""" from t_pos_detail a,t_dealer_detail b where Fdate >=:Fdate and LDate <=:LDate and RTRIM(LTRIM(a.c_article_no))=RTRIM(LTRIM(b.c_article_no)) group by a.c_article_no,b.c_dealer,c_date
用户名：csdn
密码:csdn
端口：21