PDA

View Full Version : can i know wht's wrong with tis query?????? from report designer



shivareddyk
10-05-2011, 05:02 AM
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

Taqua
10-05-2011, 05:41 AM
Curly braces:

${adj_cost}

shivareddyk
10-05-2011, 06:23 AM
thx guru...i forgot tht braces...