When attaching a report to a notification message, what format does the report parameter need to be in to ensure the report pulls information if the report has required operatorparameters
Hi
Report parameters are specified using parameter and value pairs. You can use substitution variables as parameter values as below formatting.
parameter_name={{table_name.column_name}}
For your example, (if this is a custom report please check the inserted parameter name and set it accordingly) I assume the parameters should be part_from, part_to, partgroup.
Therefore the report parameters in the notification message , you need to insert the params as below (not exactly sure on the table and the columns, you need to make sure of that by checking metadata and report params)
part_from={{table.part_from}},part_to={{table.part_to}},partgroup{{table.partgroup}}
PS: Multiple parameters can be specified as above and must be separated by commas without spaces.
Hi
As the part_from and part_to are actually based on the part_id column as opposed to being a column themselves would I use this same format to specify an exact value that I would like entered every time the report is run?
for example
part_from={{0}}, or part_to=’0’ or is there another variable to this
in this scenario the report uses AND stock_bin_sum_view.part_id BETWEEN @ProductFrom AND @ProductTo
or is having the report parameters set up like this what is causing the issue?
And with the partgroup, if I wanted to capture all partgroups would I leave this blank? or is there a format I should put to include all
In a different scenario Purchase ordering - I have used parameter_name={{table_name.column_name}} POID={{purchase_order.purchase_order_id}} but this is still not pull through the data of the specific purchase order. In report admin the parameter name is POID but this is based on the purchase_order_id column - could this be impacting this functionality?
Kind regards,
Ore
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.