Hi, You need to create Key on table Sales Invoice Line for Item category code and then you can use Report wizard to populate the report. Hope this will resolve your problem.
I had already created one Key on table Sales Invoice Line for Item category code, but the result was none. And I must use the same Report 206 structure, because this is a Sales invoice.
I need to know how to force my report to print my sales line grouped by Item category code. Foe example i have one invoice with 10 lines. 5 with Item category code = 01 and other 5 with Item category code = 02.
My report will be the same but on sales invoice line Body with only 2 lines.
In the properties of your dataitem you have to put your new key in DataItemTableView, the Item category code in GroupTotalFields. In TotalFields you must have all the fields that you want to show in your GroupHeader section, these fields must be in the sumindexfields of your key.
Thanks for your help. At this moment, on Sales Invoice Line GroupHeader, only Item category cod is ok, the Quantity,Unit Price,Line Amount does not appear.
I had alreadycreated in TotalFields Sales Line DataItem property created this fileds Quantity,Unit Price,Line Amount, these fields arein the sumindexfields of my sales Invoice Line new key.
But this fields does not appear im my report, why not?
I am speaking about Quantity,Unit Price,Line Amount. All this fieldsbelongs to Sales line Invoice body, and now I need each one in a sum grouped by ItemCategoryCode.
If item category code appears OK in groupHeader why this ones doesn’t. I tried with variables, but without success