Reporting On Incident Variables

[david_walters]

I've seen a few posts about this but none that answer my question.

I have incident records that are created using a record producer. This record producer has a number of variables, some of which map to fields in the incident form.

I would like to create a report that shows a list of the records created by this record producer and the name and value of some of the variables. I can build the report to show the list of records and the name and value of the variables that map to fields (because those are just regular fields in the incident form), but how do you also get variables included in the report?

thanks,

David

[morgang]

I know I'm quite late to the party, but does this help?

That doesn't resolve the references on the values that aren't text, but it should work for text variables.       I put in question_answer (using v for variables as the alias in the join) as the first table and incident as the second table with the join i_sys_id=v_table_sys_id.     It fought me when I tried to specify a table name on the question_answer table, but there seem to be a lot of quirky things about document references.