Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to get input from user?
How to get input from user? [message #728157] Thu, 22 September 2011 12:17 Go to next message
Anurag  is currently offline Anurag
Messages: 47
Registered: September 2011
Member
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?

Thank you,

Anurag
Re: How to get input from user? [message #728166 is a reply to message #728157] Thu, 22 September 2011 12:31 Go to previous message
Anurag  is currently offline Anurag
Messages: 47
Registered: September 2011
Member
I am able to do it now. I just have to create a report parameter only.

Thank you,

Anurag
Previous Topic:[SOLVED] How to configure Dataset using DE API
Next Topic:Get Dataset value to fill Y-serie
Goto Forum:
  


Current Time: Sat Aug 23 15:24:39 EDT 2014

Powered by FUDForum. Page generated in 0.01497 seconds