|
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.
| Read-Only Topic
Go | Search | Notify | | Admin | New PM! |
Expert
| quote: I think the key is I have 2 different style sheets for each letter....
Just how different are they? quote: "cc: WHERE
Is that extraneous "cc: ( in your "WHERE TOTAL GIFT_TOT GE 250" ) line of code causing an problem as well?
| In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
| | Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005 |
IP
|
|
Platinum Member
| This is resolved, don't remember how though...
tbj Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12 Excel, PDF, Alpha
| | Posts: 132 | Location: Chapel Hill, NC | Registered: October 24, 2006 |
IP
|
|
Platinum Member
| I would code your report in the following manner:
-SET &ECHO=ALL;
APP FI HLDCNTRY DISK hldcntry.ftm
-RUN
-SET &CTR = 1;
DEFINE FILE CAR
GOTO_IND/A10 = IF COUNTRY EQ 'ENGLAND' THEN 'ENGLAND' ELSE
IF COUNTRY EQ 'JAPAN' THEN 'JAPAN' ELSE
IF COUNTRY EQ 'ITALY' THEN 'ITALY' ELSE 'W GERMANY';
END
TABLE FILE CAR
PRINT GOTO_IND
BY COUNTRY NOPRINT
ON TABLE SAVE AS HLDCNTRY FORMAT ALPHA
END
-RUN
-DO_READ
-SET &CMPND = IF &CTR EQ 1 THEN 'OPEN' ELSE
- IF &CTR EQ 4 THEN 'CLOSE' ELSE '';
-RUN
-READ HLDCNTRY NOCLOSE &IND.10.
TABLE FILE CAR
PRINT CAR
MODEL
BODYTYPE
SEATS
BY COUNTRY
WHERE COUNTRY EQ '&IND.EVAL'
-IF &IND EQ 'ENGLAND' GOTO ENG_LTR ELSE
- IF &IND EQ 'JAPAN' GOTO JAPAN_LTR ELSE
- IF &IND EQ 'ITALY' GOTO ITALY_LTR ELSE
- GOTO GERMAN_LTR;
-*
-ENG_LTR
-*BODY OF LETTER HERE
-GOTO WHICH_STYLE;
-JAPAN_LTR
-*BODY OF LETTER HERE
-GOTO WHICH_STYLE;
-ITALY_LTR
-*BODY OF LETTER HERE
-GOTO WHICH_STYLE;
-GERMAN_LTR
-*BODY OF LETTER HERE
-GOTO WHICH_STYLE;
-*
-WHICH_STYLE
ON TABLE PCHOLD FORMAT HTML &CMPND
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-IF &IND EQ 'ENGLAND' GOTO ENG_STYLE ELSE
- IF &IND EQ 'JAPAN' GOTO JAPAN_STYLE ELSE
- IF &IND EQ 'ITALY' GOTO ITALY_STYLE ELSE
- GOTO GERMAN_STYLE;
-ENG_STYLE
-*
-GOTO END_STYLE;
-JAPAN_STYLE
-*
-GOTO END_STYLE;
ITALY_STYLE
-*
-GERMAN_STYLE
-GOTO END_STYLE;
-END_STYLE
ENDSTYLE
END
-SET &CTR = &CTR + 1;
-IF &CTR LT &LINES GOTO DO_READ;
-EXIT
WF 7.7.05 HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files HTML, Excel, PDF
| | Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007 |
IP
|
|
| Please Wait. Your request is being processed... |
Read-Only Topic
Copyright © 1996-2020 Information Builders
|