我要做个报表,不会了。。帮我看看,在线等
CON里SQL是
SELECT CARDSELLJFHEAD.CSJHTIME CSJHTIME_MIN,
CARDSELLJFHEAD.CSJHTIME CSJHTIME_MAX
FROM CARDSELLJFHEAD
然后两个文本框文本框是CSJHTIME_MIN,CSJHTIME_MAX
tag中分别写的是min(CARDSELLJFHEAD.CSJHTIME) 和max(CARDSELLJFHEAD.CSJHTIME)
list中SQL是
SELECT CARDSELLJFHEAD.CSJHCDMNO,
CARDMAIN.CDMNAME,
CARDSELLJFDETAIL.CSJDCJJE * fGetInvSign(CSJHVCHR) CSJDCJJE,
cdetel,cdemobile,csjhsyjid,csjhinvno
FROM CARDSELLJFDETAIL,CARDSELLJFHEAD,CARDMAIN,cardextent
WHERE CARDSELLJFHEAD.CSJHCDMNO=CARDSELLJFDETAIL.CSJDCDMNO AND
CARDSELLJFHEAD.CSJHBILLNO=CARDSELLJFDETAIL.CSJDBILLNO AND
CARDSELLJFHEAD.CSJHMKT=CARDSELLJFDETAIL.CSJDMKT AND
CARDSELLJFHEAD.CSJHCDMNO=CARDMAIN.CDMNO AND
CARDSELLJFHEAD.CSJHTIME >= to_date('csjhtime_min','yyyy-mm-dd HH24:MI:SS') AND
CARDSELLJFHEAD.CSJHTIME <= to_date('csjhtime_max','yyyy-mm-dd HH24:MI:SS') AND
cdmno=cdeno
order by CSJDCJJE desc
注意,csjhtime_min输入的是2007-09-20 15:00:00
csjhtime_min输入的是2007-09-20 15:59:59 我要取1个小时中的内容。。。
把报表挂到系统中,提示“报表条件中喊有非法的不能识别的操作符类型!”
帮帮我啊。公司要啊。。。郁闷了,在线等。。。