Order of DataSet execution

Hello,

I wasn't able to find asnwer to my question on the Googlu, so I try that here. I am wondering if there is a way to set execution order of Data Sets.
In my report I need to run a Data Set with a IN condition and it's values are based on the another Data Set. So my current procedure is to run the first Data Set, fill JS array in onFetch action and in the second Data Set put the content of the array into query (in beforeOpen). But I need to make sure that the first Data Set is executed before the second one. Or is there a better way how to achieve this?

Thanks you for the answers.

Find more posts tagged with

Comments

mwilliams

DataSets are executed in the order in which elements bound to them appear in the report. So, put a hidden text box, bound to the dataSet you want to run first, at the top of your report. That should do it.

petr.mensk

Thank you, it worked

mwilliams

You're welcome! Let us know whenever you have questions!

megabri

<p>How is the order effected by masterpages? I have a masterpage set and it seems to make the dataset call first...</p>

mwilliams

The masterpage should be called before any other element. Are you having an issue related to this megabri? If so, can you explain what you're trying to do?

megabri

<p>I'm having the issue where i need a dataset called before the masterpages. I'm creating a toolbar report so I need the toolbar dataset to run first so it can pass values to the other datasets. The issue is it's not running first because i have a different dataset on my master page that's running to generate a header. Since the toolbar doesn't run first my header data set comes back blank.</p>