DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Last page title of the query result

  1. #1

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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
  •  


Click Here to Expand Forum to Full Width