I am trying to run a report when a record is entered into a table. One field in the record will have data to be used to populate a mutli-select text prompt (called which_IDs) in the report. Is this possible? It works fine when running interactively. The event also trigges fine when a record is added to table, but the report always reports "no data avaialable'. The data in the record is comma-seperated, and the filter on the query in the report is ID in ?which_IDs?. Any one have success doing this?
thanks for any suggestions!
SOLVED: change filter on query to :
[ID] in (#csv( split(',', prompt('which_IDs','token')))#)