请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
百煮味香(uid:836889)
职业资格认证:FCA-FineReport | FCA-FineBI | FCA-简道云 | FCP-报表交付工程师
  • 选择发货组织后,下面只显示产品名称,如果选择规格型号,那就都出来,怎么实现
  • 我在省份前面设置了加减号,可以展开折叠但是我只是点了其中一个省份前面的加减号,所有的都展开了:我是做了以下设置:条件属性:动态参数:模板参数:
  • 请问admin账号不是默认能够看到所有数据的吗?配置完权限后,管理员账号的权限也没了?
  • SELECT ${if(type='date'," CONVERT(varchar(100),b.,20) as 日期,","")}${if(type='month', " CONVERT(varchar(7),b.,20) as 日期,  ","")}${if(type='year', " CONVERT(varchar(4),b.,20) as 日期, ","")} a., a., sum(b.) 实际营收,sum(c.) 计划营收FROM ( SELECT t1.BrandName 品牌, t1.HotelName 门店, t1.ShopID 门店id, t1.HotelID 饭店id FROM . t1 WHERE t1.HotelName NOT IN ('', '测试门店') ) aLEFT JOIN ( SELECT t2.ShopID 门店ID, t2.BillDate 日期, SUM (t2.Amount) 实际营收 FROM . t2 WHERE t2.OrderStatus = '40' GROUP BY t2.ShopID, t2.BillDate) b ON a. = b.LEFT JOIN(SELECT t3.ShopID 门店id, t3.TargetDate 日期, SUM (t3.) 计划营收FROM . t3WHERE t3.Items = '营收(万元)'GROUP BY t3.ShopID, t3.TargetDate)con c.门店id=a.饭店idand b.=c.where 1=1${if(type='date'," and CONVERT(varchar(100),b.,20) >= '" + 开始日期 + "' and CONVERT(varchar(100),b.,20)<='" + 结束日期 + "'", "")}${if(type='month', " and cast(month(CONVERT(varchar(100),b.,20)) as int) = "+ 月 + " and year(CONVERT(varchar(100),b.,20)) = '" + 年+"'", "")}${if(type='year', " and year(CONVERT(varchar(100),b.,20)) = '" + 年+"'", "")}${if(len(品牌)==0,"","and a. in ('"+品牌+"')")}${if(len(门店)==0,"","and a. in ('"+门店+"')")}group by ${if(type='date'," CONVERT(varchar(100),b.[日期,20), ","")}${if(type='month', " CONVERT(varchar(7),b.[日期,20),  ","")}${if(type='year', " CONVERT(varchar(4),b.[日期,20), ","")}
  • SELECT a., a., b., b.,c.FROM ( SELECT t1.BrandName 品牌, t1.HotelName 门店, t1.ShopID 门店id, t1.HotelID 饭店id FROM . t1 WHERE t1.HotelName NOT IN ('', '测试门店') ) aLEFT JOIN ( SELECT t2.ShopID 门店ID, t2.BillDate 日期, SUM (t2.Amount) 实际营收 FROM . t2 WHERE t2.OrderStatus = '40' GROUP BY t2.ShopID, t2.BillDate) b ON a. = b.LEFT JOIN(SELECT t3.ShopID 门店id, t3.TargetDate 日期, SUM (t3.) 计划营收FROM . t3WHERE t3.Items = '营收(万元)'GROUP BY t3.ShopID, t3.TargetDate)con c.门店id=a.饭店idand b.=c.where ${if(type='date'," and CONVERT(varchar(100),b.,20) >= '" + 开始日期 + "' and CONVERT(varchar(100),b.,20)<='" + 结束日期 + "'", "")}
  • 主表:子表设置好了默认:但是跳转时没有自动查询,手动点击查询按钮才出来数据

503

90

503

10

个人成就
内容被浏览200,826
加入社区3年109天
返回顶部