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 row
4- 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