Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Page 1 2 
Go
New
Search
Notify
Tools
Reply
  
[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.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 2987 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport 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: 126 | Location: Chapel Hill, NC | Registered: October 24, 2006Reply With QuoteReport 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, 2007Reply With QuoteReport This Post
  Powered by Social Strata Page 1 2  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.