Danish Habib

Danish Habib

  • NA
  • 694
  • 233.2k

chart in crystal report

Aug 6 2015 2:38 AM
I have Three tables 
First one
 RecordID(P) Q_1Q_2  Q_3 CityNAME(F)
 1 23 23 23ISL
 Second table 
 ID  (F)  A_1 A_2 A_3 CITYNAME(F)
 1 45 23 4 ISL
     
 
 
 
 TabID CITYID(P) CITYNAME
 P FOR PRIMARY KEY AND F FOR FOREIGN KEY Now I want to show a chart showing TWO BARS First BAR SHOULD SHOW THE SUM OF (Q_1+Q_2+Q_3) and second line bar shoud show (SUM(A_1+A_2+A_3) inclusive all rows in both the tables , how to show that chart , if i am using formula field then how to give parameter to formula field in crystal report CR13.