BOM Export With Custom Level in XEN and Report Template

Hello All Users and Experts,

How can I customize the numbering in the level section when export BOM? The scenario of the export output I receive with the XEN (Product Release Engineer) role is as follows.

  • Open Product with leafs in XEN.
  • Click Export button and fill the sections like ScreenShot_1.
  • The Excel output after pressing the Export button is as shown in ScreenShot_2. The output of the Level column is like 0,1,2.
  • What should I do to make the level column in the BOM export look like ScreenShot_3?
  • The top product of the Level section must be 0. The first levels after that should continue from 0 to 0.1, 0.2, 0, 3. When you move to the 2nd level, you should continue by adding a dot next to the section you passed, for example, if you move to the 2nd level at 0.3 level, you should continue like 0.3.1, 0.3.2, 0.3.3.
  • I'm not sure if I can provide this output with the XEN role. So can it be done with Report Template Design or Quality Rule Reuse applications?
  • If I export the outputs from the interfaces shown in ScreenShot_4 and ScreenShot_5, How can I create a level column as I wish.
  • I know that customization can be done for exports with Report Definition, but can you help me do it the way I want?

ScreenShot_1

    

ScreenShot_2

ScreenShot_3


ScreenShot_4

   ​​​​
ScreenShot_5