Hi,

I don't have any links as of now and i hope to update in the future. In order to go deeper we have to fully understand how the reporting service is executing the queries.

I suggest you to use SP's for ease of maintainability. Changing the RDL file is not easy once it's deployed. So whenever you develop reports in Reporting services design in a such way that you are not touching the RDL when you want to implement new changes.

Thanks,

Jegatheesh