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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]compound report and images

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]compound report and images
 Login/Join
 
Platinum Member
posted
I have a compound report that I have built that contains 3 elements. The main report that contains the data has page breaks in and that works fine both as a stand alone PDF and as integrated piece of the compound report it also works correctly. The second piece also a report containing only a header so that i can position works correctly as part of the compound as well in that it displays on the first page only.

My problem is with the image. The image displays on every page and interferes with the display of the data. How can I get the image to display on the first page only. Its a compound document done in composer.

Invariably someone wants to see the code so here

*-HOLD_SOURCE
-* File imperative
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.542 1.792), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='HEIGHT: 7.396in; WIDTH: 7.374in; POSITION: absolute; LEFT: 0.542in; Z-INDEX: 1; TOP: 1.792in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.521 0.521), DIMENSION=(4.062 1.146), ARREPORTSIZE=DIMENSION, METADATA='HEIGHT: 1.146in; WIDTH: 4.062in; POSITION: absolute; LEFT: 0.521in; Z-INDEX: 2; TOP: 0.521in', $
OBJECT=IMAGE, NAME='image1', IMAGE=abbrevhs2.gif, ALT='', POSITION=(4.686 0.669), DIMENSION=(2.458 0.885), METADATA='HEIGHT: 0.885in; WIDTH: 2.458in; POSITION: absolute; LEFT: 4.686in; Z-INDEX: 3; TOP: 0.669in rtFileName=/WFC/Repository/University_Advancement/~gpfish/abbrevhs2.gif', $
END
SET COMPONENT='report1'
-*component_type report
SET ASNAMES = ON
TABLE FILE AZRGA07
-*BY LOWEST AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC NOPRINT
PRINT
AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC
WHERE ( AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC EQ '&CY.(FIND AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC IN AZRGA07).CY:.' );
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD_CY FORMAT ALPHA
END
-RUN
-READ HOLD_CY &XCY.A80.
SET ASNAMES = ON
SET SQUEEZE = ON
SET PRINTPLUS = ON
SET DROPBLNKLINE = ON
TABLE FILE AZRGA07
PRINT
AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC
WHERE ( AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC EQ '&PY.(FIND AZRGA07.AZRGA07.AZRGA07_DATA_SET_DESC IN AZRGA07).PY:.' );
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS HOLD_PY FORMAT ALPHA
END
-RUN
-READ HOLD_PY &XPY.A80.
-SET &XCY = &CY;
-SET &XPY = &PY;
ENGINE SQLORA SET DEFAULT_CONNECTION BANPRD
SQL SQLORA PREPARE SQLOUT FOR
SELECT nvl((select stvcoll_desc from stvcoll where stvcoll_code = School),'Undefined') school, RPT_SEQ, ROW_NAME, SUM(CFY_TTL), SUM(PFY_TTL),
round(((SUM(CFY_TTL) - SUM(PFY_TTL))/DECODE(SUM(PFY_TTL),0,1,SUM(PFY_TTL)))*100,2)||'%' PERCENT_CHANGE FROM (
SELECT
adbdesg_coll_code School,
1 rpt_seq, 'Gifts' row_name, sum(aprtcfa_amt) cfy_ttl, 0 pfy_ttl
FROM "AZRGA07", ADBDESG WHERE "AZRGA07".APRTCFA_DESG = ADBDESG.ADBDESG_DESG AND
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND
( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
( "AZRGA07"."CFAE1_DESC" in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') ) AND
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where ATVGIFT_GIFT_GROUP_DESC in ('BEQ PROP','BEQUEST','CONT/GRANT') or NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0) ) and
nvl(APRTCFA_PLEDGE_NO,'0000000') = '0000000' and not exists (select 1 from azrga05 where AZRGA05_DATA_SET_DESC = '&XCY.EVAL' and awvmemo_gift_no=APRTCFA_GIFT_NO and
nvl(AWVMEMO_3PP_PLEDGE_NO,'0000000') <> '0000000')
and nvl(aprtcfa_pidm,-2) <> 577167 GROUP BY ADBDESG_COLL_CODE
union
SELECT adbdesg_coll_code School,
2, 'Pledge Payments' row_name, sum(aprtcfa_amt) cfy_ttl, 0 pfy_ttl
FROM "AZRGA07", ADBDESG WHERE ADBDESG_DESG = APRTCFA_DESG AND
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND
( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
( "AZRGA07"."CFAE1_DESC" in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') ) AND
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( "AZRGA07"."APRTCFA_GIFT_CODE" not in (select ATVGIFT_CODE from atvgift where ATVGIFT_GIFT_GROUP_DESC in ('BEQ PROP','BEQUEST','CONT/GRANT') or NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0) )
and ((nvl(APRTCFA_PLEDGE_NO,'0000000') <> '0000000') or (exists (select 1 from azrga05 where AZRGA05_DATA_SET_DESC = '&XCY.EVAL' and awvmemo_gift_no=APRTCFA_GIFT_NO and
nvl(AWVMEMO_3PP_PLEDGE_NO,'0000000') <> '0000000')))
and nvl(aprtcfa_pidm,-2) <> 577167 GROUP BY ADBDESG_COLL_CODE
union
SELECT adbdesg_coll_code School,
3, 'Realized Bequests' row_name, sum(aprtcfa_amt) cfy_ttl, 0 pfy_ttl
FROM "AZRGA07", ADBDESG WHERE adbdesg_desg = APRTCFA_DESG AND
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
( CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') ) AND
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( "AZRGA07"."APRTCFA_GIFT_CODE" in (select ATVGIFT_CODE from atvgift where ATVGIFT_GIFT_GROUP_DESC in ('BEQ PROP','BEQUEST')))
GROUP BY ADBDESG_COLL_CODE
union
SELECT adbdesg_coll_code School,
4, 'Total Received' row_name, sum(aprtcfa_amt) cfy_ttl, 0 pfy_ttl
FROM "AZRGA07", ADBDESG WHERE (adbdesg_desg = APRTCFA_DESG )
AND ( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
GROUP BY ADBDESG_COLL_CODE
union
select adbdesg_coll_code School,
5 , 'Balance of New FY Pledges' row_name, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)), 0
from azrga03, ADBDESG WHERE AGRPDES_DESG= ADBDESG_DESG AND AZRGA03_DATA_SET_DESC = '&XCY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO'))
AND AGBPLDG_PSTA_CODE IN ('A','P') GROUP BY ADBDESG_COLL_CODE
union
select desg,
6, 'Total Received plus Balance of New Pledges', sum(rpbonp), 0
from (
(select ADBDESG_COLL_CODE desg, sum(aprtcfa_amt) rpbonp FROM "AZRGA07", ADBDESG
WHERE APRTCFA_DESG = ADBDESG_DESG AND ( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
GROUP BY adbdesg_coll_code)
union
(select adbdesg_coll_code desg, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)) from azrga03, ADBDESG
WHERE AGRPDES_DESG = ADBDESG_DESG AND AZRGA03_DATA_SET_DESC = '&XCY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO')) AND AGBPLDG_PSTA_CODE IN ('A','P')
GROUP BY adbdesg_coll_code)
) GROUP BY DESG
union
SELECT ADBDESG_COLL_CODE, 7,'Planned Gifts - Irrevocable (Face Value)', SUM(agrpdes_amt) Present_Value, 0 FROM azrga09
WHERE ( AZRGA09_DATA_SET_DESC = '&XCY.EVAL' ) and (agbpldg_pldg_code in ('PG'))
GROUP BY ADBDESG_COLL_CODE
union
SELECT ADBDESG_COLL_CODE, 8,'Planned Gifts - Revocable (Face Value)', SUM(agrpdes_amt) Present_Value, 0 FROM azrga09
WHERE ( AZRGA09_DATA_SET_DESC = '&XCY.EVAL' ) and (agbpldg_pldg_code in ('TC'))
GROUP BY ADBDESG_COLL_CODE
union
SELECT ADBDESG_COLL_CODE, 9, 'Total Planned Gifts (Face Value)', SUM(agrpdes_amt) Present_Value, 0 FROM azrga09
WHERE (AZRGA09_DATA_SET_DESC = '&XCY.EVAL' ) and (agbpldg_pldg_code in ('TC','PG'))
GROUP BY ADBDESG_COLL_CODE
union
select DESG, 10, 'Total UA Fundraising Activity', sum(ttl), 0 from (
(select ADBDESG_COLL_CODE DESG, sum(aprtcfa_amt) ttl FROM "AZRGA07", ADBDESG
WHERE APRTCFA_DESG = ADBDESG_DESG AND ( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
GROUP BY ADBDESG_COLL_CODE)
union
(select ADBDESG_COLL_CODE, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)) from azrga03, ADBDESG WHERE (AGRPDES_DESG = ADBDESG_DESG) AND
AZRGA03_DATA_SET_DESC ='&XCY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO')) AND
AGBPLDG_PSTA_CODE IN ('A','P') GROUP BY ADBDESG_COLL_CODE)
union
(SELECT ADBDESG_COLL_CODE, SUM(agrpdes_amt) FROM azrga09 WHERE ( AZRGA09_DATA_SET_DESC = '&XCY.EVAL' ) and (agbpldg_pldg_code in ('TC','PG'))
GROUP BY ADBDESG_COLL_CODE)
) GROUP BY DESG
union
select ADBDESG_COLL_CODE, 11, 'OSP', sum(aprtcfa_amt), 0
FROM AZRGA07, ADBDESG
WHERE APRTCFA_DESG = ADBDESG_DESG AND AZRGA07_DATA_SET_DESC = '&XCY.EVAL' AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY'))
and azrga07_data_type = 'VSE2:1G' and nvl(aprtcfa_pidm,-2) <> 577167 GROUP BY ADBDESG_COLL_CODE
union
select DESG, 12, 'Total Fundraising Activity', sum(ttl), 0 from (
(select ADBDESG_COLL_CODE DESG, sum(aprtcfa_amt) ttl FROM "AZRGA07", ADBDESG WHERE APRTCFA_DESG=ADBDESG_DESG AND ( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XCY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
GROUP BY ADBDESG_COLL_CODE)
union
(select ADBDESG_COLL_CODE, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)) from azrga03, ADBDESG WHERE AGRPDES_DESG = ADBDESG_DESG AND AZRGA03_DATA_SET_DESC ='&XCY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO')) AND AGBPLDG_PSTA_CODE IN ('A','P')
GROUP BY ADBDESG_COLL_CODE)
union
(SELECT ADBDESG_COLL_CODE, SUM(agrpdes_amt) FROM azrga09 WHERE ( AZRGA09_DATA_SET_DESC = '&XCY.EVAL' ) and (agbpldg_pldg_code in ('TC','PG'))
GROUP BY ADBDESG_COLL_CODE)
union
(select ADBDESG_COLL_CODE, sum(aprtcfa_amt) FROM AZRGA07, ADBDESG WHERE APRTCFA_DESG=ADBDESG_DESG AND AZRGA07_DATA_SET_DESC = '&XCY.EVAL' AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY'))
and azrga07_data_type = 'VSE2:1G' and nvl(aprtcfa_pidm,-2) <> 577167
GROUP BY ADBDESG_COLL_CODE)
) GROUP BY DESG
UNION
SELECT ADBDESG_COLL_CODE, 1 rpt_seq, 'Gifts' row_name, 0, sum(aprtcfa_amt) pfy_ttl
FROM "AZRGA07", ADBDESG
WHERE (APRTCFA_DESG=ADBDESG_DESG) AND ( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XPY.EVAL' ) AND
( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
( "AZRGA07"."CFAE1_DESC" in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') ) AND
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where ATVGIFT_GIFT_GROUP_DESC in ('BEQ PROP','BEQUEST','CONT/GRANT') or NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0) ) and
nvl(APRTCFA_PLEDGE_NO,'0000000') = '0000000' and not exists (select 1 from azrga05 where AZRGA05_DATA_SET_DESC = '&XPY.EVAL' and awvmemo_gift_no=APRTCFA_GIFT_NO and
nvl(AWVMEMO_3PP_PLEDGE_NO,'0000000') <> '0000000')
and nvl(aprtcfa_pidm,-2) <> 577167 GROUP BY ADBDESG_COLL_CODE
union
SELECT ADBDESG_COLL_CODE, 2, 'Pledge Payments' row_name, 0, sum(aprtcfa_amt) pfy_ttl
FROM "AZRGA07", ADBDESG WHERE APRTCFA_DESG = ADBDESG_DESG AND ( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XPY.EVAL' ) AND
( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
( "AZRGA07"."CFAE1_DESC" in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') ) AND
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( "AZRGA07"."APRTCFA_GIFT_CODE" not in (select ATVGIFT_CODE from atvgift where ATVGIFT_GIFT_GROUP_DESC in ('BEQ PROP','BEQUEST','CONT/GRANT') or NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0) )
and ((nvl(APRTCFA_PLEDGE_NO,'0000000') <> '0000000') or (exists (select 1 from azrga05 where AZRGA05_DATA_SET_DESC = '&XPY.EVAL' and awvmemo_gift_no=APRTCFA_GIFT_NO and
nvl(AWVMEMO_3PP_PLEDGE_NO,'0000000') <> '0000000')))
and nvl(aprtcfa_pidm,-2) <> 577167 GROUP BY ADBDESG_COLL_CODE
union
SELECT ADBDESG_COLL_CODE, 3, 'Realized Bequests' row_name, 0, sum(aprtcfa_amt) pfy_ttl
FROM "AZRGA07", adbdesg where aprtcfa_desg = adbdesg_desg and
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XPY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
( CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') ) AND
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( "AZRGA07"."APRTCFA_GIFT_CODE" in (select ATVGIFT_CODE from atvgift where ATVGIFT_GIFT_GROUP_DESC in ('BEQ PROP','BEQUEST')))
GROUP BY ADBDESG_COLL_CODE
union
SELECT ADBDESG_COLL_CODE, 4, 'Total Received' row_name, 0, sum(aprtcfa_amt) pfy_ttl
FROM "AZRGA07", ADBDESG WHERE ADBDESG_DESG = APRTCFA_DESG AND
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XPY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
group by ADBDESG_COLL_CODE
union
select ADBDESG_COLL_CODE, 5 , 'Balance of New FY Pledges' row_name, 0, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid))
from azrga03, ADBDESG WHERE AGRPDES_DESG = ADBDESG_DESG AND AZRGA03_DATA_SET_DESC ='&XPY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO'))
AND AGBPLDG_PSTA_CODE IN ('A','P') group by adbdesg_coll_code
union
select DESG, 6, 'Total Received plus Balance of New Pledges', 0, sum(rpbonp)
from (
(select ADBDESG_COLL_CODE desg, sum(aprtcfa_amt) rpbonp FROM "AZRGA07", ADBDESG WHERE aprtcfa_desg = adbdesg_desg and
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XPY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
group by adbdesg_coll_code)
union
(select adbdesg_coll_code, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)) from azrga03, adbdesg WHERE
adbdesg_desg = agrpdes_desg and AZRGA03_DATA_SET_DESC ='&XPY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO')) AND AGBPLDG_PSTA_CODE IN ('A','P')
group by adbdesg_coll_code)
) group by desg
union
SELECT adbdesg_coll_code, 7,'Planned Gifts - Irrevocable (Face Value)', 0, SUM(agrpdes_amt) Present_Value FROM azrga09
WHERE ( AZRGA09_DATA_SET_DESC = '&XPY.EVAL' ) and (agbpldg_pldg_code in ('PG')) group by adbdesg_coll_code
union
SELECT adbdesg_coll_code, 8,'Planned Gifts - Revocable (Face Value)', 0, SUM(agrpdes_amt) Present_Value FROM azrga09
WHERE ( AZRGA09_DATA_SET_DESC = '&XPY.EVAL' ) and (agbpldg_pldg_code in ('TC')) group by adbdesg_coll_code
union
SELECT adbdesg_coll_code, 9, 'Total Planned Gifts (Face Value)', 0, SUM(agrpdes_amt) Present_Value FROM azrga09
WHERE ( AZRGA09_DATA_SET_DESC = '&XPY.EVAL' ) and (agbpldg_pldg_code in ('TC','PG')) group by adbdesg_coll_code
union
select desg, 10, 'Total UA Fundraising Activity', 0, sum(ttl) from (
(select adbdesg_coll_code desg, sum(aprtcfa_amt) ttl FROM "AZRGA07",adbdesg WHERE aprtcfa_desg = adbdesg_desg and ( "AZRGA07"."AZRGA07_DATA_SET_DESC" ='&XPY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
group by adbdesg_coll_code)
union
(select adbdesg_coll_code, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)) from azrga03,adbdesg WHERE agrpdes_desg = adbdesg_desg and AZRGA03_DATA_SET_DESC = '&XPY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO')) AND AGBPLDG_PSTA_CODE IN ('A','P')
group by adbdesg_coll_code)
union
(SELECT adbdesg_coll_code, SUM(agrpdes_amt) FROM azrga09 WHERE ( AZRGA09_DATA_SET_DESC = '&XPY.EVAL' ) and (agbpldg_pldg_code in ('TC','PG'))
group by adbdesg_coll_code)
) group by desg
union
select adbdesg_coll_code, 11, 'OSP', 0, sum(aprtcfa_amt)
FROM AZRGA07, adbdesg where aprtcfa_desg = adbdesg_desg and
AZRGA07_DATA_SET_DESC = '&XPY.EVAL' AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY'))
and azrga07_data_type = 'VSE2:1G' and nvl(aprtcfa_pidm,-2) <> 577167
group by adbdesg_coll_code
union
select desg, 12, 'Total Fundraising Activity', 0, sum(ttl) from (
(select adbdesg_coll_code desg, sum(aprtcfa_amt) ttl FROM "AZRGA07", adbdesg WHERE (aprtcfa_desg = adbdesg_desg) and
( "AZRGA07"."AZRGA07_DATA_SET_DESC" = '&XPY.EVAL' ) AND ( "AZRGA07"."AZRGA07_DATA_TYPE" = 'VSE1' ) AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY')) and
( APRTCFA_GIFT_CODE not in (select ATVGIFT_CODE from atvgift where (ATVGIFT_GIFT_GROUP_DESC = 'CONT/GRANT') or (NVL(ATVGIFT_PLANNED_GIFT_IND,0) > 0))) and nvl(aprtcfa_pidm,-2) <> 577167
group by adbdesg_coll_code)
union
(select adbdesg_coll_code, sum(greatest(0, agrpdes_amt - agrpdes_amt_paid)) from azrga03, adbdesg WHERE agrpdes_desg = adbdesg_desg and AZRGA03_DATA_SET_DESC ='&XPY.EVAL' AND
AGBPLDG_PLDG_CODE IN (SELECT ATVPLDG_CODE FROM ATVPLDG WHERE NVL(ATVPLDG_PLANNED_GIFT_IND,'0') <> '1' AND ATVPLDG_CODE NOT IN ('PO')) AND AGBPLDG_PSTA_CODE IN ('A','P')
group by adbdesg_coll_code)
union
(SELECT adbdesg_coll_code, SUM(agrpdes_amt) FROM azrga09 WHERE ( AZRGA09_DATA_SET_DESC = '&XPY.EVAL' ) and (agbpldg_pldg_code in ('TC','PG'))
group by adbdesg_coll_code)
union
(select adbdesg_coll_code, sum(aprtcfa_amt) FROM AZRGA07, adbdesg WHERE aprtcfa_desg = adbdesg_desg and AZRGA07_DATA_SET_DESC ='&XPY.EVAL' AND
CFAE1_DESC in ('1. Alumni','2. Parents','3. Other Individuals','4. Foundations','5. Corporations','6. Religious Organizations','7. Fundraising Consortia','8. Other') and
(NVL(DESG_VSE_TYPE_CODE,'CFAE') in ('01. UNREN','02. ACADN','03. FACUN','04. RESRN','05. PUBLN','06. LIBRN','07. OPERN','08. STUFN','09. ATHCR','10. OTHRY','20. PRPRT','21. ENDOW','22. ENDR','32. LOANY'))
and azrga07_data_type = 'VSE2:1G' and nvl(aprtcfa_pidm,-2) <> 577167
group by adbdesg_coll_code)
) group by desg
) GROUP BY School, RPT_SEQ, ROW_NAME order by 1, 2,3;
END
TABLE FILE SQLOUT
PRINT
RPT_SEQ NOPRINT
ROW_NAME AS 'Imperative'
SUM_CFY_TTL_ AS 'CURRENT'
SUM_PFY_TTL_ AS 'PREVIOUS'
PERCENT_CHANGE NOPRINT
COMPUTE VARIANCE/D20.2% = ( ( SUM_CFY_TTL_ - SUM_PFY_TTL_ ) / SUM_PFY_TTL_ ) * 100; NOPRINT
COMPUTE VARIANCE2/D20.2% = IF VARIANCE EQ 0 THEN 100 ELSE VARIANCE;
BY LOWEST SCHOOL AS 'School'

ON SCHOOL SUBFOOT NEWPAGE
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/PRDODSP/_EDAHOME/ETC/endeflt.sty,
$
PAGESIZE='Letter',
$
TYPE=REPORT,
BACKCOLOR='NONE',
$
TYPE=DATA,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BACKCOLOR='NONE',
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=DATA,
COLUMN=N8,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=TITLE,
COLOR='WHITE',
BACKCOLOR=RGB(0 204 255),
STYLE=-UNDERLINE+BOLD,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N1,
JUSTIFY=CENTER,
$
TYPE=SUBFOOT,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-TOP-COLOR=RGB(52 55 58),
BORDER-BOTTOM-COLOR=RGB(52 55 58),
$
TYPE=SUBFOOT,
BY=1,
BORDER-TOP=OFF,
$
ENDSTYLE
END
SET COMPONENT='report2'
-*component_type report
DEFINE FILE ATVFISC
SYDATE/YYMD=&YYMD;
END
TABLE FILE ATVFISC
PRINT
ATVFISC.ATVFISC.ATVFISC_CODE NOPRINT
ATVFISC.ATVFISC.ATVFISC_DESC NOPRINT
ON TABLE SUBHEAD
""DEPARTMENTAL ADVANCEMENT SUMMARY"
"&DATEtrMDYY "
WHERE ( SYDATE GE ATVFISC.ATVFISC.ATVFISC_START_DATE ) AND ( SYDATE LE ATVFISC.ATVFISC.ATVFISC_END_DATE );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/PRDODSP/_EDAHOME/ETC/endeflt.sty,
$
TYPE=TABHEADING,
LINE=1,
JUSTIFY=LEFT,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=2,
JUSTIFY=LEFT,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=3,
JUSTIFY=LEFT,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
STYLE=BOLD,
$
ENDSTYLE
END
COMPOUND END

