I am trying to put columns from DEFINE section in subheading. Below is the code. I am sure the syntax is not correct. Can you someone please suggest me the right way to do it? Thank you!
-*COMPONENT=Define_VW_RPT_DATA
DEFINE FILE rt_test/vw_rpt_data
CURRENTDATE/A10=TODAY(CURRENTDATE);
CURRENTFY/A4=SUBSTR(10, CURRENTDATE, 7, 10, 4, CURRENTFY);
CURRENTFM/A4=SUBSTR(10, CURRENTDATE, 1, 2, 4, CURRENTFM);
CURRENTFYINT/I4=EDIT(CURRENTFY);
CURRENTFMINT/I4=EDIT(CURRENTFM);
CURRENTFYINT1/I4=IF (CURRENTFMINT GE 1) AND (CURRENTFMINT LE 6) THEN CURRENTFYINT ELSE CURRENTFYINT + 1;
FUTURE5FYINT/I4=CURRENTFYINT1 + 5;
END
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
SET ACROSSTITLE = SIDE
-SET &CURRENTYEAR = CURRENTFYINT1;
-SET &FUTUREYEAR = FUTURE5FYINT;
TABLE FILE VW_RPT_DATA
SUM
VW_RPT_DATA.VW_RPT_DATA.ACTUAL_VALUE/D20 AS 'Projects'
PCT.VW_RPT_DATA.VW_RPT_DATA.ACTUAL_VALUE/D12% AS '% of Projects'
BY LOWEST VW_RPT_DATA.VW_RPT_DATA.COMPONENT_ID NOPRINT
BY VW_RPT_DATA.VW_RPT_DATA.COMPONENT_NAME AS 'Number'
ON TABLE SUBHEAD
"FY "|| &CURRENTFYINT1 || "- FY " || &FUTURE5FYINT || " Consolidated (CTP) Projects "
"Using 10 Percent or More Funds from Other Sources "
HEADING
"As a Percentage of Projects "
WHERE ( VW_RPT_DATA.VW_RPT_DATA.MEASURE_ID EQ 2 ) AND ( VW_RPT_DATA.VW_RPT_DATA.COMPONENT_ID EQ 13 OR 14 );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'Total Projects'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/rt_SYSTEMTEST/Custom_Style_For_Reports.sty,$
ENDSTYLE
END
This message has been edited. Last edited by: <Emily McAllister>,
WebFocus 8.1 Service Pack 0.5 Build Version branch8105 Build/GEN Number 119
OS/Platform: Apache Tomcat/8.0.21
December 27, 2016, 12:23 PM
Squatch
Use less than sign ("<") instead of ampersand.
App Studio WebFOCUS 8.1.05M Windows, All Outputs
December 27, 2016, 12:25 PM
Sandeep
Thanks a TON!
WebFocus 8.1 Service Pack 0.5 Build Version branch8105 Build/GEN Number 119
OS/Platform: Apache Tomcat/8.0.21
December 27, 2016, 12:48 PM
Squatch
If you edit your first post you can change the topic from "Dynamic Values in Report SubHeading" to "[SOLVED]Dynamic Values in Report SubHeading".
This will let other forum users know that this problem has been solved.