Can i filter data based on the input values in the straight table?

[jagannalla]

Hi,

I have a straight table with one table fields. In this tableI have ID field with values 1,2,3,....100. Now, i'm taking input box to enter user value like 1,10,20 etc. If user select 10 in the input box i should get the last 10 records in the straight table otherwise if he select 20 i should get last 20 records. How can i do this plz help me.

[#2]

Hi,

if i understood your question, you could use "Max Number (1-100)" option in Presentation tab of straight table to do this.

Map your variable on that and sort you id column ascend to get 1st 10,20,30 value or Desc to get last 10,20,30 as per the user input.

Check my attached application.

Hope this helps you.

- Sridhar

[jagannalla]

Hi Sridhar,

Your solution is excellent, it's working. Exactly what i need in the report you given solution thanks a lot.............