Skip to Content
0
Former Member
Oct 07, 2005 at 08:20 AM

drop-downs for filtering in precalculated HTML

19 Views

We’re 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.

I’ve 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 doesn’t get filled (it’s 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 we’re running short on time on this.

tom