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.


Page 1 2 

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] DM
 Login/Join
 
Expert
posted Hide Post
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, 2005Report This Post
Platinum Member
posted Hide Post
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, 2006Report This Post
Platinum Member
posted Hide Post
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, 2007Report This Post
  Powered by Social Strata Page 1 2  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders