Job Postings
 Crystal Reports Forum : General Information : Job Postings
Message Icon Topic: crystal report Post Reply Post New Topic
Author Message
rafi
Newbie
Newbie


Joined: 19 Jul 2011
Location: India
Online Status: Offline
Posts: 10
Quote rafi Replybullet Topic: crystal report
    Posted: 12 Oct 2011 at 7:14pm
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)


IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.