WF Pros,

We are new to the WF tool and are learning the tool features as we build reports. The current goal is to build a report with multiple sections and burst the report by a specific field.

Problem Statement: Only the first section of the report is displayed while the rest of the sections are not displayed when the report is burst .

IBI Suggested we use Compound Reports templates to achieve the goal.Not sure if this is right as the requirement is very rudimentary and is not complex.

Would appreciate the inputs from WF resources who are well versed in the tool and have resolved such issues.


[I]Code Built:{/I]

TABLE FILE RT1
-* BELOW DUMMY FIELD
-* ABOVE
-* BELOW DUMMY FIELD
-* ABOVE
-* BELOW DUMMY FIELD
-* ABOVE
PRINT
RT1.RT1.EXTL_FCS_DTR_ID AS 'DISTRIBUTOR'
RT1.RT1.FCS_DTR_LONG_NM AS 'NAME' OVER
RT1.RT1.MGMT_CODE AS 'MGMT CODE'
RT1.RT1.MGMT_CODE_LONG_NM AS 'MGMT NAME' OVER
RT1.RT1.LOI_NUMBER AS 'LOI NUMBER' OVER
RT1.RT1.REGISTRATION_NAME_1 AS ''
RT1.RT1.STARTING_DATE AS 'START DATE'
RT1.RT1.AGREEMENT_AMT AS 'AGREEMENT AMOUNT' OVER
RT1.RT1.REGISTRATION_NAME_2 AS ''
RT1.RT1.EXPIRATION_DATE AS 'EXPIRATION DATE'
RT1.RT1.TOTAL_PURCHASE_AMT AS 'AMOUNT INVESTED' OVER
RT1.RT1.REGISTRATION_NAME_3 AS ''
RT1.RT1.DISCOUNT_CATEGORY AS 'DISCOUNT CATEGORY'
RT1.RT1.ACCT_EVALUATION AS 'PURCHASE CREDIT' OVER
RT1.RT1.REGISTRATION_NAME_4 AS ''
RT1.RT1.SEC_ISS_ID AS 'CUSIP'
RT1.RT1.ADDITIONAL_PURCH_CREDIT_AMT AS 'ADDTL PURCHASE CRDT' OVER
RT1.RT1.REGISTRATION_NAME_5 AS ''
RT1.RT1.TICKER_SYMBOL_ID AS 'SYMBOL'
RT1.RT1.AMOUNT_INVESTED AS 'PURCHASES UNDER AGR' OVER
RT1.RT1.REGISTRATION_NAME_6 AS ''
RT1.RT1.FIRM_ACCOUNT_NBR AS 'BIN'
RT1.RT1.STREET_ACCOUNT_CREDIT_AMT AS 'STREET ACCOUNT CREDIT' OVER
RT1.RT1.REGISTRATION_NAME_7 AS ''
RT1.RT1.LOI_NUMBER
RT1.RT1.AMOUNT_DUE AS 'AMOUNT DUE' OVER
RT1.RT1.LOI_NUMBER
BY LOWEST RT1.RT1.LOI_NUMBER
ON TABLE SUBHEAD
"REPORT NUMBER: R06126<+0>LETTER OF INTENT<+0>PAGE:"SOURCE PROGRAM: N/A<+0>CLOSED UNMET AGREEMENTS<+0>SUPER SHEET DATE:"JOB: N/A<+0> <+0>CURRENT DATE:" <+0> <+0>TIME:<+0>&TOD"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$

Thanks
Raghu RK
WF Ver 8.0.0.2/Dev Studio
HW:AIX
DatabaseB2

8.0
pdf, excel, htmls

Stick with IB's suggestion. The WebFOCUS Tool is great for this. I generate over 11 thousand reports, each of which have 12 plus "sub reports". These are all bursted accordingly.

The key is to use the same primary sort for all all the components and burst on that ONE field.

BTW: These reports are generally generated and FTP'd to the server in about 25 minutes...