Crystal Reports 10 Fundamentals

Picture of Crystal Reports 10 Fundamentals
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 6056 Students

Make the points you want to make by converting raw database or accounting information into impressive and meaningful reports.

Discover the secret techniques pros use to produce handsome reports that clearly convey almost any type of information to any type of audience. This class will help you unleash the hidden power of Crystal Reports to present database or accounting information in a way that unmistakably communicates the points you want to make.

If you have information you need to intelligently communicate to others, but cannot do so because it lies buried in your database, accounting program, or other data source, you need Crystal Reports--and this course.

It doesn't matter whether you need to develop a quick-turnaround report that your boss needed yesterday or an elaborate financial report for your company's annual report. Crystal Reports can handle it all, and your instructor will show you how.

You'll discover how to extract the data you want your report to include, how to sort it into the order you want, how to group related information together, and how to include totals for groups of figures or for the entire report. All the while, you'll gain valuable firsthand experience with the process of creating, running, and publishing polished, professional quality reports.

NOTE: If you have Crystal Reports XI, 2008, or 2011, then you should enroll in ""Crystal Reports Fundamentals"" rather than this course. Please check the Requirements for further information.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

Crystal Reports is the world's most popular software tool for creating reports based on data stored in databases. It's popular because of its power and flexibility, which will help you create reports that communicate the information you want to convey to the people you want to convey it to. In our first lesson, you'll learn why it's important to find out everything you need to know about the report you want to create before you even launch the Crystal Reports application. This advance planning gives you a much better chance of creating a report that achieves your objectives.

In this lesson, we'll hit the ground running and create a Crystal report from scratch. You'll learn how to connect to any of several different types of data sources, pull data from the data source, and place it into a report. Then you'll learn how easy Crystal Reports makes giving your report a professional appearance with a report header, page headers, page footers, and a report footer, in addition to column headings and the data itself. You'll also learn how to arrange all these items on a page for maximum visual impact.

Once you know how to pull data from a database and display it in a basic report, the next step is pulling data from multiple tables and displaying only the data you want, filtering out any irrelevant information. In this lesson, you'll learn how to perform all those functions, including building reports that allow the user to decide at runtime what to display. In effect, you can build one report that serves the purpose of multiple reports.

Displaying the information in a database is one thing—displaying it in a way that communicates effectively is another. One important way to enhance communication is to organize the data in a meaningful way. In today's lesson, you'll learn how to sort a report's data and how to group related data items together. You'll learn how to summarize numerical data with group totals and obtain an overall grand total. We'll also look into Crystal Reports' drilldown capability, which allows your report readers to use a simple mouse click to access suppressed details of a specific data group.

In this lesson, you'll dive into the details of the various report sections. We'll look at the Section Expert, which is your major tool for selecting options that control the appearance and the function of the various sections of a report. We'll also explore how to create a multicolumn report, most commonly used for printing mailing labels.

Today, you'll get hands-on experience formatting a report. We'll practice using absolute formatting, a feature that can dynamically adjust the appearance of your report based on the data it contains. We'll look at a number of formatting options that Crystal Reports offers to help you give your report just the look you want. By including Report Alerts in a report, for instance, you can guarantee that the person viewing the report will see and acknowledge anything that you consider to be of high importance. A report template is a great way to achieve a consistent appearance across a family of reports. We'll practice using both these options and more in this lesson.

Crystal Reports can do more than just display the data you select from your data source. It can also show correlations between related categories of data items using the Cross-Tab Object. You can show such correlations across the entire data set or within a selected group of data items. As usual, Crystal Reports provides considerable flexibility in how it presents the cross-tab data to users. In this lesson, you'll learn what the options are and how to use them.

You'll often need to create a report based on some, but not all, of the data in a database. For example, a sales manager may want to look only at the purchase records of her top five customers. Alternatively, she may want to view the performance of her bottom 10 salespeople. Crystal Reports makes it easy to produce such reports, as well as others that are selective about what they display. In this lesson, you'll create such targeted reports that make it easy for managers to make informed decisions.

