FastReport SQL结果值与报表显示值不一致?

2011-12-17 12:21:26 279 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Windows + Fastreport创建报表教程 —高级篇（五）《FastReport代码应用进阶：数据与表格事件深度解析》摘要：本文系统讲解FastReport代码方式的进阶应用，重点围绕数据区和表格事件两大核心体系。数据区事件部分详解动态数据过滤、分组排序逻辑和条件格式实现，通过BeforePrint事件实现参数传递和动态内容生成。表格事件部分重点介绍ManualBuild事件实现动态行列控制，以及单元格级事件处理技巧，包括样式修改和复杂业务逻辑实现。文中提供多个实用代码示例，展示如何通过代码方式突破可视化设计的局限性，满足复杂报表需求，实现真正的动态报表功能。阅读详情

执行的SQL如下, 用于打印产品标签的,但是最后一张Fqty应该为100000的,但报表显示却是10000.
这种情况是偶然发生的.把程序关闭后重运行,打印又可以正常了.

另外这个Fqty是有条码的.条码的扫描结果显示也是错误的.
因此,报表模板中的文本控件宽度不足的可能基本排除.

 select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb1.bmp' as Fpic,1 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb2.bmp' as Fpic,2 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,3 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,4 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,5 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,6 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,7 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,8 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,9 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,10 as ID 

 union  select '批号001' as FLot,'1151' as FDate,'100000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb11.bmp' as Fpic,11 as ID 

 order by id

...全文