The following options are available for query type: Before you create a query for your dataset, you must select a command type option on the Query page of the Dataset Properties dialog box. This graphical query designer supports three types of query commands: Text, StoredProcedure, or TableDirect. For more information about working with specific data source types, see Report Datasets (SSRS). For more information, see Text-based Query Designer User Interface. Use the text-based query designer to specify multiple Transact-SQL statements, complex query or command syntax, and expression-based queries. Use the graphical query designer to interactively build a query and view the results for data source types SQL Server, Oracle, OLE DB, and ODBC. Reporting Services provides both a graphical query designer and a text-based query designer for creating queries to retrieve data from a relational database for a report dataset in Report Designer.
0 Comments
Leave a Reply. |