Using Stored procedure as a data source in SSRS

I have been using stored procedure as a data source in SSRS 2008. The procedure has many parameters. When I design a report in BIDS 2008, it calls the procedure each time when I  make a small change in design mode and preview the report. But I do not want to call the procedure every time when I am designing the  report.  Is is possible in BIDS 2008/Visual Studio 2008?

Thanks and Regards,

Ganesh

The only thing that I can think of that you may want to do is put a parameter above it and have it act more like a cascading parameter, but then you will not see the fruits of your labor when trying to preview. Unfortunately, there is no way to render a report without getting the data.

I agree with you that  no report without getting the data. However, I am looking a similar functionality in SSRS  as in Crystal Report. In crystal report, we can switch the design and preview mode very quickly without refreshing the parameter value and see the report preview while designing reports. But in BIDS, when I make a small change in design mode and switch to the preview mode, it keeps running for a while to see the report preview.   We have other developers in the team who use Crystal report and beleive that  SSRS calls stored procedure from the database  eachtime when we make a small change in design mode and preview the report.

My question is similar to the following link.

http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/0b5a5603-b7b5-4be5-be3a-dbc4625d47ed

Thanks

Ganesh

Other way – to create some query or testing table with a sample report data and make final select without other procedure steps(comment them temporally).

If I understand your issue try this.  Set a default value for each parameter, that way the data is saved locally and the preview is faster.

HTH