[SOLVED] HTML Document Burst

September 08, 2017, 08:42 AM

v_ani

I am bursting html document. The report caster burst all 6 pages. But the user wants to see all the bursting information on the 6thpage Example all Ponames and Poranks. Currently Reportcaster gives only one Poname and Porank on the 6th page. Is it possible can I show all the Ponames and Poranks on the last page without burst page.

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

This message has been edited. Last edited by: FP Mod Chuck,

September 08, 2017, 08:57 AM

MartinY

Not sure to understand what you are asking...

Is this the 6th report included in your HTML document (meaning that there is 5 other reports) ? The "6th page" mean : the 6th report ?

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

Based on your above code, the bursting is processed according to PO_NAME's value. So for each value of PO_NAME a new distribution is generated.

quote:

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

Are you asking to have a summary page with all data in it regardless of burst by PO_NAME ?

Maybe try to replicate with IBI sample file.

September 08, 2017, 09:20 AM

v_ani

Matiny ,Yes like a Summary Page. please see the example the user like to see.

Currently,The report caster distributing the below information to user.
________________________________________________________________

PONAME PORANKS

UFM O1

The user would like to see the below example:
____________________________________________

PONAME PORANKS
UFM 01
HENRY 02
OAKWOOD 03

September 08, 2017, 09:37 AM

MartinY

So you need a report with all information.
Do not use the bursting feature, distribute as a regular report.

Or does the user wants multiple pages per PO_Name AND the whole data into one page ?

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

Do they want one or multiple attached files in email ?

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', $
ENDSTYLE
END
-RUN

This message has been edited. Last edited by: MartinY,

September 08, 2017, 10:17 AM

v_ani

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

Thank you

September 08, 2017, 10:26 AM

MartinY

As for PDF format, you can do as follow for 1 document with 6 pages :

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