User use Sales invoice detail and drag Ref column to update some information, example container number.
User want to display the information at Sales invoice footer, expected result as below
Solution :
Step 1 : in Sales Invoice à Task àDesign à Access the format
Step 2 : Copy and paste the script in “Scripts”
using System.Linq;
private void calc_desc_GetValue(object sender, DevExpress.XtraReports.UI.GetValueEventArgs e) {
QnEBS.BO.Sales.SalesInvoices sinv = GetCurrentRow() as QnEBS.BO.Sales.SalesInvoices;
if (sinv != null && sinv.SalesInvoiceDetailsCollection.Count > 0)
e.Value = string.Join(", ", sinv.SalesInvoiceDetailsCollection.OrderBy(o => o.Pos).Select(o => o.Ref4));
}
Step 3 : in Field List à Point to SalesInv, Address à Right Click à Add Calculated Field
Step 4: Edit Calculated fields
Step 5 : Edit Name to calc_desc
Note : Case sensitive
Step 6 : Click on Script
Step 7 : Select calc_desc_GetValue then click OK
Step 8 : Drag this field to the footer
Step 9 : When Preview the result as below
Please refer to attachment
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article