Display top N elements in bar chart [resolved]

[belafkih.hayat]

Hello,

I need display the top N values as bars charts, i tried to set the limit key word in sql request as :

select values from items order by values desc limit 0, $P{LIMIT_ROW}[/code]

but the parameter LIMIT_ROW is not rocognized !

Is there a way to specify the number of bars without sql request.

Thanks in advance for any Help.

H.B

[reportdev]

instead of $P{LIMIT_ROW}, use $P!{LIMIT_ROW}

 

[belafkih.hayat]

thank you  reportdev, but  

 $P!{LIMIT_ROW}[/code]

not working

i used $P{LIMIT_ROW}, it worked perfectly even if i see that the expression is not accepted in the assistant of chart, but it working when i run it in java code.

Hayat