You can make your reports dynamic, sensitive to what's happening at runtime, by using Crystal Reports formulas and control structures, and you'll find out how in this lesson. With formulas, you can operate on data and put the result into your report. You can save time and effort by including one or more of the predefined functions in your formulas. You can even create your own custom functions, save them, and use them both now and in the future. These facilities give you the flexibility to produce a sophisticated custom report written from scratch with a programming language such as Visual Basic or C#, but with much less time and effort.

Crystal Reports gives you the ability to embed one report inside another. The two reports can be related in some way, or they could be totally unrelated. As long as you have a reason for displaying both reports at once, you can do it, and you'll find out how in today's lesson. An alternative to embedding a subreport within a main report is embedding a hyperlink to the subreport, so we'll practice embedding subreports in this lesson, too.

In this lesson, we'll explore Crystal Reports' wide offering of charts and maps that can add visual dimension to the display of information in a report. For the visual learners in your target audience, charts and maps may be far better than columns of numbers at getting your point across. Today, you'll learn how to choose a chart type that best conveys the information you want to emphasize. You'll find out how to use color, font, scale, legends, and titles to help you highlight trends in the data or data points that fall outside the expected range.

After you've created a report, you need to distribute it. Crystal Reports gives you several convenient distribution options, and we'll explore them all in our final lesson. We'll talk about print and fax options, as well as exporting a report to any of a number of popular file formats, and transmitting it to the people who should read it. You'll learn how to post the report on your organization's intranet or the World Wide Web, then we'll discuss distributing reports via Crystal Enterprise's Crystal Reports Viewer.

Allen Taylor

Allen Taylor

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 28 computer-related books, including "Crystal Reports 2008 For Dummies," "Database Development For Dummies" and "SQL For Dummies." He has been teaching computer course... Read more Read Allen Taylor's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Crystal Reports 10 Fundamentals you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhelass="nav-item"> Contact

Marketing on a Shoestring

Picture of Marketing on a Shoestring
Now Only
$389
AUD
35% off
$599 AUD
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 1580 Students

Discover small business marketing strategies that can help you attract attention, woo your target audience, grow your customer base, and expand your profit's all for little or no money.

When it comes to marketing for small businesses, money isn't everything! In this course, you'll learn how to use the same marketing tricks the big companies employ—without making a big dent in your wallet.

As you build your own customised marketing plan step-by-step, you'll discover how to attract your target audiences, entice customers to buy your product or service, and keep buyers coming back for more. In addition, you'll find out how to generate the referrals that are crucial to your company's success. You'll get tips on evaluating your tactics, tracking your results, and fine-tuning your approach so it gets better every year. Best of all, the small business marketing strategies you'll learn will fit into any budget—and some are even free!

With the help of videos, spreadsheets, and hands-on activities, you'll build your skills in each lesson. You'll master cost-effective strategies including strategic partnerships, local marketing, search engine optimisation, social networking, e-mail marketing, lead generation, and niche marketing. Along the way, you'll see many real-world examples from other small businesses much like yours.

Whether you're new to advertising or looking for a refresher, this course will make you a marketing pro. And by the time you're done, you'll have a personalised plan of action for increasing your sales—all on a shoestring budget.

 

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

If you own a small business and need to stretch your marketing dollars, you’ve come to the right place! In today’s lesson, you’ll discover that you can promote your business effectively for just pennies—or sometimes even for free. The secret: a systematic marketing plan that targets your audience at every stage of the purchasing cycle.

The first step in successful marketing is getting people to <i>notice</i> you&mdash;and today, we&rsquo;ll look at three ways to achieve that goal. We&rsquo;ll start by talking about how to create a great first impression, both in person and through your brand. Next, you&rsquo;ll find out how to position yourself as an expert in your field. And finally, we&rsquo;ll talk about using the media to promote your business.

Want to stretch your marketing dollars to the max? Then put the power of partnerships to work for you. In this lesson, you&rsquo;ll discover how to combine forces with other individuals or businesses to create exciting and effective marketing opportunities. In addition, we&rsquo;ll talk about enlisting other people in your place-based marketing and word-of-mouth campaigns.

