Print Page | Close Window

Another SP Question?

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=9503
Printed Date: 06 May 2024 at 10:41pm


Topic: Another SP Question?
Posted By: hugo69
Subject: Another SP Question?
Date Posted: 25 Mar 2010 at 11:01am
If I do have a SP is there any way to find out where the data field is being pulled from. Can I look at the Show SQL Query?
 
This is what I have:
 
SP = R_Cell_History;1
 
Show SQL Query =
{CALL VSI_DATA.dbo.R_Cell_History;1(NULL, NULL, NULL, NULL, NULL)}
 
I would like to find where a couple of fields are in this SP. With the fields in the SP they have to be pulling from some table somewhere in the database correct?
 
This is a 3rd party program that the SP were already in the program.


Replies:
Posted By: BrianBischof
Date Posted: 25 Mar 2010 at 6:35pm
If your report is calling the SP, then doing a Show SQL Query will only show you the call to the stored procedure. It won't show you what the code within the stored procedure. The only way to do that is to you a database management tool (e.g. Sql Enterprise Manager) to examine the SP. Crystal can't do it.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window