PeHoBe
Member
Hi,
I'm trying to get the Pick Slip print to BI Publisher, but apparently the XML is wrongly structured to do this with a simple For-Each@Section command.
In short: the report simply has a repeating number of nodes for all detail lines that are involved in the X number of pick slips printed and the header information (ship-to/sold-to etc...) is captured in a child node of the first detail node of a pick slip.
Visually:
-Root
--PS1/Line1
---PS1/HeaderInfo
--PS1/Line2
--PS1/Line3
--PS2/Line1
---PS2/HeaderInfo
--PS2/Line2
--PS2/Line3
...
I have the impression I first have to do a transformation (XSLT) of the XML to efficiently process it in Word using a For-Each@Section.
Can anybody shed a light on how to tackle this?
Thanks,
Peter
I'm trying to get the Pick Slip print to BI Publisher, but apparently the XML is wrongly structured to do this with a simple For-Each@Section command.
In short: the report simply has a repeating number of nodes for all detail lines that are involved in the X number of pick slips printed and the header information (ship-to/sold-to etc...) is captured in a child node of the first detail node of a pick slip.
Visually:
-Root
--PS1/Line1
---PS1/HeaderInfo
--PS1/Line2
--PS1/Line3
--PS2/Line1
---PS2/HeaderInfo
--PS2/Line2
--PS2/Line3
...
I have the impression I first have to do a transformation (XSLT) of the XML to efficiently process it in Word using a For-Each@Section.
Can anybody shed a light on how to tackle this?
Thanks,
Peter