Report Viewer datasets and store procedures

Is there anyway to bind a report viewer’s custom property dataset to a store procedure?

I have a store procedure that returns a temporary table and that temp table will need to be displayed in a report. Is there anyway to do this?

If you go into the binding for the custom property, then select SQL Query as the binding type you can then execute the stored procedure in there?

(i.e. rather than doing “SELECT * FROM tablename” just write an SQL line to execute the SP)