پیشنهاد فرادرس

آموزش پیشرفته Crystal Reports

دسته بندی ها: ابزار های گزارش گیری ، آموزش های VTC ، کریستال ریپورت

آموزش-پیشرفته-crystal-reports

به درخواست دوستان دوره آموزش پیشرفته Crystal Reports را در سایت قرار دادیم.

این دوره آموزشی محصول VTC است و بسیاری از مباحث پیشرفته ساخت گزارش را آموزش می دهد.

سرفصل های دوره آموزشی:

  • فایل های کاری
  • بررسی منوها
  • انواع Connection
  • استفاده از پایگاه داده تخصصی
  • تنظیمات امنیتی در Crystal
  • فیلدهای پایگاه داده
  • کار با SQL Play all movies  در  this Chapter Collapse
  • استفاده از Help  برای  Syntax
  • بررسی Running Totals
  • آشنایی با توابع سفارشی
  • ایجاد یک تابع
  • مفاهیم داده ها
  • استفاده از Cross-Tab
  • درج Subreports
  • استفاده از دستورات SQL
  • بررسی پارامتر های اصلی
  • استفاده از چند مقدار
  • پارامترها و فرمت های شرطی
  • استفاده از Wizard
  • انتخاب نوع نمودار
  • ایجاد یک Map
  • قالب بندی Map
  • کار با Alert ها
  • کار با Form Letter
  • اضافه کردن Tool Tip

لیست سرفصل های دوره آموزشی:

Crystal Reports is one of the most popular report writing applications available today. Its ability to create complex reports from a variety of data connections (including Microsoft, Oracle, and Business Objects) is highly acclaimed. In this VTC course, expert instructor Lauri Matson walks you through the power of Crystal Reports, exploring its features and showing you how to simplify the complexities. Anyone involved in creating reports from stored data will benefit from this course. You'll become be a master of design, formulas, parameters, and more. You will learn how to create advanced reports, analyze databases and table relationships, write formulas and functions, enhance your reports with charts and graphs, and much, much more. Experience with databases and spreadsheet programs is assumed, prior knowledge of Crystal Reports is recommended. To begin learning today, simply click on the movie links

Welcome (04:13) T

Work Files (03:11) T

Review of the Basics Play all movies in this Chapter Collapse

Planning a Report (05:33) T

Inserting Fields (05:42) T

The Screen Layout (04:26) T

Hints for Formatting (06:38) T

Grids and Guidelines (04:49) T

Reviewing the Menus (03:40) T

Advanced Database Concepts Play all movies in this Chapter Collapse

Connection Types (06:09) T

Using the Database Expert (02:56) T

Database Verification (05:06) T

Verification Options in Crystal (03:55) T

Relationships and Joins (04:25) T

Types of Joins (05:33) T

Mapping Database Fields (03:29) T

Viewing Your Data Play all movies in this Chapter Collapse

Views and Queries (06:13) T

Options and Your Data (05:54) T

Expressions vs. Commands (04:04) T

Working with SQL Play all movies in this Chapter Collapse

SQL Command Select (05:48) T

Combing Multiple Tables (03:40) T

SQL Order By / Where / Alias (06:07) T

Refresher of Formulas Play all movies in this Chapter Collapse

The Basics (05:53) T

Editing Formulas (04:04) T

Referencing Fields (03:36) T

Formula Syntax Play all movies in this Chapter Collapse

Basic vs Crystal Syntax (04:33) T

Syntax Continued (03:10) T

Variable Example (06:21) T

Using Help for Syntax (05:07) T

Placement of Formulas (05:48) T

More Formulas Play all movies in this Chapter Collapse

Select Expression (04:11) T

Dates and Formats (04:15) T

Extracting from a Field (05:00) T

Extraction Example (03:25) T

Commonly Used Formulas (05:46) T

SQL Play all movies in this Chapter Collapse

SQL Expressions (03:57) T

Expression Use of Select (03:59) T

SQL Command Example (03:19) T

Commonly Used Expressions (03:55) T

Running Totals Play all movies in this Chapter Collapse

Review of Running Totals (03:20) T

Groups and Totals (04:06) T

Manual Totals (03:46) T

Conditional Totals (03:48) T

Reset in Formula (05:30) T

Custom Functions Play all movies in this Chapter Collapse

Understanding Custom Functions (04:06) T

Creating a Function (04:54) T

Properties (05:05) T

More Examples (05:38) T

Performance Play all movies in this Chapter Collapse

Indexing (06:06) T

Indexing Continued (03:29) T

Strategies for Performance (04:20) T

Performance Continued (04:00) T

Optimizing for the Web (05:45) T

Design and Creation Play all movies in this Chapter Collapse

Planning your Report (06:10) T

Data Implications (04:15) T

Adventureworks Schematics (05:02) T

Refresher on Cross-Tab Reports Play all movies in this Chapter Collapse

Using a Cross-Tab (04:35) T

Formatting Cross-Tab by Design (03:42) T

Formatting in Preview (03:21) T

Cross-Tab Design (04:33) T

Cross-Tab Vocabulary (05:29) T

Cross-Tab Example (03:34) T

Subreports Play all movies in this Chapter Collapse

Inserting Subreports (05:03) T

Formatting (04:19) T

Subreports as Charts (03:57) T

OnDemand and Unrelated Reports (04:46) T

Time and Variables Play all movies in this Chapter Collapse

Date and Time in Fields (05:51) T

Date Format to Text (03:08) T

Working with Hours (04:09) T

Groups Play all movies in this Chapter Collapse

Reviewing Groups (04:19) T

Grouping on a Formula Field (03:35) T

Grouping Hierarchically (05:59) T

Working with Multiple Sections (06:14) T

Parameters Play all movies in this Chapter Collapse

Reviewing the Basic Parameter (06:18) T

Using Multiple Values (03:01) T

Using SQL Commands (05:25) T

Dynamic Values (04:42) T

Parameters and Conditional Formats (03:41) T

Charts Play all movies in this Chapter Collapse

Preparing a Report (03:13) T

Using the Wizard (03:21) T

Formatting (04:27) T

Selecting a Chart Type (04:22) T

Trendlines (03:42) T

Conditional Formatting (03:55) T

Charts in a Group Header (05:25) T

Mapping Play all movies in this Chapter Collapse

Creating a Map (04:11) T

Formatting a Map (03:44) T

Mapping Groups (05:31) T

Groups Continued (02:59) T

Other Tips and Tricks Play all movies in this Chapter Collapse

Mailing Labels (05:21) T

Working with Form Letters (06:24) T

Creating Alerts (04:42) T

Working with Alerts (02:18) T

Adding Tool Tips (05:49) T

Conditional Formatting (04:02) T

Alternate Row Formatting (04:31) T

Conclusion Play all movies in this Chapter Collapse

The Viewer (04:03) T

Dashboards and Excelsius (03:22) T

Remember the Help Menu (02:47) T

Wrap Up (02:48) T

Credits Play all movies in this Chapter Collapse

About the Author (02:20) T

عنوان دوره: VTC - Crystal Reports Advanced حجم فایل: 852MB

آیا این نوشته را دوست داشتید؟
VTC Crystal Reports Advanced

پیشنهاد فرادرس

لینک های دانلود VTC - Crystal Reports- Advanced_git.ir.rar