Reporting

[sry]

Hi All, our client wants a report where they should view all the incidents and sctasks along with their variables. we have a record producer to create incident, that form has 70 fields. sctask has their own vairables.

we are thinking to create a custom table and insert records into it whenever users create an incident and sctaska. But this is so cumbersome. could anyone give us an idea how we can bring incident along with 70 fields, and sctasks along with their variables.

Thanks,

sry

[AndersBGS]

Hi @sry ,

The best solution is to create a report based on task table where you include sc_task and incidents and their variables. There are no reason to create a custom table for this ask. I would though say, that it sounds quite cumbersome to generate a report with all these variables, so I would recommend you to talk to your client and understand what they are actually looking for. It sounds to me that the report will not benefit anything.