DEFINE FILE PONAME
RANK/A4=  EDIT(OVERALL_RANK_1,'$$99');
OVERALL_Rank_1_Defined/A4=IF RANK EQ '99' THEN 'N/A' ELSE RANK;
END
TABLE FILE PONAME
BY  PO_NAME AS 'PO Name' NOPRINT
BY  OVERALL_Rank_1_Defined AS 'PO Rank'
BY  PO_NAME AS 'PO Name'
WHERE REPORTMONTH EQ &Current_Year;
END
 

This is 6th page report:
DEFINE FILE PONAME
RANK/A4=  EDIT(OVERALL_RANK_1,'$$99');
OVERALL_Rank_1_Defined/A4=IF RANK EQ '99' THEN 'N/A' ELSE RANK;
END
TABLE FILE PONAME
BY  PO_NAME AS 'PO Name' NOPRINT
BY  OVERALL_Rank_1_Defined AS 'PO Rank'
BY  PO_NAME AS 'PO Name'
WHERE REPORTMONTH EQ &Current_Year;
END

quote:

Is it possible can I show all the Ponames and Poranks on the last page without burst page.

TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
    SALES
BY COUNTRY
BY CAR
ON TABLE SET COMPOUND BYTOC
ON TABLE PCHOLD FORMAT XLSX OPEN
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
    SALES
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Summary', $
ENDSTYLE
END
-RUN

quote:

Originally posted by MartinY:
So you need a report with all information.
Do not use the bursting feature, distribute as a regular report.
-- If I take off the bursting option my other 5 pages won't burst. I would like to burst all the 5 pages not the 6th one.

Or does the user wants multiple pages per PO_Name AND the whole data into one page ?
--the whole data into one page on the 6th.

In which format the final report should be : HTML, Excel, PDF ?
--PDF Format

Do they want one or multiple attached files in email ?
--Currently the Reportcaster bursting 43 PONAmes with each bursting has 6pages in PDF FORMAT.

I will try your below option on the 6th page report.

Below is giving each country on its own tab and a 6th tab with all countries

TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
    SALES
BY COUNTRY
BY CAR
ON TABLE SET COMPOUND BYTOC
ON TABLE PCHOLD FORMAT XLSX OPEN
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
    SALES
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Summary', $
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
    SALES
BY COUNTRY NOPRINT
BY CAR
ON COUNTRY PAGE-BREAK
HEADING
"Detail For <COUNTRY"
""
ON TABLE PCHOLD FORMAT PDF OPEN
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
    SALES
BY COUNTRY
BY CAR
HEADING
"Summary"
""
ON TABLE PCHOLD FORMAT PDF CLOSE
END
-RUN