SSRS Report drop down parameters. Use SP or embeded SQL query for datasource?
Apparently there is not a set (or recommended) standard (that I could find). Since development needs vary from project to project the developer should decide during the development process, whether to create stored procedures for their parameter data sources or to simply hard code the drop down values inside the report itself.