Dynamic top10 report using domain

[wolfram]

Hi,

I'm currently doing a dynamic top10 report, the filter of the report is a date range. I can easily do this using SQL statement but I need to do this using the domain. Can someone help me on how to create a dynamic top 10 report using domain?

By the way, the report is a dynamic top 10 total sales per category, I need to acquire a select statement something like this (SELECT category, sum(sales) from tbl_sales WHERE sdate between $P{date1} and $P{date2}) using domain.

Thanks in advanced,

Mel

Post Edited by melandro at 09/14/2012 13:24

[raja.shekar]

@melandro.. I too have to find the top 10records using domain dataset..Did you Got it. If yes Please post How?