I have a report going to Excel that has a soft blue background. It's in this form --

TABLE FILE MADAP_USERS
SUM COMPUTE MEMBER/A3 = 'Yes';
BY USER_NAME AS 'User'
ACROSS GROUP_NAME_FORMATTED AS ''

In the Excel output the cell that is the intersection between the USER_NAME column and the GROUP_NAME_FORMATTED Across (i.e., above the User Names, to the left of the Group Names) comes up white instead of the soft blue. It does not seem to be addressable via style sheet commands.

It's also a very difficult topic to search on. Not the easiest thing to describe in three or four words.

Does anyone know how to get a hold of this odd corner of the reporting canvass?

J.

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

Can you reproduce with CAR please ?

Please provide the stylesheet that you are currently using so we might be able to make some suggestions.

Here's the whole doggone thing.

  
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

John,

Easy boy, the weekend is just around the corner and we'll get you there so no stress over the weekend

The subtleness of a solution is the key. Change the ACROSS title to ' ' from '' and add SET ACROSSTITLE = SIDE and you should be good to break out the GnT!

T

And then I address the location with the ACROSSTITLE item? It doesn't produce the result I'm coding. TITLE doesn't appear to work either.

No, only the two items I mentioned, no stylesheet change.

-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

T

It results in this -

Looks good, but it's not working in 7.7.03. I may be stuck with a chunk of white in my report.

Thank you for all the help!

You're welcome John, shame it doesn't work on your release - unfortunately I don't have a VM with that release on to see if there's an alternative for you.

Have a great weekend.

T