DEFINE FILE CAR
COUNTRY_LINK/A200 = '<a href="http://www.google.ca/#hl=en&|output=search&|q=' || COUNTRY | '" target=win_google>' | COUNTRY | '</>';
END

TABLE FILE CAR
SUM
SALES
BY COUNTRY_LINK AS COUNTRY
END

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

 HYPERLINK/A50=''|| &yourvarible || '' 

 '<a href="http://www.registrar.com" target="_blank">' || 'Please contact the Office of the ' || &department || ' for assistance.' ELSE IF &department=...</a>' 

TABLE FILE GGSALES
ON TABLE SET PAGE-NUM OFF
SUM UNITS AND DOLLARS
BY CATEGORY BY REGION
HEADING
"Regional Sales Report"
"Click here to access the IB homepage."
" "
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, $ 
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1,
   URL=http://www.ibi.com, $
ENDSTYLE
END

DEFINE FILE CAR
hyperlink/A150='<a href="http://resdetermination.uncc.edu" target="_blank">Residency Determination Office</a>';
END

TABLE FILE CAR
SUM 
SALES
hyperlink
BY COUNTRY
END

[code]

[/code]

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

DEFINE FILE CAR
hyperlink/A150='<a href="http://resdetermination.uncc.edu" target="_blank">Residency Determination Office</a>';
paragraph/A1000=
  'This is my paragraph. There is a country that requires a visit to the' ||
  (' ' | hyperlink || ', from where you may apply for a visa.');
END

TABLE FILE CAR
SUM
SALES
paragraph
BY COUNTRY
END

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

DEFINE
PARAGRAPH3/A1000 = IF F8 EQ 'RE_SD2' THEN 'Your residency for tuition purposes is ' | RES_STAT || '. If you feel this incorrect, you must fill out a residency application and submit it to the ' ' | hyperlink || '.'
ELSE ' ';
END

DEFINE FILE STEP2
hyperlink/A150='<a href="http://resdetermination.uncc.edu" target="_blank">Residency Determination Office</a>';
PARAGRAPH3/A1000 =  IF F8 EQ 'RE_SD' THEN 'Your residency for tuition purposes is ' | RES_STAT || '. If you feel this incorrect, you must fill out a residency application and submit it to the'  || ' ' | hyperlink ||' . '
ELSE '';
END
TABLE FILE STEP2
PRINT
NAME
ID
PARAGRAPH3
END

DEFINE FILE CAR
hyperlink/A150='<a href="http://resdetermination.uncc.edu" target="_blank">Residency Determination Office</a>';
PARAGRAPH3/A1000 =  IF COUNTRY EQ 'ENGLAND' THEN 'Your residency for tuition purposes is ' | 'Out-Of-State' ||
                    '. If you feel this incorrect, you must fill out a residency application and submit it to the'  ||
                    ' ' | hyperlink ||'.' ELSE 'Ok';
END
TABLE FILE CAR
PRINT
COUNTRY
PARAGRAPH3
ON TABLE HOLD FORMAT HTML
END
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM HOLD
-RUN

GamP

---

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
END