Hello,
I've successfully created a commission report that works great! But I want to take it to the next level and show detailed information about the item utilization per Group and representative. I've attached a sample of my report which will show you the equations I'm using and the fields I want to add. I've gotten this far and for some reason I can't get the additional rows within the invoice line to show. Any help would be greatly appreciated!
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
your document-no is in $H16.
I would do a "=H16" in cell H17 to get the document-no in each line. Then Change the "NL(rows)" and "NL(first) from "document-no=H16" to "document-no=H17"
do the same with "salesperson" to get every Information for the NL-function in every line…
give it a try…
regards
jetsetter -
Jet Reports Historic Posts You could do the same cell reference work around that you did with the SalesPerson code (column D) for the document number. This would allow you to hide the column if you put it in its own column and used the Jet keyword HIDE in the column top row. As JetSetter mentioned you need something to pass that doc number to the detail row lines or it wont calculate properly. This will just allow you to hide the repeated info.
Best
Jason
Please sign in to leave a comment.