Design the Query
Copy
You need to provide the SELECT SQL query that fetches data for the Report. In many cases, you can enter a simple SELECT clause directly in the dialog box.
Figure 31.
Note
It is possible to pass Named Parameters into the query such as:
The Edit… button opens a Query Builder interface, which is covered later in more detail.
SELECT * FROM [PROJECT] WHERE id=@IDThe Edit… button opens a Query Builder interface, which is covered later in more detail.