TABLE FILE MADAP_USERS SUM COMPUTE MEMBER/A3 = 'Yes'; BY USER_NAME AS 'User' ACROSS GROUP_NAME_FORMATTED AS ''
TABLE FILE MADAP_USERS SUM COMPUTE MEMBER/A3 = 'Yes'; BY USER_NAME AS '' ACROSS GROUP_NAME_FORMATTED AS '' WHERE GROUP_NAME LIKE 'madap%'; WHERE USER_EMAIL NOT LIKE 'inactive%'; HEADING CENTER "MADAP Database User/Role Cross-Reference" "Run Date &DATEMDYY &TIME_OF_DAY" FOOTING " Beta -- for format review only." " Results have not been validated." ON TABLE SET BYDISPLAY ON ON TABLE PCHOLD FORMAT EXL2K CLOSE ON TABLE SET PAGE-NUM OFF ON TABLE SET LINES 1000 ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='LEGAL', LEFTMARGIN=0.300000, RIGHTMARGIN=0.100000, TOPMARGIN=0.000000, BOTTOMMARGIN=0.000000, SQUEEZE=ON, ORIENTATION=LANDSCAPE, PAGECOLOR=RGB(224 238 238), $ TYPE=REPORT, FONT='ARIAL', SIZE=9, RIGHTGAP=0.125000, BACKCOLOR=RGB(224 238 238), BORDER-BOTTOM=LIGHT, TITLETEXT='User Group Membership', $ TYPE=DATA, JUSTIFY=CENTER, BACKCOLOR=(RGB(224 238 238) RGB(255 255 255)), BORDER-RIGHT=LIGHT, $ TYPE=ACROSSVALUE, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, JUSTIFY=CENTER, BACKCOLOR=RGB(255 255 150), $ TYPE=DATA, COLUMN=N1, WIDTH=2.0, WRAP=2.0, JUSTIFY=LEFT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $ TYPE=REPORT, WRAP=1.2, $ TYPE=REPORT, COLUMN=N1, WRAP=1.5, $ TYPE=TITLE, JUSTIFY=CENTER, BACKCOLOR=RGB(255 255 150), COLOR=BLACK, SIZE=12, STYLE=BOLD, $ TYPE=SUBFOOT, JUSTIFY=CENTER, BACKCOLOR=RGB(224 238 238), $ TYPE=HEADING, BORDER-TOP=OFF, BORDER-BOTTOM=OFF, BORDER-LEFT=OFF, BORDER-RIGHT=OFF, BORDER-TOP-STYLE=RIDGE, BORDER-BOTTOM-STYLE=RIDGE, BORDER-LEFT-STYLE=RIDGE, BORDER-RIGHT-STYLE=RIDGE, BORDER-TOP-COLOR=RGB(51 51 153), BORDER-BOTTOM-COLOR=RGB(51 51 153), BORDER-LEFT-COLOR=RGB(51 51 153), BORDER-RIGHT-COLOR=RGB(51 51 153), BACKCOLOR=RGB(224 238 238), SIZE=18, STYLE=BOLD, $ TYPE=FOOTING, BORDER=OFF, $ END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
-SET &TIME_OF_DAY = HHMMSS('A8'); -* Add environmental setting to place the title for ACROSS verb at the side of the ACROSS Data SET ACROSSTITLE = SIDE DEFINE FILE EMPLOYEE USER_NAME/A26 = LJUST(15,LAST_NAME,'A15')||(' '|LJUST(10,FIRST_NAME,'A10')); END TABLE FILE EMPLOYEE SUM COMPUTE MEMBER/A3 = 'Yes'; BY USER_NAME AS '' -* Change the title for the ACROSS so that is puts something in the "cell" ACROSS DEPARTMENT AS ' ' HEADING CENTER "MADAP Database User/Role Cross-Reference" "Run Date &DATEMDYY &TIME_OF_DAY" FOOTING " Beta -- for format review only." " Results have not been validated." ON TABLE SET BYDISPLAY ON ON TABLE PCHOLD FORMAT EXL2K CLOSE ON TABLE SET PAGE-NUM OFF ON TABLE SET LINES 1000 ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='LEGAL', LEFTMARGIN=0.300000, RIGHTMARGIN=0.100000, TOPMARGIN=0.000000, BOTTOMMARGIN=0.000000, SQUEEZE=ON, ORIENTATION=LANDSCAPE, PAGECOLOR=RGB(224 238 238), $ TYPE=REPORT, FONT='ARIAL', SIZE=9, RIGHTGAP=0.125000, BACKCOLOR=RGB(224 238 238), BORDER-BOTTOM=LIGHT, TITLETEXT='User Group Membership', $ TYPE=DATA, JUSTIFY=CENTER, BACKCOLOR=(RGB(224 238 238) RGB(255 255 255)), BORDER-RIGHT=LIGHT, $ TYPE=ACROSSVALUE, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, JUSTIFY=CENTER, BACKCOLOR=RGB(255 255 150), $ TYPE=DATA, COLUMN=N1, WIDTH=2.0, WRAP=2.0, JUSTIFY=LEFT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $ TYPE=REPORT, WRAP=1.2, $ TYPE=REPORT, COLUMN=N1, WRAP=1.5, $ TYPE=TITLE, JUSTIFY=CENTER, BACKCOLOR=RGB(255 255 150), COLOR=BLACK, SIZE=12, STYLE=BOLD, $ TYPE=SUBFOOT, JUSTIFY=CENTER, BACKCOLOR=RGB(224 238 238), $ TYPE=HEADING, BORDER-TOP=OFF, BORDER-BOTTOM=OFF, BORDER-LEFT=OFF, BORDER-RIGHT=OFF, BORDER-TOP-STYLE=RIDGE, BORDER-BOTTOM-STYLE=RIDGE, BORDER-LEFT-STYLE=RIDGE, BORDER-RIGHT-STYLE=RIDGE, BORDER-TOP-COLOR=RGB(51 51 153), BORDER-BOTTOM-COLOR=RGB(51 51 153), BORDER-LEFT-COLOR=RGB(51 51 153), BORDER-RIGHT-COLOR=RGB(51 51 153), BACKCOLOR=RGB(224 238 238), SIZE=18, STYLE=BOLD, $ TYPE=FOOTING, BORDER=OFF, $ END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |