hi
its very urgent requirement please help me i am new to crystal report
i have two tables inv and inv_mat
inv fields are
inv_mat fields are
invoice_no
invoice_no
,invoice_date, prod_name
cust_name, qty
tinno,cstno, rate
sub_total, vat
tot_amt
vat_amt
amt
tot_amt
sample entry from invoice
for inv table
invoice no invoice_date
cust_name tinno cstno subtotal tot_amt
1
12/10/2011 rafi 22 2222
inv_mat
invoice
no prod_name qty rate vat vat_amt amt
1 sony 1 1000 5 50
1050
1 nokia 1 2000
14.5 290 2290
1 elgi
1 1000 14.5 145 1145
tot_amt 4485
i need output would be look this in crystal
report
invoice_no invoice_date cust_name vat14.5% vat5%
amt(before vat caculate) tot_amt (after vat calculate)
1 12/10/2011 rafi 435 50
4000 4485 (it should not be duplicate
but various invoice would be
how to display it in crystal report come)