can visual studio manipulate sql data to format a report like below

Question

Reporting Question I have been asked to see if Visual Studio could format a report like below.

here is a bit of data that was pulled via SQL query from ERP system.

ORDER CUSTOMER DUE DATE LINE# ITEM QTY VENDORPO PO DUE DATE QTY 123 1/21/2022 1 WIDGET 123 10 4540 1/20/2021 5 152 1/31/2022 1 WIDGET 123 25 4546 2/1/2021 10 152 2/15/2022 2 WIDGET 123 25 4592 3/1/2021 50

Is there a way to make a report in visual so that it looks like this

ORDER CUSTOMER DUE DATE LINE# ITEM QTY VENDOR PO PO DUE DATE QTY 123 1/21/2022 1 WIDGET 123 10 4540 1/20/21 5 4546 2/1/21 5

152 1/31/2022 1 WIDGET 123 25 4546 2/1/21 5 4592 3/1/21 20

152 2/15/2022 2 WIDGET 123 25 4592 3/1/2022 25 INVENTORY BALANCE 5

Our reporting will not give an accurate open order report with expected purchase order delivery dates that we can send to our customers. Just wondering if Visual could be scripted to do what we wanted.

thank you for any input!