This message has been edited. Last edited by: <Emily McAllister>,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Virtuoso
posted Hide Post
Try to define tow pages layout.
The first page will contain the image and the header report.
The second page will contain other reports.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Guru
posted Hide Post
My 5 cent contribution:




-**********
-* SETs
-**********
SET CDN = ON
SET NODATA = 0
SET ASNAMES = ON
SET EMPTYCELLS = OFF
SET CENT-ZERO = ON

-*************************
-* VARIABLES MANIPULATIONS
-*************************

-* CREATE VARIABLE ANOMES FORMAT YYM - ( BASED ON  GIVEN &DATA_FIM VARIABLE )
-SET &ANOMES = EDIT(&DATA_FIM, '999999');

-* CREATE VARIABLE &ANOMES_TITLE FORMAT YY-MM TO PRINT ON HEADINGS  - ( BASED ON &DATA_FIM)
-SET &ANOMES_TITLE = EDIT(&DATA_FIM, '9999-99');

-* CREATE VAR. FORMAT ALPHA WITH YYMMD
-SET &ANOMES_DIA = &ANOMES.EVAL|01;

-* CREATE VAR. FORMAT YYMD
-SET &ANOMES_OFFSET=DATECVT(&ANOMES_DIA, 'I8YYMD' , 'YYMD');

-* CREATE VAR. BASED ON &ANOMES_OFFSET FORMAT YYMD, BEGINNING OF YEAR
-SET &1_DIA_ANO=DATEMOV(&ANOMES_OFFSET.EVAL , 'BOY');
-SET &1_DIA_ANO_DT=DATECVT(&1_DIA_ANO.EVAL , 'YYMD' , 'I8YYMD');
-SET &1_MES_ANO = EDIT(&1_DIA_ANO_DT.EVAL,'999999$$');
-SET &LAST_5YEAR_YYMD= DATECVT(DATEADD(DATECVT(&ANOMES_DIA,'I8YYMD','YYMD'),'Y','-5'),'YYMD','I8YYMD');

-* YEAR MANIPULATION
-SET &YEAR = EDIT(&DATA_FIM,'9999$$$$');
-SET &LAST_5YEAR = EDIT(&LAST_5YEAR_YYMD,'9999$$$$');


-SET &1_MES_LAST_5YEAR = &LAST_5YEAR.EVAL|01;



-* START PDF COMPOUND SECTION

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF AS ADVR_0038
UNITS=PTS, $
SECTION=section1, LAYOUT=ON, METADATA='5^5^5^5^4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, SHOW_GLOBALFILTER=OFF, $

PAGELAYOUT=ALL, $
COMPONENT=HEADER, TYPE=REPORT, POSITION=(7 7), DIMENSION=(* *), $


