文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >水晶报表2008-圣人x3

问水晶报表2008-圣人x3
EN

Stack Overflow用户
提问于 2016-09-19 17:26:38
回答 1查看 94关注 0票数 0

我已经在水晶报表中创建了5个参数，我必须为每个参数创建组合，这样连接才能正常工作。

例如:我有一，二，树，四，五。但不幸的是，代码不会接受插入的3个参数。是否有其他语法或方式可以让crystal接受它？

代码语言：javascript
复制
IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};





IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} = '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} = '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};





IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} = '' and {?param4deb} = '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} = '' and {?param3deb} = '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};




IF {?param1deb} <> '' and {?param2deb} <> '' and {?param3deb} = '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param2deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} <> '' and {?param3deb} <> '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} <> '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} = '' and {?param4deb} <> '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param4deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param3deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} <> '' and {?param3deb} = '' and {?param4deb} <> '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param2deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param4deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} = '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param3deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} <> '' and {?param2deb} = '' and {?param3deb} = '' and {?param4deb} = '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*' OR 
     {AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};





IF {?param1deb} <> '' and {?param2deb} = '' and {?param3deb} = '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param1deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} <> '' and {?param3deb} = '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param2deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} <> '' and {?param4deb} = '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param3deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} = '' and {?param4deb} <> '' and {?param5deb} = '' then
    ({AFCTEXE.FCT_0} LIKE {?param4deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};

IF {?param1deb} = '' and {?param2deb} = '' and {?param3deb} = '' and {?param4deb} = '' and {?param5deb} <> '' then
    ({AFCTEXE.FCT_0} LIKE {?param5deb}+'*') AND
     {AUTILIS.ZITUSR_0} <> 2 and
     {AUTILIS.ENAFLG_0} = 2 and
     {AUTILIS.USR_0} in {?userdeb} to {?userfin};
crystal-reports
EN

回答 1

Stack Overflow用户

发布于 2016-09-20 00:48:54

试试这样的东西

代码语言：javascript
复制
(
({?param1deb} <> '' AND {AFCTEXE.FCT_0} LIKE {?param1deb}+'*') OR
({?param2deb} <> '' AND {AFCTEXE.FCT_0} LIKE {?param2deb}+'*') OR
({?param3deb} <> '' AND {AFCTEXE.FCT_0} LIKE {?param3eb}+'*') OR
({?param4deb} <> '' AND {AFCTEXE.FCT_0} LIKE {?param4deb}+'*') OR
({?param5deb} <> '' AND {AFCTEXE.FCT_0} LIKE {?param5deb}+'*')
 ) AND
 {AUTILIS.ZITUSR_0} <> 2 and
 {AUTILIS.ENAFLG_0} = 2 and
 {AUTILIS.USR_0} in {?userdeb} to {?userfin};
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/39569669

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档