https://www.servicenow.com/community/app-engine-forum/building-reports/m-p/3383052#M8893 <P>A department uses SLA data extensively to run reports; they keep asking for help with building reports off of the same set of tables. They seem to be conducted by dot-walking. What can we do to make it easier for them to build their reports?</P> Wed, 17 Sep 2025 07:13:50 GMT ameykelkar 2025-09-17T07:13:50Z https://www.servicenow.com/community/app-engine-forum/building-reports/m-p/3383052#M8893 <P>A department uses SLA data extensively to run reports; they keep asking for help with building reports off of the same set of tables. They seem to be conducted by dot-walking. What can we do to make it easier for them to build their reports?</P> Wed, 17 Sep 2025 07:13:50 GMT https://www.servicenow.com/community/app-engine-forum/building-reports/m-p/3383052#M8893 ameykelkar 2025-09-17T07:13:50Z https://www.servicenow.com/community/app-engine-forum/building-reports/m-p/3383056#M8894 <P>Hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/934997">@ameykelkar</a>&nbsp;,</P><P>The best approach is to create a <STRONG>Database View</STRONG> that joins the commonly used SLA tables (e.g., task_sla, incident, etc.) into one reporting-friendly view. This eliminates the need for heavy dot-walking and gives the department a single, consistent data source for reports.</P><P><STRONG>If you find my answer useful, accept it as solution and mark it helpful.</STRONG></P> Wed, 17 Sep 2025 07:16:08 GMT https://www.servicenow.com/community/app-engine-forum/building-reports/m-p/3383056#M8894 NityaB161013953 2025-09-17T07:16:08Z