1- we have 2 SQL tables (one contains fields like emp_id, name, designation, section and other emp related info And 2nd table contains emp_id, allowance_name, allowance_amount, deduction_name, deduction_amount)2- we need a crystal report showing section wise employees 3- single employee data must be in a single row4- sample report fields can be emp_name, emp-designation, allowance1, allowance2, ..., allowanceN, SumOfAllowances, deduction1, deduction2, ..., deductionN, SumOfDeductions, SumOfAllowances-SumOfDeductions.I deadly need this sum1 plz help