Check out this posting for some tricks - quite honestly I rarely use Sort by Sum. It's taken time, but I have taught management that they would rather have the report run quickly than have the sort built in :) .
http://community.jetreports.com/viewtopic.php?f=23&t=2109&p=6140&hilit=easiest+way+to+teach#p6140
If the link doesn't work, just do a search in the forum for "Easiest Way to Teach" - using these steps is how I was able to accomplish this task, and I agree, it makes the process much easier to understand.
Date
Votes
2 comments
-
Jet Reports Historic Posts My rows formula is like this:
=NL("rows=2";"Job";;)
In my table "Budget Entry" I have budget post with income and cost.
The field "Project No." in the table "Budget Entry" equals the field "No." in the "the "Job".
The field "Total Price" is the income field for the budget post.
The field "Budget version" is the version of the budget. I only need to look at post with "budget version=KALK".
The problem:
I would like to sort my "jobs" by the the sum of field "Total Price" from post from the table "budget entry" with "budget version = KALK" from the highest to the lowest.
Any ideas? -
Jet Reports Historic Posts Excellent!
That was exactly what I was looking for!!
Please sign in to leave a comment.