Can Crystal report used stored procedures in MSSQL

[vjvincent]

Hi everybody. Im new in Crystal report. We are using ASP/XML as our architecture here. I would like to asked if we can used Stored Procedures in Crystal Report instead of the method "SQLQueryString". We don't allow any embedded SQL Statement in ASP codes.

Thanks in Advance.

 

[kenhamady]

Yes, CR can read Stored Procedures. They will show up as tables in the data explorer. Make sure in File-Options you have the setting to show Stored Procedures. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[vjvincent]

Thanks Ken.

I have another question . . .


Can I indicate the specific Stored Procedures in ASP that will be used in a specific Crystal Report???

For Example:

SET objReport = objCrystal.OpenReport(Server.MapPath(strRPTPath))

objReport.SQLQueryString "SELECT * FROM LIB_EXAM WHERE EXAMID = 2"

Can I replace the Embed Query String with Stored Procedures???

Thanks in Advance

 

[kenhamady]

I am pretty sure, but I don't know the exact ASP syntax for that. You might try posting this in the Crystal Integration Forum. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[vjvincent]

Thanks Ken