I always start an SP as a query. Once I have the query and the variables working, I turn it into a stored procedure. The query runs fine in SSMS and the stored procedure works fine in SSMS. The columns have proper names and SSRS in design mode sees them and lists them. It is just when I try to run the Preview that it can't find the SP.