The Query page of the Dataset smart panel is where you can set or change the command type, the query string, and the timeout.
- Command type:
- You can choose from three enumerated command types.
Type Description Text Choose Text if you want to write a SQL query to retrieve data. StoredProcedure Choose this if you want to use a stored procedure. TableDirect Choose TableDirect if you want to return all rows and columns from one or more tables. - Query string:
Note: If you are using the TableDirect command type, you may need to use escape characters or qualifying characters if any of the table names include special characters. To choose multiple tables, use a comma-delimited list of table names without any spaces or padding. - Timeout:
- Set the number of seconds that you want the report server to wait for the query to return your data before it stops trying.