Showing survey question and responses in single column in incident survey report

[svirkar420]

Hello Developers,

I have a requirement in my project where I need to show the report for incident survey in such a way that it should look like a rating given like for Q1. The response for the Q1 for survey should be seen below the Q1 column.

In simple words here Q1 will be the table header and response submitted to that Q1 should be the table content which should be seen below the Q1 column.

I have attached the screenshot for this with this post. Please find it.

Your inputs will be valuable.

Best Regards,

Saurabh V.

[Dr Atul G- LNG]

Hi @svirkar420 

Step 3.b is not for reports — it's a step that comes before report creation. In ServiceNow, we can't directly create a report that pulls data from multiple tables in a straightforward way. To achieve that, we need to create a Database View, where the required tables are joined based on specific requirements. Once the Database View is set up, we can use it as the data source to generate the desired report.

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/use/reporting/concept/c...

[svirkar420]

Hello @Dr Atul G- LNG , yes I know that 3. b is not for reports but is for database view, but here is where I'm stuck. The join configurations are also provided but since the instruction are not clear I am not able to implement it just. 

What I want to know is, 
1. How to I configure the join between those tables, what clause should I write (3. c)

2. What should I do in case of (3. d)

3. For reports what should I select as a data source and type so that I can show the data in the form of posted question's screenshot.
If you can find any solution please let me know.

Your input will be very helpful

Best Regards,

Saurabh V.

[Dr Atul G- LNG]

Hi @svirkar420 

Greetings!!

1. How to I configure the join between those tables, what clause should I write (3. c)

Atul: You need to identify the common attributes between these tables and use them in the WHERE clause. You can refer to the out-of-the-box (OOTB) database view to understand how this works

2. What should I do in case of (3. d)

Atul: 3.d is your column in the database view. Once your database view is ready, you can decide which fields you want to display in the list. This makes setting conditions easier to do.

3. For reports what should I select as a data source and type so that I can show the data in the form of posted question's screenshot.

Atul: No, we will use table, as database view is a table only.

Friend, to be honest, it looks like the solution your client shared was generated by ChatGPT and not an actual implementation. I'm still unsure how a list-type report would work in this case. As I mentioned earlier, what you're looking for may not be directly doable.

[svirkar420]

Hello @Dr Atul G- LNG , I think I was not able to tell you everything, The report we have made so far is a list view, However they have suggested to use a pivot table as a report type not the list type (list type was created) and now they wanted a table format in the format of screenshot posted in the question, We can use a any other type like a pivot table or multi point pivot table, whichever is best for showing the data.
Now my doubt is that,

1. How do I configure the joins the tables using clause? (can you show it in PDI if possible as I am also trying to do it in PDI).

2. Which report type will be best pivot table or multilevel pivot table.

3. How do I fetch the data of database view into the reports.

That is all from my side, if you find any way to achieve this in any way, please let me know.

Best Regards,

Saurabh V.

[JackieZhang]

Did you think use a customer table to implement this solution or there is same limitations for it？