These days, a Web site is an essential marketing tool for any business. And here&rsquo;s the good news: You can create an attractive, professional-looking Web site quickly and easily, for only a few dollars. You&rsquo;ll find out how in this lesson&mdash;and you&rsquo;ll also learn the ins and outs of obtaining a domain name, getting a matching e-mail address, laying out your Web site, and finding a hosting provider if you need one.

When you&rsquo;re done creating your Web site, it&rsquo;s time for the next step: drawing traffic to it. In today&rsquo;s lesson, we&rsquo;ll explore how to do this through <i>on-page</i> and <i>off-page</i> search engine optimization (SEO). In addition, we&rsquo;ll look at pay-per-click ads, banner ads, classified ads, videos, and a host of other low-cost or free ways to draw attention online.

Successful business owners master the art of finding and cultivating leads, and that&rsquo;s what we&rsquo;re going to talk about today. We&rsquo;ll investigate everything from old-fashioned fishbowls to Facebook Business pages and Twitter, and we&rsquo;ll talk about the pros and cons of e-mail and direct mail marketing. Whether you&rsquo;re a traditionalist or a techie, you&rsquo;ll find an approach that&rsquo;s just right for you.

Congratulations: You&rsquo;ve scored a sale! Now, how can you keep your new customer coming back for more? In this lesson, we&rsquo;ll talk about inexpensive or free ways to generate repeat sales. In addition, we&rsquo;ll look at a variety of techniques for encouraging referrals&mdash;and finally, we&rsquo;ll talk about capturing your customer information in a database.

Some marketing efforts bring crowds of customers to your door. Others are a complete flop, wasting your time and money. How can you choose wisely? By doing some up-front analysis&mdash;and that&rsquo;s what we&rsquo;ll talk about today. When you complete today&rsquo;s lesson, you&rsquo;ll be equipped with all the tools you need to choose marketing tactics that have a high potential for success. In addition, you&rsquo;ll learn why <i>integrated</i> <i>marketing</i> gives you the best results, and you&rsquo;ll find out how to schedule a full year of marketing activities easily and efficiently.

