DevExpress Reporting 根据某个字段,合并单元格
效果
https://img2022.cnblogs.com/blog/1014754/202206/1014754-20220624105531658-794189718.png
同一个SKUCode,Qty 、UOM、Pallets Qty 、CuFt、Lbs,每行给值相同。
public List 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
https://img2022.cnblogs.com/blog/1014754/202206/1014754-20220624105507388-2045339362.png
(注意Tag 、Text直接手写是无效的)
2双击 Tag ,设置根据哪一列进行分组
https://img2022.cnblogs.com/blog/1014754/202206/1014754-20220624103137705-177593525.png
免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!
页:
[1]