Hi
I have tried to read threads but still having issues with removing blank rows from data. I have created an Indented Bill of Material with everything properly link. I have 5 groups for the various levels with Parent linked to component for each of the tables.
Group A Comp_item
Group B Comp_item
Group C Comp_item
I am getting blank lines where no components are present. It creates a blank row and creates a very long report.
Current result
105112
105337
Blank becuase no Group c component present
120328-001
102236
200053-01
200092-01
I have tried suppress blank section, I have tried formula {bmprdstr_sql_2.item_no}='null' for group section
Thanks for feedback. I can send .RPT if desired.