Hi all. I did a search to tried to find an answer for this. I have a report that returns in a Grid format. Based on whether the Benchmark column is greater than the PCT5 column to make it change to a particular color indicating whether they hit or exceeded the benchmark.. My problems is if the column in the middle (PCT6, DEN6, NUM5) are not there then it throughs this off. How can I get columns (6) to appear even if it returns no data. Someone suggested I do a print parameter that when there is no data it prints something and when there is data make a noprint parameter. Not sure how to do that either. Does anyone have suggestions or code? Here is part of my code. I only need the titles of fields6 to appear when there is and when there isn't data so that the "triggers" work.

TABLE FILE GRID
PRINT
CCARE/A40 AS 'Element'
MS10 NOPRINT
PCT1/D15S% AS 'Q1'
PCT2/D15S% AS 'Q2'
PCT3/D15S% AS 'Q3'
PCT4/D15S% AS 'Q4'
NUM5/I8S AS 'Q,N'
DEN5/I8S AS 'Q,D'
PCT5/D15S% AS 'Rate'
NUM6/I8S AS 'Current,N'
DEN6/I8S AS ',D'
PCT6/D15S% AS 'Current,Rate'
BMJCAHOTOP/D15S% AS '90th,Pctile'
BMJCAHOAVG/D15S% AS 'Avg,%'
BMGREEN/D15S% AS 'Top ,10%'
BMYELLOW/D15S AS 'Avg.'
BY
DEPARTMENT NOPRINT
BY
CONDITION AS 'Condition'
BY
ORDER NOPRINT
ON DEPARTMENT PAGE-BREAK
ON CONDITION SKIP-LINE
HEADING
"Performance Grid"
"Last Complete Quarter: 2005<+0> ................................................. <+0>(Quarter to-date thru <+0>&DATEMDYY <+0>)"
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Legal',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
DEFMACRO=PCT5YELLOW,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N12 GT N16,
$
DEFMACRO=PCT5GREEN,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N12 GE N16,
$
DEFMACRO=PCT4YELLOW,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N9 GE N17,
$
DEFMACRO=PCT4GREEN,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N9 GE N16,
$
DEFMACRO=CMS,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N5 EQ 'CMS10',
$
DEFMACRO=PCT6YELLOW,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N15 GT N16,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
RIGHTGAP=0.125000,
WHEN=N15 GE N16,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
TYPE=DATA,
SIZE=9,
BACKCOLOR=( 'WHITE' RGB(235 235 224) ),
$
TYPE=DATA,
COLUMN=N4,
GRID=ON,
$
TYPE=DATA,
COLUMN=N4,
COLOR=RGB(0 0 160),
BACKCOLOR=RGB(118 223 254),
STYLE=BOLD,
MACRO=CMS,
$
TYPE=DATA,
COLUMN=N12,
GRID=ON,
$
TYPE=DATA,
COLUMN=N12,
BACKCOLOR=RGB(55 208 132),
MACRO=PCT5GREEN,
$
TYPE=DATA,
COLUMN=N12,
BACKCOLOR=RGB(255 255 128),
MACRO=PCT5YELLOW,
$
TYPE=DATA,
COLUMN=N11,
GRID=ON,
$
TYPE=DATA,
COLUMN=N10,
GRID=ON,
$
TYPE=DATA,
COLUMN=N9,
GRID=ON,
$
TYPE=DATA,
COLUMN=N9,
BACKCOLOR=RGB(55 208 132),
MACRO=PCT4GREEN,
$
TYPE=DATA,
COLUMN=N9,
BACKCOLOR=RGB(255 255 128),
MACRO=PCT4YELLOW,
$
TYPE=DATA,
COLUMN=N8,
GRID=ON,
$
TYPE=DATA,
COLUMN=N7,
GRID=ON,
$
TYPE=DATA,
COLUMN=N6,
GRID=ON,
$
TYPE=DATA,
COLUMN=N13,
GRID=ON,
$
TYPE=DATA,
COLUMN=N14,
GRID=ON,
$
TYPE=DATA,
COLUMN=N15,
GRID=ON,
$
TYPE=DATA,
COLUMN=N16,
GRID=ON,
$
TYPE=DATA,
COLUMN=N5,
COLOR=RGB(0 0 160),
BACKCOLOR=RGB(118 223 254),
STYLE=BOLD,
MACRO=CMS,
$
TYPE=TITLE,
BACKCOLOR=RGB(244 241 234),
$
TYPE=TITLE,
COLUMN=N13,
SIZE=8,
BACKCOLOR=RGB(244 241 234),
$
TYPE=TITLE,
COLUMN=N14,
SIZE=8,
BACKCOLOR=RGB(244 241 234),
$
TYPE=TITLE,
COLUMN=N15,
SIZE=8,
BACKCOLOR=RGB(244 241 234),
$
TYPE=TITLE,
COLUMN=N16,
SIZE=8,
BACKCOLOR='LIME',
$
TYPE=TITLE,
COLUMN=N5,
COLOR=RGB(0 0 160),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N19,
BACKCOLOR=RGB(118 223 254),
$
TYPE=TITLE,
COLUMN=N18,
BACKCOLOR=RGB(118 223 254),
$
TYPE=TITLE,
COLUMN=N17,
BACKCOLOR='LIME',
$
TYPE=TABHEADING,
SIZE=12,
COLOR='BLUE',
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
COLOR='TEAL',
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
STYLE=-UNDERLINE,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
STYLE=-UNDERLINE,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
STYLE=-UNDERLINE,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
STYLE=-UNDERLINE,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
STYLE=-UNDERLINE,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=5,
SIZE=8,
STYLE=NORMAL,
$
ENDSTYLE
END

The issue is missing data and how it is evaluated by the macro.

use DEFINE logic to set a flag that can be evaluated in your WHEN,

for example

-* 1st step just to gen missing data
USE
C:\IBI\APPS\IBISAMP\COURSE.FOC AS CAR
END
DEFINE FILE COURSE
CC1/A1=EDIT(COURSECODE,'9');
END
TABLE FILE COURSE
SUM DURATION
ACROSS CLASSIF
BY CC1
ON TABLE HOLD MISSING ON
END
-RUN
-*
DEFINE FILE HOLD
XX/A2=IF E05 IS MISSING AND E04 NE MISSING THEN 'Y'
ELSE IF E04 GT E05 THEN 'Y' ELSE 'N';
END
TABLE FILE HOLD
PRINT E04
E05
E06
E07
XX NOPRINT
WHERE CC1 EQ 'U'
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=N4,COLOR=RGB(0 0 160),BACKCOLOR=RGB(118 223 254),STYLE=BOLD,WHEN= XX EQ 'Y',$
ENDSTYLE
END

Thanks JG, that is exactly the problem. The missing data. I will try this and let you know.

The problem was because I had a "conditional style" set based upon the data and when it wasn't there it would not let anything appear. Either I had to remove the conditional styling or use JG suggestion.