Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] HTML Document Burst

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] HTML Document Burst
 Login/Join
 
Gold member
posted
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,


WebFOCUS 8
Windows, All Outputs
 
Posts: 73 | Registered: April 06, 2016Report This Post
Virtuoso
posted Hide Post
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.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Gold member
posted Hide Post
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


WebFOCUS 8
Windows, All Outputs
 
Posts: 73 | Registered: April 06, 2016Report This Post
Virtuoso
posted Hide Post
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,


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Gold member
posted Hide Post
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


WebFOCUS 8
Windows, All Outputs
 
Posts: 73 | Registered: April 06, 2016Report This Post
Virtuoso
posted Hide Post
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


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] HTML Document Burst

Copyright © 1996-2020 Information Builders