Agfdhyk

I would like to show the SOShipline.QTY in main lines, and every SOShiplineSplit.QTY under its shipline in straight lines and NOT in rows.

The report display now and the change I want

Thanks to anyone who would like to mention Tabular Sub-report Property
Yes, I've tried tabular report, I have met a problem I can not solve for several days. I've posted my problem in another post
Acumatica:Tabular Report generates unexpected lines when calling as sub report

For this question only, can somebody point out a way for me to realize my need?

SQL views are not recommended however in this case you might need to create one. The select statement below will give you the one line output that you need. Then you would create a DAC based off the view. From there you would be able to add the view to your report.

-- ------------------------------------------------------------

-- 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

  }

}