What is the best reporting technique?

What is the best reporting technique should I use with crystal reports and SQL server to get the best reporting performance?
- use SPs?
- summary information should be summarized in the SP first or summarized in the Crystal report?
- if I want to do some calculations, should I use any temp database in the client machine? (access db for example)? or I may use the SQL server temp db?
- can I easily isolate the temp db per user?
- does the temp db increase the log file?

In terms of best reporting techniques, its always ideal to use a SP and perform calculations on server side to transfer the results back to client. In any case SQL Server 2005 onwards TEMPDB is used heavily.

What is the best reporting technique should I use with crystal reports and SQL server to get the best reporting performance?
- use SPs?
- summary information should be summarized in the SP first or summarized in the Crystal report?
- if I want to do some calculations, should I use any temp database in the client machine? (access db for example)? or I may use the SQL server temp db?
- can I easily isolate the temp db per user?
- does the temp db increase the log file?