In my report user will enter top n (say top 10 or top 30 or top 50) product buyers. I am following 'Enabling the User to Filter Data' tutorial. My query is as follows:
SELECT NAME AS NAME, SUM(potential_of_customer_in_qty) AS Potential FROM cl_customer_potentials GROUP BY NAME order by Potential desc limit 0,10
Here I have 10 (limit 0,10) in query. user will decide he wants to see top 10 or 20 or 30 results. How to get that limit value from user?