Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Create View using STP

Author  Topic 

yaman
Posting Yak Master

213 Posts

Posted - 2009-12-01 : 01:50:30
I'm using Crytal Reports to generate reports out of our SQL-backed app. The problem that I've run into is that one of our stored procedures needs to be executed before a particular report will return accurate data.

I need view ? It is possible to create view using that stored procedrue .

Please help me out sir .


Yaman

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-01 : 02:10:00
Views can not execute a stored procedure. Call a stored procedure from your report and have that stored procedure make the call to the other stored procedure and then afterwards return the data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -