Database view not showing details in report

[daniellethomson]

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]

Danielle,

What version are of ServiceNow are you using?   Can you also try using the out-of-box incident_sla database view and create a custom report   and export it to PDF to see if it has the same behavior?

Thanks

Brian

[brian_quinn · Accepted solution]

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

[daniellethomson]

Hi Brian,

I'm very excited for your answer but I'm not sure where to perform these steps. Where am I typing in the database_view_name.form?

Thanks!

Danielle

[brian_quinn]

Danielle,

You type it in the filter box in the upper lefthand corner.   In UI15 it says "Filter" in the box, but in older versions it says "Type filter text".

Thanks

Brian

[daniellethomson]

Brian,

Thank you so much!! That worked. i would never have figured that out on my own... seems odd that is how you fix the issue!

Danielle