Acumatica:如何在主报表子行中从行到列(直线)显示单个文本框

Question

我想在主线上显示SOShipline.QTY，在它的shipline下的每个SOShiplineSplit.QTY以直线而不是行的形式显示。

The report display now and the change I want

感谢任何想提到Tabular Sub-report Property的人是的，我尝试过表格报表，我遇到了一个几天都解决不了的问题。我已经在另一个帖子Acumatica:Tabular Report generates unexpected lines when calling as sub report上发布了我的问题

仅就这个问题而言，有没有人能为我指出一个实现我需求的方法？

Answer 1

不推荐使用SQL视图，但是在这种情况下，您可能需要创建一个。下面的select语句将为您提供所需的一行输出。然后，您将基于视图创建一个DAC。在那里，您可以将视图添加到您的报告中。

-- ------------------------------------------------------------
-- View: usrSOSplit
-- ------------------------------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usrSOSplit]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].usrSOSplit
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create View [usrSOSplit] as 
SELECT  companyid, shipmentnbr,
        isnull(cast([1] as varchar(50)),'')
        +' '+ isnull(cast([2] as varchar(50)),'')
        +' '+ isnull(cast([3] as varchar(50)),'')
        +' '+ isnull(cast([4] as varchar(50)),'')
        +' '+ isnull(cast([5] as varchar(50)),'')
        +' '+ isnull(cast([6] as varchar(50)),'')
        +' '+ isnull(cast([7] as varchar(50)),'')
        +' '+ isnull(cast([8] as varchar(50)),'')
        +' '+ isnull(cast([9] as varchar(50)),'')
        +' '+ isnull(cast([10] as varchar(50)),'')
        as ListOfQty        
      FROM    
    ( SELECT shipmentnbr,companyid,  splitlinenbr as splitLine , qty FROM    SOShipLineSplit ) p
    PIVOT ( max(qty) FOR [splitline] IN ( [1],[2],[3],[4],[5],[6],[7],[8],[9],[10] ) ) AS pvt

DAC：

using System;
using PX.Data;

namespace SoShipSplit
{
  [Serializable]
  public class usrSOSplit : IBqlTable
  {
    #region Shipmentnbr
    [PXDBString(15, IsUnicode = true, InputMask = "")]
    [PXUIField(DisplayName = "Shipmentnbr")]
    public virtual string Shipmentnbr { get; set; }
    public abstract class shipmentnbr : IBqlField { }
    #endregion

    #region ListOfQty
    [PXDBString(509, InputMask = "")]
    [PXUIField(DisplayName = "List Of Qty")]
    public virtual string ListOfQty { get; set; }
    public abstract class listOfQty : IBqlField { }
    #endregion
  }
}

​

​