Print Page | Close Window

Store procedure with a report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10588
Printed Date: 04 May 2024 at 5:40am


Topic: Store procedure with a report
Posted By: lmobarq
Subject: Store procedure with a report
Date Posted: 20 Jul 2010 at 11:31am
Hello
Where can i find a sample report that use and store procedure in slq server to get the records for the report
I want to know how to do that.
Thank you
Luis



Replies:
Posted By: Emir_W
Date Posted: 20 Jul 2010 at 4:20pm
assume:
- you use Crystal Reports XI
- you have created the Stored Procedure in SQL server and make an ODBC setting.
 
just create new report and use your Stored Procedure (SP) as your Datasource (through ODBC).
 
you'll see a list of all Tables / Views / Stored Procedures from the DB.
 
- select the SP that you want.
- and design your report using all fields from that SP.
 
if there are some parameters in your SP then it will automatically appears in Field Explorer - Parameter Fields.
 
but if the params in your SP using XML format then in CR you'll need to type it manually in 'Parameter Fields'.
 
 
 
hope it help.
 


-------------
Emir W


Print Page | Close Window