Advanced Crystal Reports Techniques
Most “Advanced” Crystal Reports courses are just the “Part 2″ of the beginner course and only cover different software functionality, rather than delving into the advanced subjects.
The IT Service is delighted to have secured the services of a true market leader to lift the lid on how the pros really develop reports.
These topics are suitable for all versions of Crystal Reports.
Remember, every course we offer is tailored individually to your requirements. No one has exactly the same needs from their training as you. So the timings shown below are just a guide - we may take a little longer, or a little less time on a topic. And every course we create for you:
- Is put together to meet your exact requirements
- Runs at your pace, in your office so that you're at home in your own surroundings
- Is geared towards the work you actually do – if you have a specific project, let’s work on that and make the day even more productive!
If you don’t see what you need below, just give us a call – we’re always happy to create something a bit unique for you.
We want you to be confident in our service. If you haven't used us for your training before, we offer a cast iron guarantee that you'll be happy with the course. For full details, see our training guarantee.
|Understanding Data||1 hour|
|A brief overview of data, tables, joins and how they all work together. An ideal primer for anyone without a DBA background.|
|Introduction to Formulas||1 Hour|
|Learning to program Crystal Reports Formulas is a course in its own right. But this Introductory module is enough to understand the theory needed to get the most from the other modules in this course.|
|Enable Users to drill down into the data they are interested in while getting the report’s formatting to remain meaningful.|
|Introduction – Quickly summarise report data into a handy grid. Cross-Tab Filtering – use Cross-tabs to display a subset of a report’s data. Cross-Tab – Misuse(!) cross-tabs to display tables of data like a sub-report.|
|Introduction – The basics of Chart building, covering all the main configuration and formatting options. Chart – use Cross-tabs to display a subset of a report’s data…perfect for Dashboards!|
|Chart Grouping – Use Grouping rules to increase the functionality of your charts.|
|Running Totals and Charts – How to increase a Chart’s versatility with one simple trick.|
|Running Totals||1 Hour|
|Running Totals – reveal how to make the most of Crystal Reports powerhouse feature. Learn all the basics of how to configure Running Totals for maximum effect.|
|Running Totals and Record Selection – Use Running Totals in conjunction with the Record Selection for increased reporting freedom.|
|Running Totals and Summarising a Summary – Use Running Totals to analyse existing summaries even further. Want the average time of shipping to customers who place more than three orders in a month…now you can!|
|Record Selection||1.5 Hours|
|Record Selection and Table Linking – Stop sabotaging your reports and learn how table linking can be overridden by careless Selection criteria and how to combat it!|
|Record Selection Introduction – Learn how Record Selection really works and build a solid foundation. Advanced selection criteria – Build complex conditions for report data by hand for a level of control undreamed of by the Selection Expert.|
|Advanced Parameters – Use parameters for far more than just direct field comparisons and control entire blocks of selection logic. (Note: This topic is also featured in the Parameter Module.)|
|Date Ranges – Use Crystal Reports’ own built-in date ranges in new and inventive ways for even greater control.|
|Group Record Selection – How to filter a report based on the result of a summary, and how to use the resulting report accurately.|
|Saved data selection – Learn how to let your users apply sub-filters to your pre-run reports accurately.|
|Introduction – Step by step, feature by feature, learn all that Parameters have to offer.|
|Dynamic Parameters – Link your Parameters to your data for upto date (NB: Version specific)|
|Advanced Parameters – Use Parameters for far more than just direct field comparisons and control entire blocks of selection logic. (Note: This topic is also featured in the Record Selection Module).|
|Parameter based Formatting – How to gain unprecedented control over the look and feel of their reports.|
(More than just making a report look “pretty”; learn how to use Crystal Reports built in formatting options to their utmost.)
|The easiest way to built a table grid around fields.|
|Using Formulas and HTML for the ultimate in formatting options.|
|And a host of other good stuff!!|
|Introduction – How Subreports work, placement and linking. When to use a subreport and when not to! For that added bit of bolt on functionality, subreports can solve a host of problems.|
|Passing data through variables to Subreports….and getting it back!|
|Advanced data passing – Misusing Parameters and passing Arrays back and forth.|
|SQL Expressions||3 Hours|
|Introduction – How SQL Expressions work and how/when to use them.|
|SQL primer – a quick and simple SQL overview for those with little/no SQL experience. More than enough to get started.|
|Linking SQL Expressions to report database fields for immense data control, both in the report summaries and Report filtering.|
|Introduction – Arrays can be a complicated subject, even for seasoned programmers. Learn the basic logic behind the complexity. And if you are a seasoned programmer, learn the anomalies with Crystal Report arrays that will trip you up time and again.|
|Arrays and Text – Change your Text manipulation forever and learn the basics of Arrays at the same time.|
|Typical Array Setup – No abstract nonsense here, a real life, step by step example of setting up an Array in the way you will use again and again.|
|Array functions – Discover the complete set of available functions which make Arrays super powerful. From summarising Arrays, to listing or copying them, this knowledge should be in every Report Writer’s arsenal.|