building dataset based on another dataset

gib65

<p>Hello,</p><p> </p><p>I have a dataset. I now want to build another dataset based on the first dataset (as if the first dataset was a data source). Is this possible? Can it be done in scripting? If so, what would the script look like?</p><p> </p><p>If this is not possible, maybe I can do this in a single dataset with a more complex query. The query I currently have for the first dataset is as follows:</p><p> </p><p>{call MyStoredProcedure(?,?)} <-- where the first ? is an input parameter and the second ? is an output parameter (SYS_REFCURSOR in the stored procedure).</p><p> </p><p>What would a simple select statement look like if it drew from the results of this stored procedure call?</p><p> </p><p>Thanks for all forthcoming help.</p>

mwilliams

<p>You can build another dataset based on another.  You simply would need to store the values from the first dataset into arrays or whatever you choose and then use these arrays to create a scripted dataset.  You can either use the data engine API to access the dataset from the beforeFactory or you could hide a text box bound to your original dataset at the top of your report and just access the data in the onFetch of the dataset.</p><p> </p><p>Hope this helps.  Let me know if you need a better explanation.</p>