Crystal Reports Tutorial
Selected Reading
- Crystal Reports - Discussion
- Crystal Reports - Useful Resources
- Crystal Reports - Quick Guide
- Crystal Reports - Data Export to CSV
- Crystal Reports - Data Export to HTML
- Crystal Reports - Data Export to XML
- Crystal Reports - Data Export to Excel
- Crystal Reports - Data Export Overview
- Crystal Subreports - Overview
- Crystal Reports - Edit Parameter Field
- Crystal Reports - Create Parameter Field
- Crystal Reports - Cascading Prompts
- Crystal Reports - Prompt Panels
- Crystal Reports - Filters
- Crystal Reports - Parameters
- Crystal Reports - Creating Arrays
- Crystal Reports - Creating Variables
- Crystal Reports - Conditional Formatting
- Crystal Reports - Applying Calculations
- Crystal Reports - If-Then-Else
- Crystal Reports - Apply Boolean Formulas
- Creating & Modifying Formulas
- Crystal Reports - Formula Workshop
- Crystal Reports - Defining Formulas
- Crystal Reports - Cross Tab Layout
- Crystal Reports - Charts
- Crystal Reports - Inserting Objects
- Crystal Reports - Templates
- Crystal Reports - Group Options
- Crystal Reports - Groups
- Crystal Reports - Delete Sections
- Crystal Reports - Sections
- Field Objects Controls & Modifications
- Crystal Reports - Time Based Filters
- Query Filters & Filter Conditions
- Crystal Reports - Queries
- Crystal Reports - Data Sources
- Crystal Reports - Design Environment
- Crystal Reports - Getting Help
- Crystal Reports - Page Layout
- Crystal Reports - Options
- Crystal Reports - GUI Navigation
- Crystal Reports - Overview
- Crystal Reports - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Crystal Reports - Queries
Crystal Reports - Queries
SAP BEx and Universe data source connections allow you to create and design query in Crystal Reports.
Create Queries
To create a query in Universe you can choose both OLAP and Relational data sources.
First step in a query design is to define objects that you want to add in your query. You can also refine your query by applying sorts and query filters. Query panel is spanided into multiple panes −
Universe Pane
It contains a tree structure of all the objects in Universe. You can see all the objects in Universe by using Expand All option.
You cannot add new objects or edit existing objects in query panel.
Result Objects Pane
In this area, you add objects that you want in your query.
Query Filter Pane
This is used to filter the value of objects in the report. You can use predefined filters or can create custom filters by adding objects.
SAP BEx queries can contain one or more hierarchies and predefine objects to run the report.
SAP HANA queries include data from SAP HANA Modepng views: Analytic, Calculation Views. To connect to HANA database and to use Schemas → tables inside the database, you can use an existing Relational or OLAP connection. A Relational connection can be created in IDT tool.
An OLAP connection can be created in CMC as well as in Information Design tool. HANA multi-dimensional views can be connected to Crystal Reports using an OLAP connection.
Cpck on Next → It will show you pst of all Modepng views inside HANA repository → Select a Modepng View → Finish
It will open objects of view in a query panel, which can be used to add them to the report.
Editing a Query
Once the Crystal Report is created using a query, to make changes to objects you have to go to edit data source option. When you cpck on the option, it will open an Edit Query panel where you can add/delete objects, apply filters, etc.
You can also edit an existing query by going to Data → Edit Data Sources as shown in the following image.
Once you are done with the changes, cpck on Finish and all changes will be appped to data in Crystal Report.
Advertisements