Export (0) Print
Expand All

Report Model Query Designer F1 Help

SQL Server 2005

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>

Topic Description

Report Model Query Designer Window

Use the Report Builder Query Designer window to generate semantic queries.

Filter Data Dialog Box [Model Designer]

Use the Filter Data dialog box to select what data you want to include in your report.

Filter List Dialog Box [Model Designer]

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.

Define Formula Dialog Box [Model Designer]

Use the Define Formula dialog box to create a new field that contains a formula.

Search Dialog Box [Model Designer]

Use the Search dialog box to locate a field within the currently selected entity or within the entire data source.

Community Additions

ADD
Show:
© 2014 Microsoft