cross tab report

siva_birt

Hi,
I have 5 datasets in a maximo birt report.
I need to create a cross tab based on dataset5.
Dataset5 will get data using values form dataset4 output.
I mean, I am passing a value from dataset4 to dataset5 and then building a cube for cross tab.
What I found is the dataset5 is executed first and then other datasets are executed.
How to force the report to execute the datasets in the required order?
I searched all the forums, I could not found any nearest solution.
Can some one help me to find solution?
Thank you.

mwilliams

The simplest way might be to put 5 text boxes at the top of your report, bound to dataSets 1-5 in order. Then go to the property editor and hide all of them. The dataSets are executed in the order in which they appear in your report, so this would cause all 5 to run in order.

Hope this helps.