I have a report requirement where I need to calculate totals based on the field HSCODE, if detail lines have the same HSCODE then their total is calculated in the footer, considering those lines together. Please let me know a solution to cater this requirement.
Hi
If yes, then you need to create a variable in the header section and assign value expression as “Sum(DAC.FieldName)” and then assign this variable to the Header Field.
Here is sample example for your reference. I have customized Sales Order report that getting sum value of QTY at line level and assigning it to new Header field by using variable. Please find the screenshots for reference.



Hi

$sumoftotalqty + IIF($inventoryid=True,qty,0)
and place a text box at the footer and just provide the value as $sumoftotalqty
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.