Reload based on selection

[#1]

Hi *,

I'm trying to reload data from a certain table (Sales_RTY) based on the selection I made in the application.
e.g. I select years 2009 and 2008, only this years should be reloaded. Has anyone some hints for my what's the best practice to handle this?

Sales_RTY looks like this:

Sales_RTY:
Sales_id, Sales_amt, Sales_Date, Sales_cst,....

Thanks in advance

elzo

[ipauldur]

Hi elzo,

You can create variable and assign the selected field value into that variable.

Then, you can use that variable to define the "where" condition of load statement.

Hope this will help,

Regards,

Durai.

[#3]

Hi Durai,

thanks for your help, unfortunatly I didn't get it running?

how can I assign multiple selections (eg. years: 2007,2008,2009) to a variable?

I used FROM Sales WHERE year(Sales.DATE) Like '$(v_reload_years)' in script. This is working as long as I assignt a value manually to my variable

e.g. Set v_reload_years = '2008';

Tried it with creating a variable via document settings and variable value = year (field) . unfortunately this didn't work.

I got the values to my variable with: =GetFieldSelections(Year). Unfortunaltey this isn't working for reload. Any idea?

Thanks

[bismart]

1. Make required selections in application

2. File... Reduce Data... Keep Possible Values

Application will reload only data that meets your selections.