<div>
you can give it a try. Best way is hit and trial. Write a simple cursor and try.<br />
But I will still prefer stored procedure because the plan is cached. And why not create stored procedure with cursor?
</div>


you can give it a try. Best way is hit and trial. Write a simple cursor and try.
But I will still prefer stored procedure because the plan is cached. And why not create stored procedure with cursor?

<div>
<div class="content wysiwyg-content">
Can you have cursors in your query when creating a report in SSRS, or do you need to created a stored procedure and execute?
</div>
</div>


Can you have cursors in your query when creating a report in SSRS, or do you need to created a stored procedure and execute?

SSRS  and Cursors

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.