Title: Is it possible to bind a column for every row of dataset 1 as parameter for dataset 2 ? [Print this page] Author: klhuiicil Time: 2020-9-22 08:21 Title: Is it possible to bind a column for every row of dataset 1 as parameter for dataset 2 ?
I have template dataset 1 return many rows .
and set template parameter to bind to parameter of template dataset 2 stored procedure .
However, I find that it only use the first row value of dataset 1 for all row as parameter value for dataset 2.
Author: Sybil Time: 2020-9-23 10:24
you can use dataset formula to get all values in one column https://help.fanruan.com/finereport/doc-view-850.html#3
tablename.select(colname)Author: klhuiicil Time: 2020-9-23 14:29
Got your meaning . But I think it may not meet our need . our need is
on ds1, we return let says 3 rows. voucher1, voucher2, voucher3.
Then on ds2 ( which is stored procedure) and take one parameter voucher_no.
The sp will use parameter voucher_no to get amount from many tables and calculation and return 1 value.
So we would like it
voucher1, ( call ds2 with voucher1 as parameter and return amount 1.
voucher2, ( call ds2 with voucher2 as parameter and return amount 2.
Many thanks for your prompt reply.Author: Sybil Time: 2020-9-23 15:03
According to your further description, I made a demo, you can refer to, [Because the data source used in the demo does not have SP, so I used the dataset for ds2; the dataset and SP have the same parameter transfer principle, you can refer directly]