با استفاده از مفاهیم موجود در این دورهی آموزشی تصویری کریستال ریپورتس، خواهید آموخت که چگونه از این نرمافزار قدرتمند و بسیار کاربُردی در زمینههای تجارت هوشمندانه و دیگر موارد مربوطه استفاده نمایید؛ همچنین میآموزید که به منابع داده (Data sources) خود متصل شوید، آنها را غنیسازی نموده و به طراحی گزارشها و توزیع آنها بر حسب نیاز بپردازید. این دروهی آموزشی برای کاربران سطح مبتدی تهیه شده و فایلهای تمرینی را نیز به همراه خود دارد.
محتوای آموزش:
1- شروع به کار و اِعمال برخی تنظیمات بر روی نرمافزار
2- تنظیم یک گزارش جدید
3- قالببندی گزارش
4- استفاده از فیلدهای داده ویژه
5- اضافه کردن آیتمهای Non Data به گزارش
6- مرتبنمودن دادهها
7- فیلتر کردن Report Data
8- گروهبندی گزارشها
9- خلاصهسازی دادهها
10- استفاده از پارامترها در گزارشها
11- فیلدهای فرمول
12-قالببندی مقطعی
13- لینک کردن Data Table
14- توزیع گزارش
15- محیط کاری (Workbench)
تولید کننده: InfiniteSkills
تاریخ انتشار: 12-11-2011
سطح: مبتدی
مدت زمان آموزش: 9.5 ساعت
مدرس: Guy Vaccaro
فهرست کامل سرفصلها و عناوین آموزش :
01. In The Beginning
What Will I Be Able To Do With Crystal Reports
Quick Tour Of Crystal Reports Interface And Toolbars
Making Use Of The Included Working Files
Installing The Sample Databases Provided
Changing The Datasource Of The Working Files
About The Author
02. Setting Up A New Report
Starting Crystal Reports And A New Report
Setting Page Size Orientation For The Report
Making A Connection To The Sample Access Databases
Making A Connection To The Sample Excel Files
Making A Connection To The Sample SQL Server Database
Selecting The Correct Tables or Views
Field Explorer And Sections Overview
Adding And Removing Fields On The Report
Field Masks And Column Header Control
Browsing The Data Before Insertion
Previewing The Report For The First Time
Refreshing The Reports Data
Saving The Report
Saving The Report Without The Data
03. Report Navigation
Paging Through The Report
Searching For Text Within The Report
Changing The Zoom In Preview And Design
Using The Group Navigation Pane
04. Formatting The Report
Moving And Resizing Objects On The Report
Using The Guides And Other Alignment Options
Snap To Grid Saves The Day
Changing The Font Style, Size And Color
Adding A Color Border Or Background To Controls
Paragraph Settings
Number Formatting For Numerical Data Fields
Currency Formatting For Money Data Fields
Date Formatting Options
Using The Format Painter
Adding A Hyperlink To A Field
Lock The Format Size And Position Of An Object
Default Font Formatting Options
Default Data Formatting Options
Background Colors
05. Using The Special Data Fields
Adding Special Date Fields
Inserting Page Numbers
Adding The File Path To The Page Footer
Report Author And Title Fields
Of What Use Are The Remaining Special Fields
06. Adding Non Data Items To A Report
Inserting And Editing Text Objects
Format Options For A Text Object
Adding A Horizontal Or Vertical Line
Formatting A Line And Controlling Its Behaviour
Adding And Formatting A Box
Adding A Box That Crosses Section Boundaries
Adding A Company Logo Or Other Image
Adding Data Fields To Non Data Text Boxes
Removing Non Data Items
07. Sorting Data
How To Sort By A Field On The Report
Sorting By More Than One Field
Sorting By Fields NOT Visible On The Report
Removing Sort Criteria
08. Filtering Report Data
Filtering A Field By Existing Values
Using The Different Comparison Operators With Text Fields
Filtering The Data By Date Fields
Filtering Numeric Fields
Removing Filters From The Report
Filtering By More Than One Field
Multiple Field Criteria And/Or
Using A Wildcard In Filter Criteria
Filtering For Empty(NULL) Fields
09. Grouping Reports
What Is Grouping
How To Add A Group
Formatting The Group Name
Enhancing The Group Header
Grouping A Report On Dates Or Time
Creating Multiple Level Groups
Removing A Group
Changing The Group Sort Order
Customizing Group Heading Labels
Group Preview Options
Specifying Your Own Groups
Swapping The Data Field For A Group
10. Summarizing Data
Inserting A Grand Total Field
Insert A Sub Total Field
The Effects Of Moving Summary Fields Within A Report
Displaying Sub Totals As A Percentage Of Grand Totals
Summary Fields Using Average Minimum Or Maximum
Creating A Summary Report By Hiding Details
Creating A Drilldown Report
Refreshing A Drilldown Report
Sorting Group Based On Summary Values Not Group Values
Using Top Or Bottom N To Filter Summary Data
11. Using Parameters In Reports
What Are Parameters
Adding A Free Text Parameter Field
Using A Text Parameter To Filter Data
Number Parameter Fields For Filtering
Date Fields Used In Parameters
Creating And Using A Pick List Parameter
Creating And Using A Dynamic Pick List
Multiple Parameter Fields
Deleting Parameter Fields
12. Formula Fields
Creating A Formula To Enhance A Report
Altering And Renaming A Formula Field
Deleting A Formula Field
Creating A Formula To Concatenate
String Manipulation Formula In Action
Date Formula In Action
Calculating Age With Crystal Reports
Sorting And Filtering With A Formula Field
Using Formula Fields While Grouping
Formula And Parameter Fields Working Together
Conditions Within Formulas
Using IF To Negate A NULL Concatenation
13. Section Formatting
Report Header And Footer Options
Formatting Options Of The Page Header And Footer
Group Header And Footer Settings
Details Section Formatting Including Multiple Columns
14. The Standard Report Wizard
The Steps Involved In The Standard Report Wizard
Editing A Report Generated By The Wizard
Using The Report Templates On Your Own Reports
15. Data Table Linking
Quick Overview Of Relational Databases
Visual Linking In Crystal Reports
Warning Watch For Cartesian Joins
Link Types And Their Effect
Removing Tables From A Report
16. Distributing The Report
Choosing The Appropriate Export Format
Export Directly To Email
Exporting Data Into 2007/2010 Excel xlsx Format
Exporting To The New Read Only Format To Protect Report Design
17. The Workbench
Opening The Workbench
Adding Projects And Reports To The Workbench
Managing Reports Within The Workbench
نکات:
1- این آموزش به زبان انگلیسی است.
2- آموزش به صورت فیلمهای جداگانه برای هر فصل است.
3- فرمت فایلها MP4 است.
4- فایل های دانلودی قابلیت تعمیر با WinRAR در صورت دانلود ناقص را دارا می باشند.