can i know wht's wrong with tis query?????? from report designer
"set rowcount 10
select Date,round(sum(roi),2) as ROI,round((sum(cost) * $(adj_cost)),2) as Cost
from KeyPth a,SummaryPth b,CustomerPth c,DatePth d
where a.KEY1=b.KEY1 and a.KEY1=c.KEY1 and a.DateKey=d.DateKey
Group By Date
order by ROI;"

i created adj_cost as parameter and given default value as 1.0 (double).

thx