Hi,
I got a report that shows a icons (image) on every row, purpose is to use this as a drilldown.
But I doesn't show on the recompute line is there a way to get the image on this line?

 

DEFINE FILE CAR
IMAGE/A200= '<img src=/approot/HTML/images/ico-graph.gif border=none HEIGHT=13 WIDTH=13 <span title="Image"</span>';
END

TABLE FILE CAR
PRINT 
     IMAGE      AS ''
     DEALER_COST
     RETAIL_COST
     COMPUTE PCT/D12.1 = (CAR.CAR.DEALER_COST / CAR.CAR.RETAIL_COST) * 100; AS 'Percentage'
BY      CAR.CAR.CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE RECOMPUTE AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
 

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

Try

ON TABLE RECOMPUTE AS 'Total' DEALER_COST RETAIL_COST PCT MAX. IMAGE

Normally, alpha fields are omitted from the summary line. But you can force the issue by listing the columns to be summarized.

Thanks for your reply,

I made some adjustments like using SUM. instead of MAX. (recompute line) and i had to put SET SUMMARYLINES=NEW in the code.
Now it works perfectly. So thank for your solution.

 

SET SUMMARYLINES=NEW

DEFINE FILE CAR
IMAGE/A200= '<img src=/approot/HTML/images/ico-graph.gif border=none HEIGHT=13 WIDTH=13 <span title="Image"</span>';
END

TABLE FILE CAR
PRINT
     IMAGE      AS ''
     DEALER_COST 
     RETAIL_COST/D12
     COMPUTE PCT/D12.1 = (CAR.CAR.DEALER_COST / CAR.CAR.RETAIL_COST) * 100; AS 'Percentage'
BY      CAR.CAR.CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE RECOMPUTE SUM. IMAGE DEALER_COST RETAIL_COST PCT  AS 'Total'  
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END 

So it seems WF treats SUM. (in a RECOMPUTE/SUMMARIZE/SUBTOTAL line) analogously to the SUM verb, with respect to alpha columns, by substituting "LST."