Last post Jun 16, 2012 04:08 PM by subimal.sinha
Jun 16, 2012 04:08 PM|subimal.sinha|LINK
Consider the following situation, where I have two tables emp, allowance.
emp : emp_id, emp_name, emp_addr ................ emp_id as PK
allowance : emp_id, allowance_name, allowance_amt .................. emp_id as FK
Following is the structure of two tables
emp_id emp_name emp_addr emp_id allowance_name allowance_amt
1 xyz yy 1 x 50
1 y 60
1 z 70
My problem is, when I am displaying the records from two tables in crystal report it is retrieving only one record (first record) based on emp_id (due to where clause) but I want that all the allowance names and amts including the records from emp table
should be displayed such that I can sum up the amt. I am new in this field. Hope u people understand my problem. Thanks in advance.