I am having 10 reports. And im imoprting all the reports as sub report into a main report.
Hence, when i run the main report, how many times it will hit the DB.
either only one time, or for all the subreport it will hit. ( that is 11 times including main report's hit).
Main report as well as sub reports are using the same Stored procedure.
I need minimum number of DB hit. How can i do this.
Thanks in advance,