Report question

Question: What are the pros and cons to keeping SQL in Stored Procs versus Code