Getting a variable list to act on each record separately
I have a report that prints complex batch tickets for products to be produced. I created the variables with the settings for Multiple, Discrete and Custom settings set to TRUE to allow me to input a list of values for each Parent Part:
Qty To Make
I want to be able to input each variable with a value and add it to the list with each Parent Part using the Qty To Make and the Job Number individually. This allows each Parent Part to pull the data for it's structure and calculate based on the Qty To Make and just add the job number for the Parent Part in the report. It will not let me do a list of the Qty To Make as the error indicates this must be and Array. If there is any help one could give I would appreciate it.
Could you please explainin brief what exactly you are trying to do?
I understand that you are trying add a Custom value to the parameter field. If so please try this
add a command like this
select field from table
select 'Custom Value' from table
Now create a dynamic parameter using the field from command which shows the added parameter in the list.
Please let me know if I understood wrong!