Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Another SP Question? Post Reply Post New Topic
Author Message
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Topic: Another SP Question?
    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.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.