[CLOSED] PDF Coordinate report based on second sort order
Hi Everyone,
We all know that by default if we enable MERGE=ON in compound layout report will be break down by first common sort order(COUNTRY) from both report request.But what i need is reports should break down by second sort order(BODYTYPE) instead of first sort order.
**Here is sample code**
***report1.fex****
-DEFAULTH &WF_SUMMARY='Summary'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; TABLE FILE ibisamp/car SUM CAR.BODY.SALES BY CAR.ORIGIN.COUNTRY BY CAR.BODY.BODYTYPE BY CAR.COMP.CAR ON TABLE PCHOLD FORMAT PDF ON TABLE NOTOTAL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE ON ON TABLE SET CACHELINES 100 ON TABLE SET GRWIDTH 1 ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $ ENDSTYLE END
-RUN
***report2.fex*** -DEFAULTH &WF_SUMMARY='Summary'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; TABLE FILE ibisamp/car SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST BY CAR.ORIGIN.COUNTRY BY CAR.BODY.BODYTYPE BY CAR.COMP.CAR ON TABLE PCHOLD FORMAT PDF ON TABLE NOTOTAL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE ON ON TABLE SET CACHELINES 100 ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $ ENDSTYLE END -RUN