FineReport Community

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
hi,

    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
Hi Sybil,
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
HI:

    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]
image.png

test.cpt

5.93 KB, Downloads: 1






Welcome to FineReport Community (https://community.finereport.com/) Powered by Discuz! X3.2