I'm doing all the calculations in the proc, if nothing else, it's much easier dealing with division by 0 problems. I'm much more comfortable working in T-Sql.
When a dataset is created by a standard text query and a parameter is included for SSRS wouldn't the parameter get replaced before being executed at the server, meaning sql...