can you have a scripted data source that uses another data set

jsherriff

I've got a case where I'd like to emend the data returned by a data set - particularly to add more (computed) rows to the set under certain circumstances. So two questions:

1. The only way I can think of where I can control the rows is by a scripted data source. Is there another way I'm not thinking of?

2. If a scripted data source is the only way, is there a way I can refer to another data set from a scripted data source to pull data from it or to force the other data set to be generated prior? If I can force the data set's execution to be before the scripted data set is called, I can push the data to a global variable in the data set's onfetch, and pull it back out in the scripted data set. But so far I haven't found a way to force the data set execution order.

Thanks.

johnw

The best way I have found to accomplish this is by using the Data Extraction task and referencing a Report Document after it has completed its Run cycle. so essentially you would have two reports, the original with a single data set, and the second report that uses either an ODA or a Scripted Data Source to use a Data Extraction task on the first.