Remove duplicate entry

Question

Hi,

I want to truncate duplicate rows but Qty should be added

I have a table filled with data,


Item   Qty   MinQty   MaxQty
ABC    10    20        50
XYZ     12    30        40
ABC     15    20        50

I want the result like,
Item   Qty   MinQty   MaxQty
ABC    25    20        50
XYZ     12    30        40

Kindly help me to write the query for the same...

Answer 1

We can put fields on report dynamically. For it we have to put formula-fields on report on design time.
We can put fields value from database in formula-fields in our c# coding.

For example AttendenceReport is crystal report having formula-field "status".

 AttendenceReport objAttendenceReport=new AttendenceReport();
//{AttendenceTable.Status} values coming from //database                               objAttendenceReport.DataDefinition.FormulaFields["Status"].Text = "{AttendenceTable.Status}";