This Learning Path contains courses that will teach you how to create reports in eB Director for predefined searches and using the eB Query Language. This course teaches you how to prepare, create and organize eQL reports in eB Director and eB Engineering Designer.
eB Report Designer Basics:
1) eB eQL Reports: Understanding the Data Structure
- Understand eB objects, their classes and how their structure within the database will drive reports.
- Realize the differences between properties and attributes and why it matters when you are creating reports.
- Gain knowledge about relationships and how they play a role in building reports.
2) eB eQL Reports: Getting Started in eQL
- Understand eQL Report design overview
- Identify the data to include in a Report
- Create and edit a Report in eB Director and Engineering Designer
3) eB eQL Report: Building the Query
- Build a basic query that drives the report to provide the data you need utilizing the Report Designer
- Know the anatomy and syntax of an eQL query, how to join criteria and use operators, wildcards & specify nulls
- Utilize auto-completion for object properties
- Specify Attribute Values
- Access the Hints topics
- Avoid Template Retrieval in your results
4) eB eQL Report: A Real eQL Query Example
- Identify the START WITH Object
- Complete a SELECT statement
- Utilizae the Handy Hints Topic areas
- Add Criteria to the WHERE statement
- Order your results using the ORDER BY statement
Reporting on eB Data:
Learn the various reporting options available for acessing data stored in the eB Information Manager system. Accessing and presenting eB data in helpful and easy to use and understandable formats will enhance your system for the end user to your management team. You will have a chance to build and execute custom quick searches, autofiling folders and eQL reports. SSRS reports will be explained and demonstrated.
Constructing an eQL Search