Eclipse Community Forums: BIRT » How to get input from user?

Help

Home

Home » Archived » BIRT » How to get input from user?

Show: Today's Messages :: Show Polls :: Message Navigator

How to get input from user? [message #728157]

Thu, 22 September 2011 16:17

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

Report message to a moderator