Child Table Report Layout

Mohd_RTC21 · March 31, 2022, 11:50am

Good Day All

I have created a Query Report based on Quotation Doctype and on Quotation Item Child Doctype.
Here is the Code of the Report:

select
    q.name as "Quotation:Link/Quotation:120",q.party_name as "Customer",q.status as "Quotation Status"/*,qit.item_name as "Item Name"*/,qit.brand as "Brand"

from 
    `tabQuotation`q,
    `tabQuotation Item`qit

where
qit.parent = q.name

Now the outcome of the report is every Item in the Child table is in each row individually in the report, followed by the Quotation ID in the same row.
How to gather (or collapse just like the Tree Form feature) all the Items in the Same Quotation ID into one singular row ?

This is the outcome of the report:

In order to avoid duplication of the Quotation ID in multiple rows,
How to add the Tree Form feature in the report ? Similar to this:

Thank you