Gareth Horton
July 12th, 2002, 01:52 PM
Damon Longworth wrote:
> Monarch Pro v5.02
>
> I have a report:
>
> App4| John Smith
> |
> App5| Acct:01.6230
> Det | 01: 72.72 35: 7.22 87: 48.48
> Det | Tot Hrs: 128.42 D106: 55.70 D306: 24.23
> Det | Tot Shft: 79.93
> App5| Acct:01.7046
> Det | 30: 12.00 Tot Hrs: 12.00
> App6| Totals: 01: 72.72 30: 12.00 35: 7.22
> Det | 87: 48.48 Tot Hrs: 140.42 D106: 55.70
> Det | D306: 24.23 Tot Shft: 79.93
> |
> |
> App4| Mary Smith
> |
> App5| Acct:01.6080
> Det | 01: 80.00 Tot Hrs: 80.00
> |
> Next record
>
>
> This is the Table:
>
> App5 App4 App6 Det Det Det Det Det Det
>
> ACCT NO NAME TOTALS 01 30 35 87 D106 D306
> 01.6230 John Smith 72.72 0 7.22 48.48 0 0
> 01.6230 John Smith 0 0 0 0 0 24.23
> 01.6230 John Smith 0 0 0 0 55.70 0
> 01.7046 John Smith 0 12 0 0 0 0
> 01.7046 John Smith Totals 72.72 12 7.22 0 0 0
> 01.7046 John Smith Totals 0 0 0 48.48 55.70 0
> 01.7046 John Smith Totals 0 0 0 0 0 24.23
> 01.6080 Mary Smith Totals 80 0 0 0 0 0
>
>
> As you can see, John Smith's detail is being doubled because the detail trap is picking up his actual detail and his subtotal.
>
> I am trying to get rid of the Totals section because it is a subtotal. Subtotals only appear on some records.
>
> In order to remove Grand totals from reports, I will add an append capturing the words "Grand Total" and filter out all lines with "Grand Total". "Grand Total" will appear at the beginning of the Grand Total section of the report and is the last section of the report. Works great.
>
> I am trying to use this method to remove these subtotals. I added an append, trapping and capturing the word "Totals". My goal is to add a filter excluding all lines with "Totals", which would get rid of all subtotals from the report.
>
> My problem is that I cannot get the Append6 to be blank on the next records, which do not have subtotals. Mary Smith does not have a subtotal section. I would like the Totals column to be blank in her row.
>
> I appreciate any assistance with this, or any thoughts on another way to accomplish my objective.
Boy!! The table and report paste looks good in the write or reply mode, but viewing the message looks terrible.
I resolved my problem by making my trap less restrictive. I initially trapped "Totals". By only trapping Alpha characters above the "To", my append picks up "Totals" when there is a subtotal and "Acct:0" when there is not a subtotal. Now I can filter out the subtotals.
> This is the Table:
>
> App5 App4 App6 Det Det Det Det Det Det
>
> ACCT NO NAME TOTALS 01 30 35 87 D106 D306
> 01.6230 John Smith Acct:0 72.72 0 7.22 48.48 0 0
> 01.6230 John Smith Acct:0 0 0 0 0 0 24.23
> 01.6230 John Smith Acct:0 0 0 0 0 55.70 0
> 01.7046 John Smith Acct:0 0 12 0 0 0 0
> 01.7046 John Smith Totals 72.72 12 7.22 0 0 0
> 01.7046 John Smith Totals 0 0 0 48.48 55.70 0
> 01.7046 John Smith Totals 0 0 0 0 0 24.23
> 01.6080 Mary Smith Acct:0 80 0 0 0 0 0
> Monarch Pro v5.02
>
> I have a report:
>
> App4| John Smith
> |
> App5| Acct:01.6230
> Det | 01: 72.72 35: 7.22 87: 48.48
> Det | Tot Hrs: 128.42 D106: 55.70 D306: 24.23
> Det | Tot Shft: 79.93
> App5| Acct:01.7046
> Det | 30: 12.00 Tot Hrs: 12.00
> App6| Totals: 01: 72.72 30: 12.00 35: 7.22
> Det | 87: 48.48 Tot Hrs: 140.42 D106: 55.70
> Det | D306: 24.23 Tot Shft: 79.93
> |
> |
> App4| Mary Smith
> |
> App5| Acct:01.6080
> Det | 01: 80.00 Tot Hrs: 80.00
> |
> Next record
>
>
> This is the Table:
>
> App5 App4 App6 Det Det Det Det Det Det
>
> ACCT NO NAME TOTALS 01 30 35 87 D106 D306
> 01.6230 John Smith 72.72 0 7.22 48.48 0 0
> 01.6230 John Smith 0 0 0 0 0 24.23
> 01.6230 John Smith 0 0 0 0 55.70 0
> 01.7046 John Smith 0 12 0 0 0 0
> 01.7046 John Smith Totals 72.72 12 7.22 0 0 0
> 01.7046 John Smith Totals 0 0 0 48.48 55.70 0
> 01.7046 John Smith Totals 0 0 0 0 0 24.23
> 01.6080 Mary Smith Totals 80 0 0 0 0 0
>
>
> As you can see, John Smith's detail is being doubled because the detail trap is picking up his actual detail and his subtotal.
>
> I am trying to get rid of the Totals section because it is a subtotal. Subtotals only appear on some records.
>
> In order to remove Grand totals from reports, I will add an append capturing the words "Grand Total" and filter out all lines with "Grand Total". "Grand Total" will appear at the beginning of the Grand Total section of the report and is the last section of the report. Works great.
>
> I am trying to use this method to remove these subtotals. I added an append, trapping and capturing the word "Totals". My goal is to add a filter excluding all lines with "Totals", which would get rid of all subtotals from the report.
>
> My problem is that I cannot get the Append6 to be blank on the next records, which do not have subtotals. Mary Smith does not have a subtotal section. I would like the Totals column to be blank in her row.
>
> I appreciate any assistance with this, or any thoughts on another way to accomplish my objective.
Boy!! The table and report paste looks good in the write or reply mode, but viewing the message looks terrible.
I resolved my problem by making my trap less restrictive. I initially trapped "Totals". By only trapping Alpha characters above the "To", my append picks up "Totals" when there is a subtotal and "Acct:0" when there is not a subtotal. Now I can filter out the subtotals.
> This is the Table:
>
> App5 App4 App6 Det Det Det Det Det Det
>
> ACCT NO NAME TOTALS 01 30 35 87 D106 D306
> 01.6230 John Smith Acct:0 72.72 0 7.22 48.48 0 0
> 01.6230 John Smith Acct:0 0 0 0 0 0 24.23
> 01.6230 John Smith Acct:0 0 0 0 0 55.70 0
> 01.7046 John Smith Acct:0 0 12 0 0 0 0
> 01.7046 John Smith Totals 72.72 12 7.22 0 0 0
> 01.7046 John Smith Totals 0 0 0 48.48 55.70 0
> 01.7046 John Smith Totals 0 0 0 0 0 24.23
> 01.6080 Mary Smith Acct:0 80 0 0 0 0 0