Hello, I am using WF version 7.7.03, on a Oracle platform. I have a report that defaults to an HTMl report with enduser options to select either an excel of pdf version.
The problem that I having currently is that now I have created another report that can be accessed via a hyperlink on a field called risk type. There are at least 5 types (HIGHEST, MODERATE, LOW, N/A (OTHER), OR BLANK. What I'd like to do is have a report where the enduser can select for example the active hyperlink for a record that contains "HIGHEST" and it executes a report in another window only showing the records that contain "HIGHEST" within the field.
Here is the some code from report 1 that produces output options for endusers.
APSTITLE AS 'TITLE' OFFICER_NAME AS 'OFFICER,NAME' AWARDDT AS 'AWARD,DATE' AWARD_VALUE AS 'AWARD VALUE' YTDEXPENDITURE AS 'YTD,EXPENDITURE' TOTEXPENDITURE AS 'TOTAL,EXPENDITURE' FINALEXPDTE AS 'FINAL EXP,DATE' OVERSIGHT_MANAGER AS 'OVERSIGHT,MANAGER' VENDOR_NAME AS 'VENDOR NAME' STATUS STATUSPARM AS 'AWARD,STATUS' NFE_BUSINESSUNIT AS 'NFE,BUSINESS UNIT' MWOB WO MO VO SDB SDVOSB SAAO APAO BAO NAO HAO OTHER RISK_LEVEL AS 'RISK LEVEL' NAICSDESC AS 'NAIC, DESCR' TASK_ORDER_COUNT AS 'TASK,ORDER,COUNT' CATDESC AS 'CATAGORY,DESCR' -* T_CATEGORY AS 'CATAGORY,DESCR' -*BY POID BY MOD_POID AS 'POID' -*&WHERESTATUS -*IF &STATUS EQ 'Active' GOTO MONTHACTIVE1; -*IF &PERIOD EQ 'All' GOTO ALLCURMONTH; -*-MONTHACTIVE1 WHERE AWARDDT LE &LST_MONTH AND STATUSPARM EQ 'Active' WHERE STATUSPARM EQ 'Active' -*WHERE STATUSPARM EQ 'Active' -*WHERE AWARDDT GE '20140101'; WHERE DIVISION EQ 'DRR' -*WHERE T_CATEGORY NOT LIKE '*BOA' -*WHERE EDIT(CATEGDRC,'9999') NOT LIKE '%BOA' -*IF RECORDLIMIT EQ 3000 -*-RUN -*IF &PERIOD EQ 'All' GOTO ALLCURMONTH; -*-ALLCURMONTH -*WHERE FINALEXPDTE GE &BEG_MONTH AND DIVISION EQ 'DRR' -*-RUN HEADING " Contract Risk Rating" " Total Active Contracts - " " ON TABLE SUBHEAD " "
FOOTING BOTTOM " " "Prepared by: Sg" " "RUN DATE: &DATE &TOD" -IF &OUTPUT NE 'HTML' GOTO SKIPLINES ; ON TABLE SET LINES 999999 -SKIPLINES ON TABLE COLUMN-TOTAL AS 'TOTAL' YTDEXPENDITURE TOTEXPENDITURE
ON TABLE SET PAGE-NUM TOP -*ON TABLE SET HTMLCSS ON ON TABLE PCHOLD FORMAT &OUTPUT -IF &OUTPUT EQ 'PDF' GOTO PDFSTYLE ; ON TABLE SET STYLE * UNITS=IN, LEFTMARGIN=0.0, TOPMARGIN=.0125, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, COLUMN=APSTITLE, WRAP=4, $
MOD_POID AS 'POID' APSTITLE AS 'TITLE' OFFICER_NAME AS 'OFFICER,NAME' AWARDDT AS 'AWARD,DATE' AWARD_VALUE AS 'AWARD VALUE' YTDEXPENDITURE AS 'YTD,EXPENDITURE' TOTEXPENDITURE AS 'TOTAL,EXPENDITURE' FINALEXPDTE AS 'FINAL EXP,DATE' OVERSIGHT_MANAGER AS 'OVERSIGHT,MANAGER' VENDOR_NAME AS 'VENDOR NAME' STATUS STATUSPARM AS 'AWARD,STATUS' NFE_BUSINESSUNIT AS 'NFE,BUSINESS UNIT' MWOB WO MO VO SDB SDVOSB SAAO APAO BAO NAO HAO OTHER -* RISKLEVEL2 AS 'RISK LEVEL' -* RISK_LEVEL AS 'RISK LEVEL' NAICSDESC AS 'NAIC, DESCR' TASK_ORDER_COUNT AS 'TASK,ORDER,COUNT' CATDESC AS 'CATAGORY,DESCR' -* T_CATEGORY AS 'CATAGORY,DESCR' -*BY POID -*BY MOD_POID AS 'POID' BY RISKLEVEL2 AS 'RISK LEVEL'
WHERE AWARDDT LE &LST_MONTH AND STATUSPARM EQ 'Active'
WHERE DIVISION EQ 'DRR' WHERE RISKLEVEL2 EQ '&RLEVEL';
-*WHERE T_CATEGORY NOT LIKE '*BOA' -*WHERE EDIT(CATEGDRC,'9999') NOT LIKE '%BOA' -*IF RECORDLIMIT EQ 3000 -*-RUN -*IF &PERIOD EQ 'All' GOTO ALLCURMONTH; -*-ALLCURMONTH -*WHERE FINALEXPDTE GE &BEG_MONTH AND DIVISION EQ 'DRR' -*-RUN HEADING " Contract Risk Rating" " Total Active Contracts - " " ON TABLE SUBHEAD " "
FOOTING BOTTOM " " "Prepared by: Sg" "" "Program : Risk Level testing" "RUN DATE: &DATE &TOD" -IF &OUTPUT NE 'HTML' GOTO SKIPLINES ; ON TABLE SET LINES 999999 -SKIPLINES ON TABLE COLUMN-TOTAL AS 'TOTAL' YTDEXPENDITURE TOTEXPENDITURE
ON TABLE SET PAGE-NUM TOP -*ON TABLE SET HTMLCSS ON ON TABLE PCHOLD FORMAT &OUTPUT -IF &OUTPUT EQ 'PDF' GOTO PDFSTYLE ; ON TABLE SET STYLE * UNITS=IN, LEFTMARGIN=0.0, TOPMARGIN=.0125, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=REPORT, COLUMN=APSTITLE, WRAP=4, $
After the first report is generated and I select for example a record that contains the hyperlinked word "HIGHEST" OR "MODERATE" I receive the following error message: Your request did not return any output to display. Possible causes: - No data rows matched the specified selection criteria. - Output was directed to a destination such as a file or printer. - An error occurred during the parsing or running of the request.
(FOC1517) UNRECOGNIZED COMMAND ELSE IF = RISKLEVEL2 EQ 'MODERATE' THEN RISKLEVEL2 EQ 'MODERATE' (FOC1517) UNRECOGNIZED COMMAND ELSE IF = RISKLEVEL2 EQ 'LOW' THEN RISKLEVEL2 EQ 'LOW' (FOC1517) UNRECOGNIZED COMMAND ELSE IF = RISKLEVEL2 EQ 'N/A (ONLY GOODS)' RISKLEVEL2 EQ 'N/A (ONLY GOODS)' (FOC1517) UNRECOGNIZED COMMAND ELSE IF = RISKLEVEL2 EQ '' THEN ''; 0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0This message has been edited. Last edited by: <Kathryn Henning>,
7.7.03
OS/Oracle
Windows Output:All
July 31, 2014, 12:16 PM
hainguyen
This is a syntax error. There is no '=' between ELSE IF and RISKLEVEL2.
WebFOCUS 7.7.03 Windows, All Outputs
July 31, 2014, 02:10 PM
JRS
Glad to have a second set of eyes to examine my madness. I removed the '=' and now I receive the following error:
(FOC1517) UNRECOGNIZED COMMAND ELSE IF RISKLEVEL2 EQ 'MODERATE' THEN RISKLEVEL2 EQ 'MODERATE' (FOC1517) UNRECOGNIZED COMMAND ELSE IF RISKLEVEL2 EQ 'LOW' THEN RISKLEVEL2 EQ 'LOW' (FOC1517) UNRECOGNIZED COMMAND ELSE IF RISKLEVEL2 EQ 'N/A (ONLY GOODS)' RISKLEVEL2 EQ 'N/A (ONLY GOODS)' (FOC1517) UNRECOGNIZED COMMAND ELSE IF RISKLEVEL2 EQ '' THEN '' ELSE ''; 0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
You can tell I'm a novice with IF -Then -Else conditional statements. I appreciate your help!
7.7.03
OS/Oracle
Windows Output:All
July 31, 2014, 03:03 PM
Tom Flynn
Dialogue Manager "requires" a dash - to start every line... Also, you can't have WebFOCUS columns with Dialogue Manager statements, i.e. RISKLEVEL2 And, you need to read up on Dialogue Manager IF-THEN-ELSE syntax and logic, the code will never work...
-IF &RLEVEL EQ 'HIGHEST' THEN RISKLEVEL2 EQ 'HIGHEST'
ELSE IF = RISKLEVEL2 EQ 'MODERATE' THEN RISKLEVEL2 EQ 'MODERATE'
ELSE IF = RISKLEVEL2 EQ 'LOW' THEN RISKLEVEL2 EQ 'LOW'
ELSE IF = RISKLEVEL2 EQ 'N/A (Only Goods)' RISKLEVEL2 EQ 'N/A (Only Goods)'
ELSE IF = RISKLEVEL2 EQ '' THEN '';
Thanks for your help Tom. I figured out another way to get my hyperlinks working for drill down reports. I used a few -DEFAULTH and reference my amper variables in my style sheet under TABHEADING. For example: