This course will cover Creating Running Totals, Building Cross-tabs in Your Report, Adding Subreports, Creating Drill-downs, Writing SQL Statements, and Working with Prompts
- Course Outline
Lesson 1: Creating Running Totals
Topic 1A: Create a Running Total Field
Topic 1B: Modify a Running Total Field
Topic 1C: Create a Manual Running Total on Detail Data
Topic 1D: Create a Manual Running Total on Summary Data
Lesson 2: Building Cross-tabs in Your Report
Topic 2A: Create a Cross-tab
Topic 2B: Create a Specified Group Order
Topic 2C: Filter a Cross-tab by Group
Topic 2D: Change the Cross-tab Format
Topic 2E: Conditionally Format Rows and Columns
Topic 2F: Keep Groups Together
Lesson 3: Adding Subreports
Topic 3A: Insert a Subreport
Topic 3B: Link a Subreport to a Primary Report
Topic 3C: Edit a Subreport's Structure
Topic 3D: Format a Subreport Using the Format Editor
Topic 3E: Share Variables Between Subreports and Primary Reports
Topic 3F: Create an On-demand Subreport
Lesson 4: Creating Drill-downs
Topic 4A: Create a Drill-down
Topic 4B: Create Separate Headings for Drill-down Data
Lesson 5: Enhancing Report Processing by Writing SQL Statements
Topic 5A: Create a Report Using SQL Queries
Topic 5B: Summarize Report Data Using SQL Aggregate Functions
Topic 5C: Create Joins Using SQL
Topic 5D: Create Subqueries
Topic 5E: Create a SQL Expression Field
Lesson 6: Charting Data
Topic 6A: Create a Bar Chart
Topic 6B: Modify a Chart
Topic 6C: Format a Chart
Topic 6D: Create a Chart Template
Topic 6E: Create a Top N Chart
Topic 6F: Create a Cross-tab Chart
Lesson 7: Reporting on Excel Data with Crystal Reports
Topic 7A: Create a Report Based on Excel Data
Topic 7B: Modify a Report Generated from Excel Data
Topic 7C: Update Data in a Report Based on Excel Data
Lesson 8: Working with Prompts
Topic 8A: Create a Static Prompt
Topic 8B: Create a Dynamic Prompt
Lesson 9: Enhancing Report Functionality
Topic 9A: Group Data Hierarchically
Topic 9B: Create a Dynamic Image
Topic 9C: Create a Report Alert
Topic 9D: Create a Geographic Map
Appendix A: Understanding BusinessObjects Enterprise
Appendix B: Understanding Report Templates and the Section Expert
Appendix C: Report Data Manipulation Techniques
About our GUARANTEED TO RUN courses
With (R)Evolution, TekSource is transforming the way IT professionals receive training. Our courses are led by Certified Instructors and supported by online course mentors. Course content is delivered through expert video modules and interactive features, in tandem with virtual lab exercises and progress quizzes. When you take training with TekSource, you get a comprehensive training solution that incorporates the following value add components into one “revolutionary” offering:
We start the learning process well before you arrive at our door with lots of communication and information. Our instructors, coordinators and facilitators will ensure that when course participants arrive, they will have all the tools they need to be successful and students will have already started to learn
In our Facility with Certified instructors
With (R)Evolution, each course is supported by a certified instructor who facilitates, coaches and mentors the students through the learning process - their only job is to ensure our students’ success. Students attend class in one day increments (which can be non-consecutive days for multi-day courses).
* Since the course content is provided by the expert video modules, the in-class instructor can devote 100% of their time to individual instruction and guidance.
* Our exclusive consultative learning approach ensures that the needs of each student are assessed and support during and subsequent to the course is tailored to them.
Expert Video Modules
(R)Evolution guarantees consistent, high quality instruction, and uniform delivery of the course material mapped to official vendor course curriculum with no missed topics.
* Content is delivered by World Class Experts and Certified Trainers and it has been edited and produced so that students are presented the best possible delivery of the course material.
* Self Scheduled progress matches the learning speed of each student – it allows for instant review, and results in improved retention.
Throughout the Learning experience, instruction is reinforced with practical exercises, lab exercises completed in live lab environments and progress checks that give immediate feedback to the student regarding their progress.
* Keeps students engaged, on track and in line with their objectives
* Provides instant feedback, real time results and acts as a measure for the instructor to provide further mentorship
Online Mentoring and Support
The online mentoring support that is included with (R)Evolution starts when the student enters the classroom and continues for 6 months. As both a 3rd training resource in the classroom and as a valuable support service that is available 24/7, students have yet another mechanism to support their learning.
* Reinforces learning and acts as a support during the classroom session
* Assistance applying course concepts
* Access to our facility and ability to re-take some or all of the training is absolute assurance that required learning is received.
- Prerequisites & Certificates
Crystal Reports XI: Level 1, and knowledge of programming and/or SQL would be helpful.
Certificate of Completion
- Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course, will be subject to a 15% administration fee, and course ware fees where applicable. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
- Map & Reviews
TekSource Corporate Learning
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 2006 times.