38 评论

SELECT 地区 ${if(len(销售员)=0,"",",销售员")} ${if(len(产品类型)=0,"",",产品类型")} ${if(len(产品)=0,"",",产品")} ,sum(销量) as 销量汇总
FROM 销量
where 1=1
${if(len(销售员)==0,"","and 销售员 in ('" +销售员+ "')")}
${if(len(产品类型)==0,"","and 产品类型 in ('" +产品类型+ "')")}
${if(len(产品)==0,"","and 产品 in ('" +产品+ "')")}
group by 地区
${if(len(销售员)=0,"",",销售员")}
${if(len(产品类型)=0,"",",产品类型")}
${if(len(产品)=0,"",",产品")}
这后面的
SELECT 地区 ${if(len(销售员)=0,"",",销售员")} ${if(len(产品类型)=0,"",",产品类型")} ${if(len(产品)=0,"",",产品")} ,sum(销量) as 销量汇总
FROM 销量
where 1=1
${if(len(销售员)==0,"","and 销售员 in ('" +销售员+ "')")}
${if(len(产品类型)==0,"","and 产品类型 in ('" +产品类型+ "')")}
${if(len(产品)==0,"","and 产品 in ('" +产品+ "')")}
group by 地区
${if(len(销售员)=0,"",",销售员")}
${if(len(产品类型)=0,"",",产品类型")}
${if(len(产品)=0,"",",产品")}
是啥意思呢?

赞 0 2024-01-12 18:02

SELECT 地区 ${if(len(销售员)=0,"",",销售员")} ${if(len(产品类型)=0,"",",产品类型")} ${if(len(产品)=0,"",",产品")} ,sum(销量) as 销量汇总
FROM 销量
where 1=1
${if(len(销售员)==0,"","and 销售员 in ('" +销售员+ "')")}
${if(len(产品类型)==0,"","and 产品类型 in ('" +产品类型+ "')")}
${if(len(产品)==0,"","and 产品 in ('" +产品+ "')")}
group by 地区
${if(len(销售员)=0,"",",销售员")}
${if(len(产品类型)=0,"",",产品类型")}
${if(len(产品)=0,"",",产品")}
这后面的
SELECT 地区 ${if(len(销售员)=0,"",",销售员")} ${if(len(产品类型)=0,"",",产品类型")} ${if(len(产品)=0,"",",产品")} ,sum(销量) as 销量汇总
FROM 销量
where 1=1
${if(len(销售员)==0,"","and 销售员 in ('" +销售员+ "')")}
${if(len(产品类型)==0,"","and 产品类型 in ('" +产品类型+ "')")}
${if(len(产品)==0,"","and 产品 in ('" +产品+ "')")}
group by 地区
${if(len(销售员)=0,"",",销售员")}
${if(len(产品类型)=0,"",",产品类型")}
${if(len(产品)=0,"",",产品")}
是啥意思呢?

赞 0 2024-01-12 18:02

根据参数控制sql语句的内容不同。select后面控制的是sql最终要查询的列，group by后面是控制的要分组的列，where后面是控制的参数筛选条件

赞 0 2024-01-17 11:58

数据集导入excel，怎么实现下拉框和折线图联动了？

赞 0 2023-07-24 21:37

数据集导入excel，怎么实现下拉框和折线图联动了？

赞 0 2023-07-24 21:37

那如果是不同数据集不同表 怎么实现联动呢

赞 0 2022-11-11 10:53

是通过设置参数名保持一致来联动的，可以参考：模板参数-https://help.fanruan.com/finereport/doc-view-157.html或者数据集参数-https://help.fanruan.com/finereport/doc-view-158.html

赞 0 2023-02-22 16:58