Reporting Question

[Newbiequestions]

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	ITEM	QTY	VENDOR PO	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	ITEM	QTY	VENDOR PO	PO DUE DATE	QTY
123	1/21/2022	1	WIDGET 123	10	4540 4546	1/20/2021 2/1/21	5 5
152	1/31/2022	1	WIDGET 123	25	4546 4592	2/1/2021 3/1/21	5 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 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!

[Salem]

Microsoft Visual Studio - Wikipedia
I'm sure someone with the right set of skills (and time) could use Visual Studio to create a script/program in one of several programming languages that VS knows about.

Or indeed in any other programming language, if you forego the eye candy aspects such as syntax highlighting, and just use it as a dumb text editor.