Hi, i'm not able to use parameters in the derived table query. Want to know if it is not possible to create a parameterized query or if yes, then a way to do it.Please Help me in this regard. I have a domain which has few derived tables. Using ireport designer i could not limit the rows of the table (Using $V{REPORT_COUNT}). The reason is very simple, in theAdhocview ,i have used 'group by' and hence the $V{Report_Count} is nonsequential. for example :- 2,4,5,7. so any help in this regard would be appreciated.