Print multiple copies of the same data on a sheet based on a value in another column

[bgenes1179]

I'm using an ERP software to make an inspection log. The data the report pulls from will have a piece mark with a given quantity associated with it. I'd like to print a separate row for each piece mark in the event that one typical piece of an assembly may pass while another can be marked as failed.

This would translate:
{MainMark} - {Quantity}
B1001 - (1)
B1002 - (2)
B1003 - (1)

To This:
B1001
B1002
B1002
B1003

Is there a specific function or command that will allow me to extract the data in such a way?

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[bgenes1179]

See the attached file. I can't attach the database this file pulls data from because I'm told it is locked behind the ERP software's API though.

Thanks

[Lech Kulikowski]

Hello,

You can add an additional databand component and set the CountData property in the Beforeprint event.

Thank you.