How to filter a table box by sliders/input box?

[Anonymous]

Hi,

I have a list of customers in a table box with their several attributes e.g. [ store, custid, fname, lname, age, #transactions, Daysfromlastpayment, daysfromfirsttransaction, balance etc ]. I need to provide input boxes so that user can select level of several attributes. e.g. "age >" input box will filter the table for value input in the "age >" input box i.e. if 40 is typed in input box the table box will show all the customers greater than 40 and likewise I need few more input boxes for other attributes.  Once all the attributes are set user can export the list filtered by the set attributes and export it in excel for further use.

I have been able to create a straight table where aggregation on these attributes are calculated for selected levels using set analysis and variables e.g. sum({<age = {'>$(vAge')} totalbalance>}) where vAge variable is set using input box. but that does not affect the selected data set i.e. I am not able to reduce the list according to the levels set using input boxes.

Please let me know if you have any solutions, suggestions or ideas.

[jpapador]

Have the input box edit your vAge variable.  The next step is to go into document properties and triggers tab.  On the variable event triggers find vAge and add a trigger for on change.

The action should be "Select in Field", put in your age field for the field and for your search string enter the following:

= '>' & vAge

Hit finish, now when you change your input box it will trigger the selection