I need to use a multi-column parameter, can art 7.6 be implemented?
For example, if I want to estimate the number of shipments of a product and then calculate the estimated revenue:
product quantity
A1 100
A2 300
A3 400
There are two columns of parameters I need to use, one is the product model and the other is the estimated sales quantity
I have tried the file parameters, it seems that I can't do it, is there any better solution?
Thank you!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
My hope is to be able to input parameter values from csv or txt files, because the raw data is stored in the user's file;
If you can use art's report page to achieve this parameter input is also good.
Because my report needs to calculate the estimated amount, the product model is in my system, but the quantity needs to be filled in by the user;
Therefore, the user needs to fill in the product model and the corresponding quantity at the same time to achieve the purpose of calculation.
Thank you for your reply！
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No - i tried it on my testsystem, but i only get it working as an "IN-List" - only one entry per line. But not "vertically". I also tried to use the filecontent within one value and split it on my own, but it didn't work.
We internally have a tool for uploading xlsx files (don't know who developed this) - this uploads the file into a table, and then i can link to the report, where the uploaded data is used in the join...
Maybe it's possible with groovycode, but i don't have experience with this.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The requirement is kind of custom, so not really clear how the multiple values from the file would be used in the sql query. It would most likely be possible with groovy code, which would basically allow you to iterate through the file and do anything you want with it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I need to use a multi-column parameter, can art 7.6 be implemented?
For example, if I want to estimate the number of shipments of a product and then calculate the estimated revenue:
product quantity
A1 100
A2 300
A3 400
There are two columns of parameters I need to use, one is the product model and the other is the estimated sales quantity
I have tried the file parameters, it seems that I can't do it, is there any better solution?
Thank you!
How do you want to enter the data of the parameter? Do you have a file (Csv, ..) ?
Or is this part of a previous executed report?
My hope is to be able to input parameter values from csv or txt files, because the raw data is stored in the user's file;
If you can use art's report page to achieve this parameter input is also good.
Because my report needs to calculate the estimated amount, the product model is in my system, but the quantity needs to be filled in by the user;
Therefore, the user needs to fill in the product model and the corresponding quantity at the same time to achieve the purpose of calculation.
Thank you for your reply！
No - i tried it on my testsystem, but i only get it working as an "IN-List" - only one entry per line. But not "vertically". I also tried to use the filecontent within one value and split it on my own, but it didn't work.
We internally have a tool for uploading xlsx files (don't know who developed this) - this uploads the file into a table, and then i can link to the report, where the uploaded data is used in the join...
Maybe it's possible with groovycode, but i don't have experience with this.
Thank you for your help, I hope to add such parameter function in the later version, I can only try to see if there is any other way.
The requirement is kind of custom, so not really clear how the multiple values from the file would be used in the sql query. It would most likely be possible with groovy code, which would basically allow you to iterate through the file and do anything you want with it.