Hello,
I have a query that queries all the items belonging to a particular order number. I want to create a report that pulls data from this query and generates a receipt. Here is an example, note that Record/fullName and ITEM/PRICE are from different tables.
When I select multiple rows as-is, it prints each row to a different page. Is there a way to have all Items print as a list on the same page. Is there a method in which I can specify to print all ITEM columns where Record equals 530? If not, is there a way to concat ITEMS in the query so they all appear in one column in the query? Open to any method that could solve this problem. Any assistance will be greatly appreciated.
Thank you. (Note: I am using MySQL as my database)