how to print datas in crystal report?

• • Reply

  11 years ago

  by sathyan_8294

  sathyanarayanan

  , India

  Joined 14 years ago
  hai all, i am using dotnet 2005 and sql server2000.i have 2 table as follow table name as bill cutomercode billno capacity unitmodel rate act 101 1 ton elite plus 10 act 122 1.5 ton vertix 32 tablename as unit cutomercode billno capacity unitmodel indoorunit outdoorunit act 101 1 ton elite plus 232 146 act 101 1 ton elite plus 258 231 act 122 1.5 ton vertix 465 521 act 122 1.5 ton vertix 112 101 act 122 1.5 ton vertix 178 104 here cutomercode,billno,capacity,unitmodel,indoorunit,outdoorunit,rate are columns. i wrote a command in database expert in crystal report.i passed the parameter values of customercode and billno. i have coming as follow in crystal report print page. SLNO capacity unitmodel 1 1 ton elite plus indoorunit:232 outdoorunit:146 2 1 ton elite plus indoorunit:258 outdoorunit:231 3 1.5 ton vertix indoorunit:465 outdoorunit:521 4 1.5 ton vertix indoorunit:112 outdoorunit:101 5 1.5 ton vertix indoorunit:178 outdoorunit:104 the above print is wrong.mistake is repeated datas.my client expect print like 1,2,3,4 for each data as follow.i want to display as follow in crystal report print page. SLNO capacity unitmodel 1 1 ton elite plus indoorunit:232,258 outdoorunit:146,231 2 1.5 ton vertix indoorunit:465,112,178 outdoorunit:521,101,104 how to print these datas in crystal report.
  Report abuse