How best to report on child collection items in a XAF web report

Hi Richard,

As I mentioned before, it is impossible to access child values by their indices. At the same time, you can create a CalculatedField instance, create the OnGetValue script for it, and perform the required actions in this script. Let's take your previous description of your data structure. If your report is bound to Invoice, which has the CustomFieldList property, your OnGetValue script implementation will look like this:

C#
private void calculatedField_GetValue(object sender, GetValueEventArgs e) {  
    Invoice inv = e.Row as Invoice;  
    e.Value = inv.CustomFieldList[10];  
}  

You can also perform the same actions for a particular control. Create the OnBeforePrint script for the corresponding label, obtain the current Invoice instance using the GetCurrentRow method, and then pass the required value to the XRLabel.Text property:

C#
private void label_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {  
    XRLabel label = sender as XRLabel;  
    Invoice inv = label.Report.GetCurrentRow() as Invoice;  
    label.Text = inv.CustomFieldList[10].ToString();  
}  

Thank you!  That sounds like it will work, but could you please point me to some documentation on how to use calculated fields in the web report designer?  I've found documentation for the windows version, but I can't find how to place a calculated field on a report (or link a text box to a calculated field).  I know this must be super simple, but I can't find it.
I can create a calculated field (under the "Data" group when the report is selected).  However, once I've done that, I cannot find that calculated field when trying to link a text box to the calculated field using the "Data Binding" selection box.

Hi Richard,

To process your recent post more efficiently, I created a separate ticket on your behalf: T305167: How to use calculated fields in a Web Report Designer. This ticket is currently in our processing queue. Our team will address it as soon as we have any updates.