How to customize Report Definition - Drill down data to be below to Parent row on click parent row
I am trying to create a drill down report with Report Definition as per my business requirement.
Business is looking to have the drill down data below to the parent row on click of the parent row. But with the existing "Disable drill down" option in RD, its opening in a new window and that to on click of the summary or aggregate column not on the row.
Appreciate your kind supports with screen shot examples.
Attached is the sample report which i am looking for. Let me know if you need more details.
***Updated by moderator: Lochan to add Categories***
Thanks a lot for your suggestion. I tried this at my end but facing some issues in the main grid.
In my custom section, i have taken a repeat grid with DataPage/Report Definition as source. I am seeing the records are getting repeated in the report body. Meaning if the report is giving a total of 10 records then i am seeing all the 10 records as one row and repeating the same for 10 rows. I tried to do all the configurations but of no use. Appreciate if you can provide a sample with screen shots.