use Data Transformation in Master-Details scenario

[CWS116]

Hello,

Is there any way to use a Data Transformation in Master-Details scenario?
I tried it but when I add relationship to the Detail Data Bands, they don't show anything

[CWS116]

I have a table include a column for Transaction Ids and other columns for details and each transaction have multi row in table. like this:

| Transaction_ID | Product_ID |
|1 | 10 |
|1 | 11 |
|1 | 12 |
|2 | 10 |
|2 | 11 |

I use Master-Details scenario so I have to use another store procedure for retrive same Transaction_IDs for master band because we can't add relationship between Transaction_IDs in same table. I guess, I can use Data Transformation instead of that store procedure for create other table.
If this can be done please help us.

Thanks!

[Lech Kulikowski]

Hello,

Unfortunately, at the current moment, the master-detail construction is not supported for Data Transformation.
You can use the "Data from other data source" for that task.

Thank you.