-* THIS IS NOT WORKING ON WF 8105
-*OBJECT=STRING, NAME='Page', TEXT='Page <ibi-page-number/> of <ibi-total-pages/>', POSITION=(+545 50), MARKUP=OFF,
-* WRAP=ON, DIMENSION=(6.0 0.9) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $


-* THIS IS NOT WORKING ON WF 8105
-*OBJECT=STRING, NAME='Prog', TEXT='Prog: advr0038', POSITION=(+545 750), MARKUP=OFF,
-*        WRAP=ON, DIMENSION=(6.0 0.9) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $


PAGELAYOUT=1, NAME='advr0038', text='advr0038', TOC-LEVEL=1, TOPMARGIN=10, ORIENTATION=LANDSCAPE, $

COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(40 85), DIMENSION=(* *), $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(40 +20), DIMENSION=(* *), RELATIVE-TO='report1', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $


END

-* PDF COMPOUND HEADER GOES HERE

SET COMPONENT=HEADER

TABLE FILE DW_ADV_VENEZUELA
HEADING
"PARTICIPACION & VOLUMEN"
""
"COMPANY "
"&DATEDwMtrYY &TOD"
BY SRSD10_MANUFACTURER_N NOPRINT
IF READLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE *
$
TYPE=REPORT,
     IMAGE=company_logo.jpg,
     SIZE=(1.000000 0.291667),
