I am trying to subtotal by Sales Order #. It is not working.
Thank you, Sandra
Date
Votes
4 comments
-
Jet Reports Historic Posts Hello,
You cannot have two NL("Rows") formulas on the same row… Read some more about grouping and you should work it out!
Elena -
Jet Reports Historic Posts Hi Sandra,
Have you tried the Table Builder in Jet Essentials? I think that would make things a lot easier for you to combine the Sales line and Sales header table into an Excel table. From there, you can do the grouping, sorting, totalling etc. with Excel. -
Jet Reports Historic Posts Elena, you actually can have multiple NL(Rows) formulas on the same row. It doesn't perform quite as well as putting them on different rows, but it does work generally speaking.
Sandra, using Excel sorting/filting this way can lead to problems because you can resort values that cause your original formulas to get deleted when you go back into Design mode in Jet.
Hans' suggestion is a good idea. If you decide you don't want to use the Table Builder to build the report, you can return the No. and Document Type fields from the Sales Header table with NF functions. Then in your NL(Rows) on Sales Line, you can filter the Document No. and Document Type fields by the values you are returning from the Sales Header table. You also must move your filter for Document No. from the Sales Line to the Sales Header since filtering on the same field twice wouldn't work. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Thank you all for your input. I have found that using the Table Builder limits my report possibilities. It was really good in the beginning when I was first learning but found I could not "Hide" columns, and do some other formatting. I will try Hughes suggestion and see if that works.
Thank you,
Sandra
Please sign in to leave a comment.