DOCS TEMPLATE PRODUCT SUMMARY TABLE

[bolognesiedalla]

Hello everybody
I want to create a report with a summary table of products used in a fertilization plan. The table in question must show the product used and the sum of the quantities. My problem is that I tried to get a unique value for the name of the products but I still see duplicates (probably something wrong in the expressions). any help?

I initially filtered the table of interventions rows based on [IDPIANO] and [DISTRIBUTION]. then I thought it was enough to use UNIQUE but ...

template

body report

table unique products

these are my table (parent-child-grandchild)

parent

child

grandchild

[WillowMobileSys]

Move the START and END into the table row.  It should look something like this:

Header row
<<START:...>><<[Column1]>>	<<[Column2]>>	<<[Column3]>>	...	<<[ColumnN]>><<END>>

Note that START is inside the first row column as well as the column to be displayed - no spaces between.  END is inside the last row column - no spaces between.

These expression can make the table formatting in the template look weird.  But the generated document will be fine.  If you do need to adjust column widths, row height or other formatting, come back to the template and use the TAble Properties to make these adjustments.