$
TYPE=HEADING, FONT="FORD CE BLACK", $
TYPE=HEADING, POSITION=1.05, $
TYPE=HEADING, LINE=1, SIZE=12, STYLE='BOLD', JUSTIFY=CENTER, $
TYPE=HEADING, LINE=3, SIZE=8, JUSTIFY=LEFT, $
TYPE=HEADING, LINE=4, SIZE=6, JUSTIFY=RIGHT, $

END



SET COMPONENT='report1'

TABLE FILE HREPORT
SUM
VOL/FMT
COMPUTE FLAG_FORD/A3 = IF SRSD10_MANUFACTURER_N EQ 'FORD' THEN FLAG ELSE 'X';  NOPRINT
TOT_YEAR NOPRINT
PCT_TOT  NOPRINT
BY YEAR AS 'AÑO'
BY SRSD10_MANUFACTURER_N AS ''
ACROSS MONTH NOPRINT
ACROSS MONTH_REPORT AS ''
COMPUTE TOTAL/A15 = IF SRSD10_MANUFACTURER_N EQ 'PARTICIPACION %' THEN FTOA(PCT_TOT,'(D8.1)','A15') ELSE FTOA(TOT_YEAR,'(D8)','A15');
HEADING
"Period: &ANOMES_TITLE"
ON TABLE SUBFOOT
"Mejor Mes: &MELHOR_MES con &VALOR_MELHOR_MES"
"Mes<+0> de<+0> Records<+0> de Venta en el período"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
   INCLUDE = IBFS:/WFC/Repository/vesir218/others/endeflt.sty,
