Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 5

In this course, student learn how to create more sophisticated reports like subreports and cross-tabs, students also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries

  • Course Start Date: Nov. 28
  • Location: Ottawa (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 2 Days
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Crystal Reports Training Courses

Course Outline
Course Length: 12hrs (2 Days)

Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved.

Learning Objectives:
In this course, you will create complex reports using tools in Crystal Reports. You will:

- Create automatic and manual running totals
- Work with cross-tab reports
- Add subreports
- Create drill-downs in a report
- Use SQL statements in report processing
- Create complex formulas
- Add charts to reports
- Enhance report functionality

Target Student:

This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

Course Outline:
Section 1: Creating Running Totals
Create a Running Total Field
Modify a Running Total Field
Create a Manual Running Total

Section 2: Working with Cross-Tabs
Create a Cross-Tab Report
Format a Cross-Tab Report
Create Groups in Cross-Tab Reports

Section 3: Adding Subreports
Insert a Subreport
Edit a Subreport
Share Variables

Section 4: Creating Drill-Downs in a Report
Create a Drill-Down
Create Headings for Drill-Down Data

Section 5: Using SQL Statements in Report Processing
Create a Report Using SQL Queries
Summarize Report Data
Create Joins Using SQL
Create Subqueries
Create an SQL Expression Field

Section 6: Creating Complex Formulas
Work with Loops
Work with Arrays

Section 7: Adding Charts to Reports
Create Charts
Create a Chart with Drill-Down
Create a Top N Chart
Create a Cross-Tab Chart
Create Charts for Grouped Data
Format a Chart
Create a Chart Template

Section 8: Enhancing Report Functionality
Organize Data Based on a Hierarchy
Create a Dynamic Image
Create a Report Alert
Create a Geographic Map

Prerequisites & Certificates

Crystal Reports Level 1

Certificates offered

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support

Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.

Map & Reviews
[ View Provider's Profile ]

using TeamViewer
., .
.   .


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.

Here are some reviews of the training vendor.
Lori was excellent!
Reviewed by 2017
I think I underestimated my own knowledge of the program. This is not necessarily at the fault of the course or training provider.
Reviewed by 2016
I found the instructor very informative and she addressed all of my questions and concerns.
Reviewed by 2016
Instructor and venue were excellent. Made a full day training course enjoyable.
Reviewed by 2015
The building itself is pretty dingy, but the instructor made up for it!!
Reviewed by 2015
Too much information in one day - instructor had to race through material, skipping some of it entirely. Start delayed by 20 minutes due to course material not having been properly loaded on computers. These issues continued throughout class, ie some of my important menu tabs were in french, others in english. I had requested an English class. Another student had Excel 2007 instead of Excel 2010, when the rest of us and the instructor were working with 2010. I would have liked to continue to 4:00, but the instructor made it clear that her preference was to leave at 3:30, so no one said anything. The windows had to be opened because the room was too warm, but the people next to the windows were wearing their coats because they were too cold.
Reviewed by 2014
I would take antoher course from this company in the future.
Reviewed by 2014
The course was completely ruined because their was a complete novice in the class and they slowed down the class and we didn't learn everything that was said on the course description. There should be a questionnaire or a quick entrance test for the intermediate course to prevent this. OR the instructor should move on and tell the novice that if the cant follow to leave and join a different class, it seems unfair that 3/5 people didn't learn because of this.
Reviewed by 2014
Excellent value!
Reviewed by 2014
I took the Intermediate Excel trg on 17 Jul at Compuease and it was excellent. Alain did a great job presenting the material. However, the Advance Lvl 3 crse held on 25 Jul was terrible. The instructor was not prepared, had only slept 1 hour the night before, spent most of the time simply reviewing the various botton options on the main toolbar, and reviewing the text in the handout. We were not able to complete one exercise using an actual excel spreadsheet with info. The instructor keep jumping around from topics and often the students (there was only 2 of us) didn't know what he wanted us to. After 2 hours I gave trying to learn anything from this particular instructor. Very disappointing, especially after such a very well run crse on 17 Jul. Although I would take trg from Compuease again, I would make sure it was Alain conducting the trg.
Reviewed by 2014
AWESOME! The trainer was so engaged, knowledgeable, and helpful! I would take any training that she facilitates!
Reviewed by 2014
Didn't help me at all. Too fast, too many things for one day of training. Any time for practicing. It looks more like presentation which I didn't expect. I wanted to learn something and not just to be impresses by somebody's knowledge and I didn't learned anything. Only thing that I learned is to think twice before to give your many. Sorry for saying that, but I don't recommend it to anyone.
Reviewed by 2014
Introduce a two-hour free exercises. I like to explore and them ask questions if needed.
Reviewed by 2014
There wasn't a lot of time to ask questions at the end of the seminar such as topics not covered in class.
Reviewed by 2014
The class was reduced to one-day because of a lack of participants. However, I think it would have been better to reschedule to class rather than condense into one day. I left the course feeling I could learn much more than what was discussed. Thank you.
Reviewed by 2014
Good Course ~ Thank you :)
Reviewed by 2014
Good Course ~ Thank you :)
Reviewed by 2014
Instructor went over and beyond to help tailor the class to the student's needs. It was great.
Reviewed by 2014
Really nice place, better than the old location !
Reviewed by 2014
Felt that we should have received an actual MS Project book not just a photocopy of excerpts bound into a coil booklet give the price of the course.
Reviewed by 2013
Trainer was very knowledgeable of her subject. She was excellent and I would definitely recommend this course and Last Minute Training to anyone.
Reviewed by 2013
Fantastic course with an excellent instructor. Good learning pace but a little more time would be useful. Donna is a very knowledgable instructor and a pleasure to have. I never realized how much work was involved in making animation. Thanks for the great experience and I'm looking forward to training with you again.
Reviewed by 2013
The trainer was inexperienced....he admitted that he doesn't work on photoshop CS6...he has more experience on CS3... He kept talking about his personal business rather than the course. i had ask to be trained in CS6 mac not PC. Course files were not available. I only stayed until noon. I had more experience than the trainer.....Bad choice...waste of my time and money....
Reviewed by 2013
I prefered having the one-on-one training, because it met all my expectations. I've had many trainings in groups, sometimes you understand most of the course but others are slower. It was excellent for me, if I ever have training in the future it's definitely one-on-one. :)
Reviewed by 2013
the facility was a little bit too warm - no air circulation it seemed like.
Reviewed by 2013
Reviewed by 2013
Very good training. Introduction to course was a little lengthy, I felt that there was a little bit too much emphasis on minor details that we already knew (i.e.printing) and that this time could have been used on more details about Excel. The course was extremely helpful however and the consultant explained things very clearly. The building is old (which I understand is not the tenant's fault) but it smelt of mold which doesn't make for the most comfortable environement.
Reviewed by 2013
I enjoyed his sense of humour and his flexibility in meeting our needs within the group.
Reviewed by 2013
I liked the fact that you guys do your training in small groups, easier to learn the information and to ask question.
Reviewed by 2013
It was at our faciltiy so no commnent on top part
Reviewed by 2013
Lori was very knowledgeable! She answered all my questions beyond the course outline. She was patient and gladly willing to show me concrete examples of what the software could do and made recommendations of use based on my personal needs.
Reviewed by 2013
Since taking this course, I have been practicing my new knowledge and skills on a daily basis. I can honestly say now, I much rather work in Word then WordPerfect.
Reviewed by 2013
Excellent trainer, very knowledgable and well spoken. Would love to have her again. I learned many new applications.
Reviewed by 2013
Everything met my expectations for the one-day session.
Reviewed by 2012
The course and the trainer met all of my expectations. The instructior was very knowledgeable and friendly. Once thing that I would like to suggest is for the provider to ensure that all participants are clearly notified not to wear scented products on the day of the training. Being in a small classroom space, surrounded by overpowering scents was very distracting and made it difficult to breathe.
Reviewed by 2012
The instructor easily adapted to special requests that were above and beyond what was listing in the course offering. A couple of us wanted to know more about MS Project 2010 and, when it was not at all inconvenient to the other participants, she walked us through some of the differences. This added a lot of value to the course. Her confidence with the material was contagious.
Reviewed by 2012
I love teaching method, it is very affordable.
Reviewed by 2012
The only issue was the instructor, although EXTREMELY knowledgeable, didn't follow the Course Material at all. In fact I didn't even do a single exercise on the workstation. Essentially he used the White Board and showed examples (not in course material), and we discussed the nuances of "simple" SQL. Again, the instructor was extremely knowledgeable but there was absolutely no hands on (ie workstation etc)
Reviewed by 2012
Thank you for an enjoyable day of learning. Pierre was a great help. He answered our questions, and was very patient when we did not understand. Thank you again for an enjoyable learning experience.
Reviewed by 2012
Although the course information was relevant to the specific material - some basic Windows commands should not be necessary to be reiterated to students in class such as 'Cut and Paste' and 'Save File As'. This takes away valuable time to the specific subject course.
Reviewed by 2012
The course was great! Enjoyable and everything it said it would be.
Reviewed by 2012
I was the only participant so received one on one training. With a group you usually do exercises from a workbook which would have been beneficial to me but that didn't happen with one on one training. I was shown how to do something and then asked to do it too rather than starting an exercise from scratch in a workbook and having to figure it out myself.
Reviewed by 2012
No, all good to me !
Reviewed by 2012
An excellent faclity located in the heart of downtown Ottawa. Friendly instructor and staff. As this was a one on one instructional situation, the instructor tailored the workshop to my needs. She covered every one of the twenty-two topics that I had requested and sent via email the week previous. I would recommend this school to anyone needing to learn or augment their computer skills.
Reviewed by 2012
Our instructor was absolutely a delight. It made learning something that could have been boring in to something very fun and interesting. Dracy Whyte was great as a teacher!
Reviewed by 2012
We had individual projects with specific questions and the instructor was very flexible in the course presentation to address our issues.
Reviewed by 2012
We had the advantage of a very small class and very attentive lecturer to answer individual's questions
Reviewed by 2012
Great beginning for me.... I would have liked a longer basic course to cover some text data entry for templates, rather than just calculations...
Reviewed by 2012
Would have preferred some practical exercises with the instructor going around and seeing if we understood the training. eg. complete a travel claim sheet. There were only 5 participants to probably would have been a good time to wander around the class and see how we were doing. Difficult to see the screen, esp in the a.m. with the sun hitting it.
Reviewed by 2011
I had been using Word 2003 for several years. My software was recently upgraded to Word 2007. I found this course extremely interesting and useful for me. Sometimes, there are some really small tricks that can help immensely for our day-to-day work. The instructor was very knowledgeable and had a great personnality. This is one of the best courses I've taken and I've taken many... Marc
Reviewed by 2011
I found the instructor at CompuEase "Desiree" very patient and helpful! She is very knowledgeable and takes the time to help me through this training - especially since I've never used it before. Thank you! Connie
Reviewed by 2011
This was an awesome course. The trainer was fabulous, very hands on. I would highly recommend.
Reviewed by 2011
The trainer mentioned that I could retake the course for free and that this is something that is normally offered there. I might do that because it was an off day for me. I was feeling tired and my concentration was a bit off. The trainer also was having an off day because of a back injury. I have taken training with Compuease before and I find it is a friendly environment and the trainers are excellent.
Reviewed by 2011
I was trully satisfied with the services at CompuEase. I was lucky enought to receive a one on one training with no else then the founder, who is very knowledgeable. I will definitely watch out for future courses.
Reviewed by 2011
The room was kept at about 100 degrees. Also, we needed Photoshop CS5 on MACS. After we paid/registered, I was emailed and told they didn't have Macs. I said okay, we'll cancel. Then they said whoops sorry, we do have Macs. 12 hours before the course was to begin (we were travelling from out of town) they emailed to say they didn't have CS5 but only CS4 but that the instructor was "very knowledgeable." When we got there, there were in fact two computers that had CS5, but they weren't MACS, so we had to choose, either a PC with CS5 or a MAC with CS4. My PC kept crashing because it was so old and slow it couldn't handle a program like Photoshop. And since we were on CS5, everything the instructor told the class to do did not match what was on our screen and we had to hold the class up every half an hour saying "I don't have that option on my screen." The instructor made several references to sex (I appreciated his sense of humor, but not his taste or lack of) and he seemed more like a surfer dude than a teacher. He was very disorganized ,jumping all over the place, changing his mind about what he was going to talk about, etc. It was hard to follow what was going on in his head.
Reviewed by 2011
Excellent course! Excellent Training Provider! Stellar Instructor!
Reviewed by 2011
The smaller class size allowed for more one-on-one time with the instructor during the hands-on exercises, which optimized the learning experience. The course manual was a bit lacking, but luckily our instructor was a true expert in the field and was able to go into detail and even treat us to more advance applications when he saw that we were ready to take on the more advanced applications. I will certainly be taking another course with the training provider, especially if they continue to provide the student with such stellar instructors!
Reviewed by 2011
The course provided by CompuEase was great. The instructor was excellent and very knowledgeable. The course content directly applied to my needs. I would recommend this course to others and am considering taking the next level myself.
Reviewed by 2011
My instructor was very interesting and knowledgable. She took the time to explain things to me that were not covered in the course outline, but were relevant to my employment needs.
Reviewed by 2011
I thought that in some cases we could have practiced a bit more with the features that we learned about.
Reviewed by 2011
I am satisfied - in fact, I will go to another training within the few next weeks.
Reviewed by 2011
Good course and since I was the only participant I had the benefit of a one-on-one.
Reviewed by 2011
It was an excellent course, but I think it could be done in 1-day instead of 2-day course.
Reviewed by 2011
Instructor is very knowledgeable, patient and has a great rapport with her students.
Reviewed by 2011
The crse was very well paced, covering all aspects of Microsoft Excel that I wanted to learn / had questions on. The trg provider is very well versed in both the subject and teaching / instructing skills, ensuring that all questions are answered before moving on to the next lesson / exercise. The crse handout booklet used and will use in the future is a great ref.
Reviewed by 2011
Excellent instructor; flexible and willing to accommodate students by explaining specific details. Has great overview of MS office suite. Provides learning experience that enables.
Reviewed by 2011
Would love to receive course manual (not available at time of course).
Reviewed by 2011
This was a great course for beginers using Excel! Very well taught. Thank you.
Reviewed by 2011
From the "get go" the day was filled with delays and set backs (crashing computers and time delays to upload material). It appears that zero time given to course preparation....photo's had not been uploaded onto computers; the computers had not been pre-tested for functionality. The training room was filled with static - likely contributing to the problems with the computers. There was student manual that was missing (mine). The instructor provided his copy to me, but was left with none himself until after the lunch hour. I do not beleive the instructor had any kind of tuturial/instructor manual prepared - certainly one was not followed. Students were not given the basic of this course in any formal training approach - it might have been useful to follow the manual but it all seemed very hap-hazard hard understand, confusing. I did not know should be learning and why. The terms or functions (tools/keys)in the software was not well explained leaving the student wondering what was and wasn't important to know and why... - The training area lacks professionalism and cleanliness....There is nowhere to go for "breaks" (ie no lounge areas / or lunch if you happen to bring your own... the stairways skinks...
Reviewed by 2011
Extremly bad training. Company obviously not prepared for training--trainer's computer did not work and went down 4 or 5 times, my workstation did not work, I moved from computer to computer, none of these worked so had to share. Workstations not prepared prior to course with proper files (instructor had to load during break and this took over an hour). I could go on and on about how terrible this training was and this was not due to the instructor who was trying. We ended the session and asked for a re-take as the training was a complete disaster from start to end. One star for many of the above ratings is being generous.
Reviewed by 2011
This was the first time ever that I can remember having a two instructors teach a course. The tag team approach to teaching kept me on the edge of my seat. The thought of having a new voice and personality teaching the course material was like a breathe of fresh air. We was so wrapped up the level of passion the instructors brought to the classroom regarding Excel that we only stopped for a 30 minute lunch and then spent an additional hour at the end of the day where the instrctors shared experiences which had even challenged them.
Reviewed by 2011
1. CompuEase does not have special ergonomic equipment (ie.. cordless mouse) When I arrived at the Centre, I spoke to the secretary at the front desk to say who I was and that there was supposed to be a cordless mouse set up for me (she went to check on
Reviewed by 2011
The instructor was really new what she was dooing and we learned alote. However, we did not have access the the internet, the facility was hard to find and was not very clean and well organised. Only coffee was offered once (i don't drink cofee).
Reviewed by 2011
I appreciated the course as well as the instructor who was very professional.
Reviewed by 2011
The first morning, there was nobody there 5 minutes before the course started. Of course we started late. The courses was with COMPUEASE in Ottawa. They advertise the course in French and they delivered it in English, without reason. The teacher, the
Reviewed by 2009
The class is very informative and easy to understand. The instructor, Pierre presents himself well and with an excellent attitude, he seems to really enjoy teaching and is very patient. We can ask as many questions as we wish or have him repeat without a
Reviewed by 2008
28-November-2018 $1195 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!

Not interested in this Course?

Tell us why:

This page has been viewed 120 times.