Print Page | Close Window

To display child record based on parent key select

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12867
Printed Date: 20 Apr 2025 at 10:50pm


Topic: To display child record based on parent key select
Posted By: mukta
Subject: To display child record based on parent key select
Date Posted: 11 Apr 2011 at 2:43am
Hi all

Plz anyone know,

To display child record based on parent key selection on same in crystal report.
I want after selecting empCode to display child record
or when i will load my page then it should hav show both parent n child record of particular empCode.
for this i hav to use one Stored processure to display both tables by supplying empcode..
i write SP. but it displaying only first parent table .
plz tell me...
for eg.
EmpCode: E056

EmpName:ABC


child table
               EmpCode  year         salary
                
                  E056     2009      10000
                  E056     2010       20000



Print Page | Close Window