Report on record producer submission

[Community Alums]

Hi all,

I need to create a report i.e., when a user submit the record producer i.e., inquiry. This will create a case in hr table. I need to create a report where the it has to consist the the data of inquiry and also what all the data the user submitted during the record producer submission.

Can anyone help me how to build report on this. The report has to be list view and the columns has to be the variable names

[Astik Thombare]

Hi @Community Alums ,

You can create report on sc_item_produced_record  .this table stores the record producer usage and the task produced.

  If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

Thanks,

Astik

[Community Alums]

@Astik Thombare 

Can you help me how to display the variable submission value in the report and the variable as a column in the report

[Astik Thombare · Accepted solution]

Hi @Community Alums  ,

Please Navigate to Reports -> Create New 

I'm creating report on incident table . In Data tab select table 

In Type Select list and then in Configure Tab -> Click on Choose Columns and Select Questions

Here , I'm selecting Create Incident Catalog Item once i clicked on icon that is mentioned in screenshot 

Select Variables Which want to show on report . I'm selecting Short Description and urgency 

At last click on ok and then run the report

         If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

Thanks,

Astik

[Astik Thombare]

Hi @Community Alums ,

             If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

Thanks,

Astik