Were trying to use the reporting agent to pre-calculate HTML and data for our queries to improve performance for the users.
The control-part of the web-template consists of four drop-down boxes; year, month, area & ownership. See image at this URL: http://www.kitesurfing.no/web-template.jpg
Currently the boxes for year and month are filled by hard-coded values from a JavaScript. The other two are filled by dataproviders connected to views.
Ive created a control-query that I use as a parameter to generate the HTML via reporting-agent. The drop-downs for area and ownership are filled successfully, but I need to generate drop-downs also for month and year so the user can navigate also within these drop-downs and still access pre-calculated HTML.
So I wanted to replace the current hard-coded drop-downs with new drop-downs also filled via the control-query when pre-calculated, and via a query when normally ran.
The problem is when doing this it seems the drop-downs are in some way connected. I first have to select a value in the box for area, then for ownership, then the year and lastly the month. The month-box doesnt get filled (its empty) until a year is selected, and the year-box is empty until we select an area.
I need to be able to operate these boxes independently of each other, so they should all be filled all the time independently of what the other boxes display.
Suggestions highly appreciated as were running short on time on this.
tom