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 16:17 Go to next message
Anurag  is currently offline Anurag Friend
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 16:31 Go to previous message
Anurag  is currently offline Anurag Friend
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:Global Script functions in a library
Next Topic:[SOLVED] How to configure pie chart to group series
Goto Forum:
  


Current Time: Fri May 26 22:43:49 GMT 2017

Powered by FUDForum. Page generated in 0.03750 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software