Database Reference
In-Depth Information
How it works...
The steps you followed in this recipe are a simplified approach to creating a SQL query to
read information from the DPM database. The steps require that you plan for the data you
need and document the views and columns you need for your query.
When you create a report using a report-authoring tool, you need to supply a query to re-
trieve the data (dataset). When you use MSSMS to create a view, the SQL query is auto-
matically generated. You can use this approach to create your simple queries for the pur-
pose of reports.
In tools such as Report Builder, you can create a query graphically similar to the steps you
followed in MSSMS. The difference here is you create and test the query outside the au-
thoring tool.
Search WWH ::




Custom Search