fastreport一些技巧

蔚落 2023-02-21 06:36 8阅读 0赞

### 1.字段的if语句： ###

材积：[IIF(<Detail542."Cub"> > 0.01 , 'Y','N')]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70][]

![20200629135911445.png][]

### 2. 小数的格式化 ###

小数会显示很多位：

![2020062914012621.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 1][]

### 3.字符串的截取 ###

截取字段前6个字符： \[Copy('Hellowrld', 0, 6)\]

截取字段第1个字符： \[Copy(<Master557."ConfirmMan">, 0, 1)\]

### 3.小数的格式化高级 ###

如果格式化用%2.2f这样的，那么小数点后没有0的也会显示2个0：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 2][]

如果用%g这样的， 1.2后面会多很多0

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 3][]

正确的方法是 \#.\#\#，有小数就显示小数，没有就不显示，没有多余的：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 4][]

更好的方式是0.\#\#，如果是\#.\#\#那么0.3就会显示为.3

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 5][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200629135405459.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ==,size_16,color_FFFFFF,t_70
[20200629135911445.png]: https://img-blog.csdnimg.cn/20200629135911445.png
[2020062914012621.png]: https://img-blog.csdnimg.cn/2020062914012621.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200629140610263.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200807200435415.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200807200508660.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200807200552130.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200811183654380.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1enV5dTM2NQ==,size_16,color_FFFFFF,t_70