我在报表中显示查询字段planprice时,
显示:(invalid)(inv 不能显示字段内容,这是为什么呢??
select g.name,g.code,g.pprice,round(c.planprice,4) from goods g inner join c_plan c on g.goodsid=c.goodsid
我不用保留四位小数的函时如下语句可以正常输出语句如下:
select g.name,g.code,g.pprice,c.planprice from goods g inner join c_plan c on g.goodsid=c.goodsid
显示:(invalid)(inv 不能显示字段内容,这是为什么呢??
select g.name,g.code,g.pprice,round(c.planprice,4) from goods g inner join c_plan c on g.goodsid=c.goodsid
我不用保留四位小数的函时如下语句可以正常输出语句如下:
select g.name,g.code,g.pprice,c.planprice from goods g inner join c_plan c on g.goodsid=c.goodsid
select g.name,g.code,g.pprice,round(c.planprice,4) as planprice from goods g inner join c_plan c on g.goodsid=c.goodsid
哥们不行!
报表中该字段还是显示如下:invalid)(inv
但是我查询后在DBGRID 中显示是可以的,
同样也用了这个函数!
查询语句也是一样的,在报表上显示就出问题了
这是怎么回事呢?
select g.name as name,g.code as code,g.pprice as pprice,round(c.planprice,4) as planprice from goods g inner join c_plan c on g.goodsid=c.goodsid
就是说全部字段的AS都加上这样就行了!
我在报表中有给(datatext)指字段为:planprice
报表中可以不指定段吗??
在报表中给(c.planprice,4)指定字段名如何作呢??
round(c.planprice,4) as planprice就是给其指定字段名。