User`s guide

16.2 Defining the data selection for a query
You build queries in the Query Panel by using objects in a Business Objects universe. The objects in
the universe are a graphical representation of the information available in a database. The objects in
the universe are mapped to the table columns and rows in the database.
You can only base new documents and queries on universes for which you have been granted the
custom right, Create / Edit Query.
The Query Panel is divided into several panes:
• The pane on the left shows a tree view of the objects that your universe contains. You cannot add
new objects or edit existing objects in the Query Panel. For information about the types of objects
that might appear in this pane, see Quick reference to objects.
Note:
You can see all available objects in this pane by selecting "All objects." If you want to see how objects
relate to each other, select "Hierarchies." This option provides you with a visual representation of
the hierarchical structure of objects if such a structure is present in the universe.
• The Result Objects pane is where you place the objects that you want as part of your query.
• The Query Filters pane is where you place the objects that you want to use to filter the data that is
returned from your universe. You can define your filter when you add an object to this pane.
16.2.1 To build a simple query
1.
In the Query Name field, enter a name for your query.
Note:
Crystal Reports uses the query name as the name of the SQL Command that it creates for your
report. Once you have created your query in the Query Panel, you will see this name in the Available
Data Sources and Selected Tables areas of the Database Expert.
2.
Select an object in the left-hand pane and double-click it or drag it into the Result Objects pane.
Objects that appear in the Result Objects pane become fields that you report on in your Crystal
report.
3.
Repeat the previous step for each object that you want to include in the query.
4.
Select an object in the left-hand pane, or in the Result Objects pane, and drag it into the Query
Filters pane.
2012-03-14344
Building Queries