bom多层展开打印，有效果图，如何实现

[htflyfish]

实现以下效果:
数据库为k/3,按多层排序,求sql的语句或在pb中解决方案
跟bom相关的有4张表，icbom(bom主表）,icbomchild(bom分录表）,t_icitem(物料表）,t_MeasureUnit(单位表),以下为单层查询的代码：
SELECT ICBOMChild.FEntryID as 序号,
t_ICItem.FNumber as 物料代码,
t_ICItem.FName as 物料名称,
t_ICItem.FModel as 规格型号,
ICBOMChild.FQty as 数量,
t_MeasureUnit.FName as 单位,
ICBOMChild.FMachinePos as 工位,
t_ICItem.FChartNumber as 图号,
ICBOMChild.FNote as bom备注,
ICBOMChild.FItemID as 父项物料代码,
ICBOM.FBOMNumber as bom编号,
ICBOM.FUseStatus as 使用状态,
ICBOM.FVersion as bom版本,
ICBOM.FCheckDate as 审核状态,
ICBOM.FNote 说明,
'.1' as "l1",'' as "l2",
ICBOM.FAudDate
FROM t_ICItem LEFT OUTER JOIN t_MeasureUnit ON t_ICItem.FUnitID = t_MeasureUnit.FMeasureUnitID,
ICBOM,
ICBOMChild
WHERE ( ICBOM.FInterID = ICBOMChild.FInterID ) and
( ICBOMChild.FItemID = t_ICItem.FItemID ) and
( ( ICBOM.FItemID = :itemid ) )

[htflyfish]

图片在这里

[meiZiNick]

关注 接分