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,
January 17, 2013, 03:04 PM
j.gross
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.
January 18, 2013, 03:14 AM
MrM
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
January 18, 2013, 06:24 AM
j.gross
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."