Hi All,
I have a requirement where I am confused to choose between drill through and master detail .
summary and more level detail data are present,Hence I have suggested to go for drill through.Now the user wants every thing in one single report.
Can anybody suggest which one will have good performance?because number of column is more.
Thanks,
Mita
Which one will have the better performance depends on how the report's users are going to work with it:
- If a user will run the report and then spend a significant amount of time to look at various data all over the report, then using master-detail is more likely to be justified. The report will run for a longer time, but once it's finished, all data is available and the user can just go back and forth all over an export.
- If however the user will go in to spot check just a small handful of data, then likely drill-through will be the better option. The user will have multiple loading during the report experience, but those will likely take less total runtime than running the entire report with master-detail.
In the end, there is no single, always-true answer to your question. User experience and its perception are very much linked to user expectation, which varies for every case.
Thank you Hespora for your suggestion.. :)