hi please help me i am struggling here
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 amt
vat_amt tot_amt
sample entry from invoiceform
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 come)
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 amt
vat_amt tot_amt
sample entry from invoiceform
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 come)
