-
Last page title of the query result
TTITLE LEFT 'Province: ' Province_Code
break on Province_Code SKIP PAGE on report
column Province_Code format A15 heading "Province_Code" NEW_VALUE Province_Code
compute count label 'Count' of ID on report
compute sum label 'Sub' of Amount on Province_Code
compute sum label 'Total' of Amount on report
select province_code, id, amount from test_table;
------------------------------------------------------------------
This script returns a report with page titles of Province value. In the last page, it shows the COUNT and TOTAL, but it appears an extra page title:
Province: ON
Province_Code ID AMOUNT
--------------- ---------- ----------
ON 21 4354
32 543254
54 5345524
*************** ----------
Sub 5893132
Province: BC
Province_Code ID AMOUNT
--------------- ---------- ----------
BC 41 4325
43 34255
*************** ----------
Sub 38580
Province: BC
Province_Code ID AMOUNT
--------------- ---------- ----------
---------- ----------
Count 5
Total 5931712
5 rows selected.
How could I remove the last page title?
Thanks.
Queyon
Queyon Zeng
-
Hi
I am not expert but can you try
break on Province_Code SKIP PAGE on report changing this to
break on Province_Code
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|