SQL Server Stored Procedure to Generate Recrodset for Crystal Report

[mohaimen]

Hi,

I am developing few reports using Visual Basic 6 and Crystal Report 8.5 from a SQL Server 2000 database. The reports will use SQL Server stored procedures to get the recordsets. Can anyone tell me how to do it? I tried using SetDataSource method of the database object, it produced error.

Regards.

Mohaimen

 

[jlsmithhartfiel]

If using the report wizard on startup; click on database, then on options. Check the show stored procedures checkbox.
click ok. connect to database, select stored proc, add as you would a table.

Jessica

 

[synapsevampire]

If you're always going to use that SP for a Crystal canned report, then you should be able to do as Jessica describes.

If you're wanting to do something dynamic:

Are you using ADO?

Are you familiar with TTX files?

Check this FAQ:

http://support.crystaldecisions.com/library/kbase/articles/c2002390.asp

-k