On 7/7/2010 6:38 AM, spriteburn wrote:

Good Morning Everyone,

I would like to know if it is possible to pass parameters between data
sets in order to calculate output values.

For example, if I have a data set that takes WI_ID as input and gives
me a TIMESTAMP_KEY as output, can I create a computed column in
another data set that passes a WI_ID to recover the value of the
TIMESTAMP_KEY?

Thank you in advance!

Best regards,

Andrew

Here's how we typically do it.

1. Create data sets A and B, where A produces a value that B wants to
use as an input.
2. In the onFetch for A, store the value into a javascript variable
3. In the parameters for B, use the javascript variable as input to the
data set.
4. Create two hidden labels at the top of the report, the first one
bound to A and the second bound to B. This is important because it
establishes ordering between the two.

Hope this helps.

james
RTC Reports Team Lead