Sure, you want everyone to buy yo5 61.414062 66.621094 C 60.460938 67.402344 59.476562 68.136719 58.453125 68.820312 C 57.429688 69.503906 56.375 70.136719 55.289062 70.714844 C 54.203125 71.296875 53.09375 71.820312 51.957031 72.292969 C 50.820312 72.761719 49.660156 73.175781 48.484375 73.535156 C 47.304688 73.890625 46.113281 74.191406 44.90625 74.429688 C 43.699219 74.671875 42.484375 74.851562 41.257812 74.972656 C 40.035156 75.089844 38.808594 75.152344 37.574219 75.152344 C 36.34375 75.152344 35.117188 75.089844 33.894531 74.972656 C 32.667969 74.851562 31.453125 74.671875 30.246094 74.429688 C 29.039062 74.191406 27.847656 73.890625 26.667969 73.535156 C 25.492188 73.175781 24.332031 72.761719 23.195312 72.292969 C 22.058594 71.820312 20.949219 71.296875 19.863281 70.714844 C 18.777344 70.136719 17.722656 69.503906 16.699219 68.820312 C 15.675781 68.136719 14.6875 67.402344 13.738281 66.621094 C 12.785156 65.84375 11.875 65.015625 11.003906 64.144531 C 10.136719 63.277344 9.308594 62.367188 8.53125 61.414062 C 7.75 60.460938 7.015625 59.476562 6.332031 58.453125 C 5.648438 57.429688 5.015625 56.375 4.4375 55.289062 C 3.855469 54.203125 3.332031 53.09375 2.859375 51.957031 C 2.390625 50.820312 1.976562 49.660156 1.617188 48.484375 C 1.261719 47.304688 0.960938 46.113281 0.722656 44.90625 C 0.480469 43.699219 0.300781 42.484375 0.179688 41.257812 C 0.0585938 40.035156 0 38.808594 0 37.574219 C 0 36.34375 0.0585938 35.117188 0.179688 33.894531 C 0.300781 32.667969 0.480469 31.453125 0.722656 30.246094 C 0.960938 29.039062 1.261719 27.847656 1.617188 26.667969 C 1.976562 25.492188 2.390625 24.332031 2.859375 23.195312 C 3.332031 22.058594 3.855469 20.949219 4.4375 19.863281 C 5.015625 18.777344 5.648438 17.722656 6.332031 16.699219 C 7.015625 15.675781 7.75 14.6875 8.53125 13.738281 C 9.308594 12.785156 10.136719 11.875 11.003906 11.003906 C 11.875 10.136719 12.785156 9.308594 13.738281 8.53125 C 14.6875 7.75 15.675781 7.015625 16.699219 6.332031 C 17.722656 5.648438 18.777344 5.015625 19.863281 4.4375 C 20.949219 3.855469 22.058594 3.332031 23.195312 2.859375 C 24.332031 2.390625 25.492188 1.976562 26.667969 1.617188 C 27.847656 1.261719 29.039062 0.960938 30.246094 0.722656 C 31.453125 0.480469 32.667969 0.300781 33.894531 0.179688 C 35.117188 0.0585938 36.34375 0 37.574219 0 C 38.808594 0 40.035156 0.0585938 41.257812 0.179688 C 42.484375 0.300781 43.699219 0.480469 44.90625 0.722656 C 46.113281 0.960938 47.304688 1.261719 48.484375 1.617188 C 49.660156 1.976562 50.820312 2.390625 51.957031 2.859375 C 53.09375 3.332031 54.203125 3.855469 55.289062 4.4375 C 56.375 5.015625 57.429688 5.648438 58.453125 6.332031 C 59.476562 7.015625 60.460938 7.75 61.414062 8.53125 C 62.367188 9.308594 63.277344 10.136719 64.144531 11.003906 C 65.015625 11.875 65.84375 12.785156 66.621094 13.738281 C 67.402344 14.6875 68.136719 15.675781 68.820312 16.699219 C 69.503906 17.722656 70.136719 18.777344 70.714844 19.863281 C 71.296875 20.949219 71.820312 22.058594 72.292969 23.195312 C 72.761719 24.332031 73.175781 25.492188 73.535156 26.667969 C 73.890625 27.847656 74.191406 29.039062 74.429688 30.246094 C 74.671875 31.453125 74.851562 32.667969 74.972656 33.894531 C 75.089844 35.117188 75.152344 36.34375 75.152344 37.574219 Z M 75.152344 37.574219 " fill-opacity="0" fill-rule="nonzero" />

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

In this lesson, we&rsquo;ll talk about key selling messages&mdash;those alluring words that overcome potential buyers&rsquo; objections and make them want to make a purchase immediately. You&rsquo;ll learn how to identify the unique features of your business, how to create a competitive positioning statement, and&mdash;most important of all&mdash;how to identify the <i>emotional benefits</i> that motivate your buyers. By the time you&rsquo;re done, you&rsquo;ll be able to distill your new knowledge into a short, powerful message that will turn skeptical people into eager customers.

Today, it all comes together! First, you&rsquo;ll create the two final elements of your marketing plan: your business goals and your marketing goals. You&rsquo;ll discover how to create goals that are clear-cut, realistic, and measurable, so you&rsquo;ll be motivated to meet (or even exceed) the targets you set.&nbsp; After that, you&rsquo;ll roll all of your information into a single document that will be your blueprint for marketing success. With this marketing plan in hand, you&rsquo;ll be ready to take your prospective buyers by storm.

In our final lesson, we&rsquo;ll talk about tracking&mdash;the secret to continually improving your marketing tactics and increasing your profits. You&rsquo;ll learn how to create a baseline and compile reports that can highlight your marketing successes and point to areas where you can improve. In addition, you&rsquo;ll discover different ways to track your campaigns&mdash;including the campaigns you might think are &ldquo;untrackable.&rdquo;

Glynns Thomas

Glynns Thomas

Glynns Thomas has 20 years of advertising and marketing experience. She has worked for several of the world’s best-known advertising agencies and was a Vice President of Internet Marketing at Wells Fargo Bank. Today, she’s an independent small bus... Read more Read Glynns Thomas's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Marketing on a Shoestring you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.