Report Model Query Designer F1 Help
Use the Report Model Query Designer to generate Report Builder queries within Report Designer.
You can open Report Model Query Designer by opening Business Intelligence Development Studio, creating a New Project, selecting Report Server Project, and then specifying a connection string to the report model.
In the Data Source dialog box, specify the following:
- In the Name text box, type a name for your data source.
- In the Type drop-down menu, select Report Server Model.
- In the Connection string properties box, type a URL to the report model on a report server. The following example illustrates the connection string syntax for connecting to a report model:
Server=http://<reportservername>/reportserver; datasource=/<folder>/<modelname>
In This Section
| Topic | Description |
|---|---|
Use the Report Builder Query Designer window to generate semantic queries. |
|
Use the Filter Data dialog box to select what data you want to include in your report. |
|
Use the Filter List dialog box to reduce the number of items listed in the drop-down list box that is displayed in the filter. The purpose of the Filter List dialog box is to help you pre-filter the data that you want to add to a filter. |
|
Use the Define Formula dialog box to create a new field that contains a formula. |
|
Use the Search dialog box to locate a field within the currently selected entity or within the entire data source. |
See Also
Reference
Other Resources
Ad Hoc Reporting with Report Models
Working with Models
Connecting to a Data Source