Page 1 of 1

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

Posted: Tue Dec 03, 2019 2:28 pm
by 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?

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

Posted: Sun Dec 08, 2019 9:58 pm
by Lech Kulikowski
Hello,

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

Thank you.

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

Posted: Mon Dec 09, 2019 8:52 pm
by 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

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

Posted: Thu Dec 12, 2019 10:31 pm
by Lech Kulikowski
Hello,

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

Thank you.