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?
Print multiple copies of the same data on a sheet based on a value in another column
-
- Posts: 3
- Joined: Tue Dec 03, 2019 2:10 pm
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Print multiple copies of the same data on a sheet based on a value in another column
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
-
- Posts: 3
- Joined: Tue Dec 03, 2019 2:10 pm
Re: Print multiple copies of the same data on a sheet based on a value in another column
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
Thanks
- Attachments
-
- UDR_PDC_Sort Sheet Original-2-2-3.mrt
- (158.22 KiB) Downloaded 196 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Print multiple copies of the same data on a sheet based on a value in another column
Hello,
You can add an additional databand component and set the CountData property in the Beforeprint event.
Thank you.
You can add an additional databand component and set the CountData property in the Beforeprint event.
Thank you.
- Attachments
-
- Report.mrt
- (776.89 KiB) Downloaded 228 times