Report Model Query Designer Window
Use Report Model Query Designer to generate a Report Builder query that returns a set of results in a tabular format. Report Model Query Designer is divided into two areas: the Explorer pane and the design area.
In Report Model Query Designer, you can:
- Explore the data available to you.
- Drag and drop fields onto the design area.
- Position the selected fields within the query.
- Apply filters.
- Create formulas.
Building Report Builder queries in Report Designer is similar to building tables in Report Builder. Use the Layout pane to format the report just as you would any other Report Designer report.
The results of your query are displayed below the Report Builder query.
Explorer Pane
Use the Explorer pane to view the selected model's available entities and folders, and their associated fields, and to select the fields and entities that you want to add to your query.
The Explorer pane is divided into two sections: Entities and Fields. When you start your report, the Entities section lists all the entities and folders within the model. When an entity in the Entities section is selected, the Fields section lists all the fields associated with that entity. When you drag and drop a field from an entity to the design area, the Entities section changes and displays only the information related to that entity.
Explorer Pane Options
- Search
Click to search for a specific item within the selected entity or folder, or within the entire model. When this button is clicked, the Search dialog box opens.
- Advanced Mode
Click to display advanced Explorer options such as recursive roles.
- Entities
Displays a list of the entities contained within the current model. To add an entity to your query, drag an entity name to the design area.
- New field
Click to create a new field and add a formula to the field. When this button is clicked, the DefineFormula dialog box opens.
- Fields
Displays a list of the fields associated with the currently selected item. To add a field to your query, drag a field name to the design area.
Design Area
When dragging and dropping a field, an I-bar is displayed in the location where the field will be inserted.
While working in the design area, your data is represented as "X" characters. To see the actual data in your query, you need to render the report by clicking the Run button or switching to the Preview tab. Your report is rendered and displayed on the Preview tab.
See Also
Reference
Concepts
Report Model Query Designer F1 Help
Other Resources
Ad Hoc Reporting with Report Models