Database view not showing details in report

daniellethomson · ‎05-18-2015

I have created a database view to join the Change and Approval tables. I then created an approval report but when I export the report to display the details the change details do not show. Is there a way for me to pull in the entire change record to display as the details in the report?

brian_quinn · ‎05-20-2015

Danielle,

After looking at this a little more, now I understand what you are trying to do. When you use the "Export -> PDF -> Detailed Portrait" the report exports the summary table and the form view for each record.

http://wiki.servicenow.com/index.php?title=Exporting_Data#Exporting_List_Data

The issue with database views is that by default the form is empty. You can change this doing the following:

Type "database_view_name.form" in the type filter text box but do not hit enter (ie incident_sla.form)
- This should bring you to an empty page
Right click on the header and select Personalize -> Form Layout (Customize -> Form Layout on Fuji)
Add the fields you want to be displayed in the detailed report
Click Save

Then try to export your report again.

Thanks

Brian

View solution in original post

brian_quinn · ‎05-19-2015

Danielle,

Inside the view table you setup for change_request, what view fields have you added? You can try removing all of the view fields from the change_request table and that should default to loading all of the fields. This should then allow you to view any of the fields in the report.

Thanks

Brian

daniellethomson · ‎05-19-2015

Hi Brian,

I had the same thought this morning and removed all the view fields I did have added, but it's still not pulling in the data. I even moved my where clause from the approval table to the change request table. No change.

tony_barratt · ‎05-20-2015

Hi Danielle,

Have a look here:

Link Change to Approval for reporting

Is that helpful?

Best Regards

Tony

daniellethomson · ‎05-20-2015

Hi Tony,

Unfortunately, that link doesn't answer my question. I can get the data to show in the report but when I export the report in the PDF detailed view the details after the first page do not show. The only thing on the report is the summary page but the following details are blank.