use Data Transformation in Master-Details scenario

Stimulsoft Dashboards.WIN discussion
Post Reply
User avatar
CWS116
Posts: 8
Joined: Wed Jun 24, 2020 12:53 pm

use Data Transformation in Master-Details scenario

Post by 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 :? :?
User avatar
CWS116
Posts: 8
Joined: Wed Jun 24, 2020 12:53 pm

Re: use Data Transformation in Master-Details scenario

Post by 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
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: use Data Transformation in Master-Details scenario

Post by 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.
Post Reply