Query / Reporting

Overview

The Query / Reporting Tool is designed to allow the user to extract data from the DDI-Connect system.

Designing a Query

To begin designing a query:

Go to the DDI-Connect, Extract Module, click the Query / Reporting item. Then click new to start a new Query:

Enter in the Query Name. Then select if you want other Users to be able to run this query or not. Select a category, if desired.

Select a data source to add to the query.

Select the Query Type. Most standard queries will use the "All Rows" option.

Select a selection or multiple selections to filter your data. The "Prompt at runtime" button allows you to chose that filter option when running the query.

Select the field columns you want to display in your query.

Select the default column sort for your query.

Add another data source or click finish.

Running a Query - Option #1

You have 2 options when running a query.

Option #1: Select the query and click View. This will pull the data in a grid. The grid allows you to sort, group, hide columns, etc. From there you can export the data into a spreadsheet, pdf, .csv, etc.

Running a Query - Option #2

Highlight the query, then click the Export button at the top of the screen. Choose export options, file name/location, and run the query.