$
     DEFMACRO=MELHOR_MES,
     MACTYPE=RULE,
     WHEN=FLAG_FORD EQ 'TOP',
$

TYPE=REPORT, SIZE=7, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6, $
TYPE=ACROSSVALUE, SIZE=8, $

TYPE=DATA, ACROSSCOLUMN=N1, COLOR='BLUE', BACKCOLOR='GREY', STYLE=BOLD,  MACRO=MELHOR_MES, $

TYPE=HEADING, JUSTIFY=LEFT,  SIZE=9, $

TYPE=HEADING,  LINE=4, SIZE=8,  JUSTIFY=RIGHT, $
TYPE=TABFOOTING, JUSTIFY=LEFT, SIZE=9, $
TYPE=TABFOOTING, LINE=1, BORDER-TOP = LIGHT,  $
TYPE=TABFOOTING, LINE=2, ITEM=1, COLOR='BLUE', BACKCOLOR='GREY', STYLE=BOLD, BORDER-TOP = LIGHT,  $
TYPE=TABFOOTING, LINE=2, ITEM=2, COLOR='BLUE', BACKCOLOR='GREY', STYLE=BOLD, BORDER-TOP = LIGHT,  $
TYPE=TABFOOTING, LINE=2, ITEM=3, COLOR='BLUE', BACKCOLOR='GREY', STYLE=BOLD, BORDER-TOP = LIGHT,  $

