水晶报告数据重复

2020-09-12 07:23发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我有详尽的报告,但行不断重复我该怎么做..这是我的qwery

选择" mydb__Posted_Settlement"。"结算编号"," mydb__Posted_Settlement"。"供应商编号"," mydb__Posted_Settlement"。"到期日期"," mydb__Posted_Settlement"。"结算日期"," mydb__Posted_Settlement"。"名称 "。"城市"," mydb__Posted_Settlement_Line"。"项目编号"," mydb__Posted_Settlement_Line"。"描述"," mydb__Posted_Settlement_Line"。"肉类百分比"," mydb__Posted_Settlement_Line"。"结算重量"," mydb__Posted_Set"。 " mydb__Posted_Settlement_Line"。"金额"," mydb__Posted_Settlement_Line"。"数量"," mydb__Posted_Settlement_Line"。"结算率"," mydb__Posted_Settlement_Line"。"供应商标签"," mydb__Posted_Settlement_Add__Ded"," _"。 " mydb__Posted_Settlement_Add__Ded_"。"金额"来自(" FCL-DBS-01"。" dbo"。" mydb_ $ Posted结算"" mydb__Posted_Settlement"左外部联接" FCL-DBS-01"。" dbo"。" mydb_ $ Posted结算 行"" mydb__Posted_Settlement_Line"开" mydb__Posted_Se ttlement"。"结算编号"" =" mydb__Posted_Settlement_Line"。"结算编号")左外连接" FCL-DBS-01"。" dbo"。" mydb_ $ Posted Settlement Add__Ded_"" mydb__Posted_Settlement_Add__Ded_" ON" mydb__Posted_Settlement"。 " =" mydb__Posted_Settlement_Add__Ded_"。"结算编号"" ORDER BY" mydb__Posted_Settlement"。"结算编号"

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我有详尽的报告,但行不断重复我该怎么做..这是我的qwery

选择" mydb__Posted_Settlement"。"结算编号"," mydb__Posted_Settlement"。"供应商编号"," mydb__Posted_Settlement"。"到期日期"," mydb__Posted_Settlement"。"结算日期"," mydb__Posted_Settlement"。"名称 "。"城市"," mydb__Posted_Settlement_Line"。"项目编号"," mydb__Posted_Settlement_Line"。"描述"," mydb__Posted_Settlement_Line"。"肉类百分比"," mydb__Posted_Settlement_Line"。"结算重量"," mydb__Posted_Set"。 " mydb__Posted_Settlement_Line"。"金额"," mydb__Posted_Settlement_Line"。"数量"," mydb__Posted_Settlement_Line"。"结算率"," mydb__Posted_Settlement_Line"。"供应商标签"," mydb__Posted_Settlement_Add__Ded"," _"。 " mydb__Posted_Settlement_Add__Ded_"。"金额"来自(" FCL-DBS-01"。" dbo"。" mydb_ $ Posted结算"" mydb__Posted_Settlement"左外部联接" FCL-DBS-01"。" dbo"。" mydb_ $ Posted结算 行"" mydb__Posted_Settlement_Line"开" mydb__Posted_Se ttlement"。"结算编号"" =" mydb__Posted_Settlement_Line"。"结算编号")左外连接" FCL-DBS-01"。" dbo"。" mydb_ $ Posted Settlement Add__Ded_"" mydb__Posted_Settlement_Add__Ded_" ON" mydb__Posted_Settlement"。 " =" mydb__Posted_Settlement_Add__Ded_"。"结算编号"" ORDER BY" mydb__Posted_Settlement"。"结算编号"

付费偷看设置
发送
1条回答
callcenter油条
1楼 · 2020-09-12 07:24.采纳回答

由于联接增加了额外的行,因此您看到的是数据的多个副本-我认为,Posted_Settlement_Line的Post_Settlement中的每一行都可以有多行。 我不确定要加入的另一个表。

这是我要做的,以使报告更易读:

  1. 在发件人Settlement.Settlement_No_上分组
  2. 将来自" Posted_Settlement"的数据放入其组页眉和页脚。
  3. 将来自" Posted_Settlement_Line"的数据放入其组页眉和页脚。
  4. li>
  5. 在详细信息中的每个结算行中放置可能具有多个值的所有数据。 如果每个结算行中仅出现一次附加数据,请将其放在Item_No组页眉或页脚中,并取消显示详细信息部分。

-Dell

一周热门 更多>