Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Linking fields! SQL DB Post Reply Post New Topic
Author Message
server_sap
Newbie
Newbie


Joined: 09 Mar 2011
Location: Germany
Online Status: Offline
Posts: 14
Quote server_sap Replybullet Topic: Linking fields! SQL DB
    Posted: 01 Apr 2011 at 2:47am
Hi Everyone,
 
i have ran into an issue about linking 3 fields in 2 stored procedures ,
I have a stored procedure called 'MasterService' in which there are 2 fields:
MasterServices
Checklist
 
I have another stored procedure called 'Trainers' in which i have a field as:
TrainerName
 
now i want them to link as below logically :
 
TrainerNamer
     MasterService:( masterservice only which is associated with above trainer )
            -Checklist ( Checklist only which is associated with that masterservice )
 
I am using CR 2008 with SQL database , i tried linking with database expert but it does not give me result as above .
 
the field 'checklist' prints all the checklists weather its relevant to above field or not .
 
can achieve that using a formula ?
 
Thanks in Advance guys
Regards
Server_Sap
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 04 Apr 2011 at 3:34am
why not combine your 2 stored procs into 1, then you will return one row of data for each linked record, and you will know that the link is correct.
 
I've read where others have posted about enforcing the links and when that occurrs, but since I always return just 1 table from my stored procs, I haven't had need learning about when this applies.
 
HTH
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.