Print Page | Close Window

crystal report

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Job Postings
Forum Discription: Submit permanent and contract job openings for thousands to read.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14662
Printed Date: 06 May 2024 at 7:37am


Topic: crystal report
Posted By: rafi
Subject: crystal report
Date 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)





Print Page | Close Window