Interesting little issue here and I'm not sure why it's happening (or what I've done to make it happen).

I have a small report and I need to set one of my columns up so that it is a drilldown.
Onto the code:

TABLE FILE FINAL 
PRINT 
PROJECT_TITLE AS 'Project,' 
CONTRACT_PERCENT AS 'Percent,'
CONTRACT_SPLIT AS 'Amount,'
BY PR_NUMBER NOPRINT
BY PROJECT_TITLE NOPRINT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
type=report, font='arial', $
type=report, grid=off, $ -* suppress HTML table styling
type=heading, line=1, size=9, $
type=heading, line=2, size=9, $
type=heading, line=3, size=13, justify=center, style=+bold, $
type=heading, line=4, size=12, justify=center, style=+bold, $
type=heading, line=5, size=11, justify=center, $
type=title, style=+bold, size=12, color=black, $ -* can't hide underline here
-*type=data, column=PROJECT_TITLE, FOCEXEC=SSS (COUNTRY=COUNTRY), $
TYPE=DATA, COLUMN=PROJECT_TITLE, FOCEXEC=SSS (COUNTRY=COUNTRY), $
END
ON TABLE HOLD FORMAT HTMTABLE AS PASSTBL
-RUN
-EXIT

As you can see, I want the drilldown on PROJECT_TITLE. The odd thing is that the link won't show for that column. If I change the syntax in the stylesheet to contract_percent or contract_split, the drilldown link shows (I realize I'm trying to call the sss report). But if I switch it back, it's gone.

So, any ideas?
Oh, and this is an HTML report.

This message has been edited. Last edited by: BDAVIS,

You have 2 PROJECT_TITLE fields. It is probably putting the drill on the first one. You might want to try saying

ON TABLE SET HOLDLIST PRINTONLY

as a start. Or trying using column notation. I think it would be N3. You can always turn the column red till you have the right one.

Wow, can't believe I didn't think of that. It was putting it on the BY column. Column=N3 nailed it.

Thanks for your help. The weekend could not get here soon enough =).

I agree. 20 more minutes. I'm glad that your program is fixed.