The next step is to create a chart to show the detail information. Create the query for the detail chart so that it restricts the data it retrieves based on the value of the parameter. Use a WHERE clause in the SQL SELECT statement to limit the data.
If you did not provide an initial value for the parameter, the detail query may not initially return any rows, and the chart may appear empty. At runtime, however, the user's clicks will dynamically set the parameter, and the results of the detail query will change accordingly.
|
|
|
|
