DevExpress Reporting 根据某个字段，合并单元格

 

效果

 同一个SKUCode，Qty 、UOM、Pallets Qty 、CuFt、Lbs，每行给值相同。

public List<ReceiptsLabelDto> GetPalletLabelList(string languageId, long receiptId)
{
var list = GetMuInventoriQueryable(languageId).Where(d => d.ReceiptId == receiptId && d.UseMu == true).ToList();
foreach (var item in list)
{
var query = list.Where(d => d.Skucode == item.Skucode);
item.Qty = query.Select(d => d.MuInventoryQuantity).Sum() + "";
item.PalletsQty = query.Select(d => d.MuInventoryQuantity).Count();
item.CuFtSum = query.Select(d => d.CuFt).Sum();
item.LbsSum = query.Select(d => d.Lbs).Sum();
item.CuFtSum = (double?)RoundTwo(item.CuFtSum);
item.LbsSum = (double?)RoundTwo(item.LbsSum);
}
return list;
}

 

 

1 SKUCode列设置为Merge、Value，其它列设置为Merge、Tag

 

 

 

（注意Tag 、Text直接手写是无效的）

 2双击 Tag ，设置根据哪一列进行分组