I have created a custom query report.
The filter is on Vehicle Doctype and it has some other data. I want to fetch and show the Vehicle’s data above the table only once (by expanding the area in the black rectangle I have drawn). Currently, as seen in the screenshot, the Vehicle’s data is showed in every row of the table which is not required.
How can I achieve this using report? I can convert this to custom script report.
I also want to include that data in the PDF/excel that I will be downloading.