I am hoping to sort the totals for a report (using CR 8.5 Standard) so that the running total values will be added starting from the end of the report (earliest date for All Evnts, Init. Evnts) to the beginning (most recent date for All Evnts, Init. Evnts).
I tried inserting a Running Total for All Evnts (All Run) and Init. Evnts (Init. Run - not shown) but they add from the beginning date to the ending date. The All Sort ,Init Sort and % Sort columns (Created in Excel for Illust.) show how I would like the values to be sorted. The % Sort column ideally should be (Init. Sort/All Sort)*100.
I am using two groups:
Group 1 requests the parameters for the month range, and is sorted Descending ,and changed for each month
Group 2 is for the value of the date field and is sorted Descending, changed for each day.
The All Run RT Field is a sum of @ Remind Count which simply counts all details for each day, Evaluate is for each record, and Reset is set to Group 1, the month.
The Init Run RT Field (not shown) is a sum of @iexam=exam which counts all details where these 2 fields are equal; Evaluate is set to for each record, and Reset is again set to Group 1.
The Formula for the month selection (which I need for custom month selections) uses the WhileReadingRecords function.
Here is the output, including the 3 Sort fields showing the desired results.
I hope there is a way to do this, maybe without running totals? Since I don't seem to be able to select Asc, or Desc for RT functions...
Thanks in advance,
-tg
I tried inserting a Running Total for All Evnts (All Run) and Init. Evnts (Init. Run - not shown) but they add from the beginning date to the ending date. The All Sort ,Init Sort and % Sort columns (Created in Excel for Illust.) show how I would like the values to be sorted. The % Sort column ideally should be (Init. Sort/All Sort)*100.
I am using two groups:
Group 1 requests the parameters for the month range, and is sorted Descending ,and changed for each month
Group 2 is for the value of the date field and is sorted Descending, changed for each day.
The All Run RT Field is a sum of @ Remind Count which simply counts all details for each day, Evaluate is for each record, and Reset is set to Group 1, the month.
The Init Run RT Field (not shown) is a sum of @iexam=exam which counts all details where these 2 fields are equal; Evaluate is set to for each record, and Reset is again set to Group 1.
The Formula for the month selection (which I need for custom month selections) uses the WhileReadingRecords function.
Here is the output, including the 3 Sort fields showing the desired results.
Code:
Date All Evnts All Run All Sort Init Evnts Init.Sort % Sort
4/19/2005 1,312 1,312 33,985 1,086 28,211 83.01
4/18/2005 1,311 2,623 32,673 1,080 27,125 83.02
4/17/2005 5 2,628 31,362 4 26,045 83.05
4/16/2005 120 2,748 31,357 115 26,041 83.05
4/15/2005 1,293 4,041 31,237 1,071 25,926 83.00
4/14/2005 1,351 5,392 29,944 1,095 24,855 83.00
4/13/2005 1,443 6,835 28,593 1,184 23,760 83.10
4/12/2005 1,431 8,266 27,150 1,203 22,576 83.15
**omitted middle values for space
3/29/2005 1,636 23,969 11,652 1,352 9,728 83.49
3/28/2005 1,594 25,563 10,016 1,325 8,376 83.63
3/27/2005 3 25,566 8,422 1 7,051 83.72
3/26/2005 75 25,641 8,419 70 7,050 83.74
3/25/2005 1,394 27,035 8,344 1,163 6,980 83.65
3/24/2005 1,668 28,703 6,950 1,374 5,817 83.70
3/23/2005 1,774 30,477 5,282 1,500 4,443 84.12
3/22/2005 1,782 32,259 3,508 1,507 2,943 83.89
3/21/2005 1,723 33,982 1,726 1,433 1,436 83.20
3/20/2005 3 33,985 3 3 3 100.00I hope there is a way to do this, maybe without running totals? Since I don't seem to be able to select Asc, or Desc for RT functions...
Thanks in advance,
-tg