Reporting on Variables

Natsufab3 · ‎11-17-2016

i need to find a way to report on variables where each variable question is my column in record. i have seen few post on database views but it dint work although i was able to generate variable question as column names there isnt any record related to it.

Does anyone have any idea regarding this? It would be helpfull

Thank you

Natsufab3 · ‎11-17-2016

This 1 way i am trying to generate report is as table being question answer, and with each question as a condition filter with table name as incident and value not being empty. and it is working out although i couldnt get the variables as column name, i get them like rows. Something is better than nothing aint it!

Thank you

View solution in original post

Uncle Rob · ‎11-17-2016

The latest versions should allow this from the reporting interface. Look for "Variables" as an expandable section in the list of available fields when configuring a report.

Natsufab3 · ‎11-17-2016

Yes I have tried that too! so basically when this form is submitted it creates an incident ticket. and Variables+ can be viewed in ritm i was able to do it but records did not generate.

thank you

Uncle Rob · ‎11-17-2016

Ah.... yeah...
Unfortunately the way variables are stored for Record Producers is fundamentally different than how they're stored for Request Item.

Because "reasons" I suppose.

Natsufab3 · ‎11-17-2016

so is there no way i can retrive the information on to reports then?