Dataset execution through Event

crowt999

All

I have a dataset in my report that retrieves performance specific data related to a fund / benchmark. From that I am doing a simple chart that compares the returns of the fund to the benchmark.. Quite simple.

The problem I am trying to solve exists where I have > 1 benchmark for the fund. I need to change some parameters in my query, and retrieve the data again. This can be 1 or many times, so I would prefer not to have numerous hidden tables in my report just to retrieve data. This is not realistic anyway, as I might have a random number of retrieves to do.

My idea is the following: in the "initialize" or "beforeFactory" of the report, I get a handle to my dataSet, then "retrieve" it. Code in the onFetch puts the data into arrays Iv'e set up. Then, determine if there is an additional benchmark I need to retrieve for, and if so, change the parms in my query, and "retrieve" the same dataset again with new parms. (this would be adding the additional data needed to arrays)

Once this is complete, it is then quite easy to script a dataset that builds from the arrays... So the question is how can I trigger the retrieval of the dataSet through script alone ?

Does anyone out there know if this sounds feasible ??

Any/All help is greatly appreciated
Dean