ENDSTYLE
END

-RUN

SET COMPONENT='report2'
TABLE FILE HIND1
SUM SRSD83_RETAIL_SALES_Q AS 'TOTAL_YEAR' NOPRINT
BY YEAR
SUM SRSD83_RETAIL_SALES_Q/D8 AS 'Vol'
COMPUTE PCT/D8.1 = (SRSD83_RETAIL_SALES_Q/C1)*100; AS '%'
BY YEAR AS 'AÑO'
ACROSS QUARTER AS ''
COMPUTE TOTAL/D8 = C1;
ON TABLE SUBFOOT
"Powered by VESIR"
"Prog: ADVR0038"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
   INCLUDE = IBFS:/WFC/Repository/vesir218/others/endeflt.sty,
$
TYPE=REPORT, SIZE=8, $
TYPE=TITLE, SIZE= 8, $
TYPE=DATA, SIZE=8, $
TYPE=ACROSSVALUE, SIZE=8, $
TYPE=HEADING, JUSTIFY=LEFT,  SIZE=9, $

TYPE=HEADING,  LINE=4, SIZE=8,  JUSTIFY=RIGHT, $
TYPE=TABFOOTING, LINE=1, SIZE=8, BORDER-TOP = LIGHT,  $
TYPE=TABFOOTING, LINE=2, SIZE=5, BORDER-TOP = LIGHT,  $
ENDSTYLE
END
-EXIT


  


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Did you figure this out?


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 74 | Registered: December 23, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]compound report and images

Copyright © 1996-2020 Information Builders