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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Visual Studio and Crystal Reports

Author  Topic 

POnfri
Starting Member

3 Posts

Posted - 2004-03-01 : 22:15:08
Can someone tell me why int he world i can not see the stored procedures when generating a report thru the Crystal wizard. I have changed security ont he database, stored procedure and have even created a simple SELECT * procedure and nada

Thanks fo rthe help anypone.

nr
SQLTeam MVY

12543 Posts

Posted - 2004-03-02 : 05:07:24
You need to set crystal reports to allow reports based on SPs. The default is tables only.

File, Options, SQL, Allow reporting on.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -