Report Studio Report Queries |
Queries determine what data items appear in the report. Sometimes you want detail rows of data, which you obtain by using a simple SELECT statement. Other times you must calculate totals or averages using aggregate functions and grouped columns, or must apply filters to show only the data you want.
Report Studio automatically creates the queries you need as you build reports. However, you can modify these queries or create your own custom queries to get the results you want.
For more information about queries, see Working with Queries.
Related Topics: