如何使用自定义SQL查询创建水晶报表 [英] How to create crystal reports using custom SQL query

问题描述

我正在为自定义报告编写SQL查询，如何按日期过滤记录



我尝试过：



我的sql查询如下：

i am write a sql query for a custom report and how can i filter the record by date

What I have tried:

my sql query is given below

select b.bankname,b.name,b.par,b.deposit,b.withdraw,d.acno,d.hname,d.lamt,d.lint,d.lamt,d.lint,d.dc,dfr.acno,dfr.pint,dfr.repamt,dfr.repdate,dbna.acno,dbna.name,dbna.amount,dbna.details,dbp.acno,dbp.intpaid,dbp.paidamt,dbp.paidint,dtna.acno,dtna.name,dtna.amount,dtna.details,dtr.acno,dtr.intpaid,dtr.repamt,dtr.repdate,dtr.repint,e.name,e.particular,e.amt,i.name,i.par,i.type,i.amt,mfna.acno,mfna.dc,mfna.tamt,mfna.nint,mfna.lamt,mfna.lint,mfr.acno,mfr.pint,mfr.repamt,miss.amt,miss.name,miss.particular,mina.acno,mina.lamt,mina.lint,mina.msg,mir.acno,mir.intpaid,mir.repamt,mir.repint from bank b 
inner join dfnewtb d on b.date=d.date 
inner join dfrecip dfr on dfr.repdate=d.date 
inner join duebynewac dbna on dbna.date=dfr.repdate 
inner join duebypay dbp on dbp.paiddate=dbna.date 
inner join  duetonewac dtna on dtna.date=dbna.date 
inner join duetorec dtr on dtr.repdate=dtna.date
inner join expenses e on e.date=dtna.date
inner join invester i on i.date=e.date
inner join mfdnewac mfna on mfna.date=i.date
inner join mfrec mfr on mfr.repdate=mfna.date
inner join mincome miss on miss.date=mfr.repdate
inner join minewac mina on mina.date=miss.date
inner join mirec mir on mir.repdate=mina.date

推荐答案

放一个 WHERE [ ^ ]子句

这篇关于如何使用自定义SQL查询创建水晶报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！