Muutke küpsiste eelistusi

E-raamat: Crystal Reports 2008: The Complete Reference

3.50/5 (40 hinnangut Goodreads-ist)
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 76,75 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Crystal Reports 2008: The Complete ReferenceSuurem pilt
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.















Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008

Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports.

Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. You will learn how to improve report interactivity with sort controls and the parameter panel; solve complex reporting problems with cross-tabs and subreports; integrate Crystal Xcelsius dashboards; reduce development time; and publish your results to Web and Windows applications.





Integrate pictures, multimedia files, graphs, and charts

Allow user-controlled report sorting with new sort controls Develop sophisticated formulas and custom functions with the Formula Workshop Embed Flash files, including Xcelsius 2008 interactive dashboards Create complex cross-tab reports with new derived rows and columns

Export reports into Word, Excel, Acrobat, and updated XML formats Enhance Web interactivity with the new parameter panel and optional parameter fields Work with SQL databases, OLAP cubes, and proprietary systems

Centralize design elements and auto-update reports using the repository Schedule and distribute reports with the latest BusinessObjects Enterprise XI 3.0 Embed reports in Web and Windows applications using Visual Studio 2008
Acknowledgments xxxiii
Introduction xxxv
Part I Designing Reports
Getting a Feel for Crystal Reports 2008
3(34)
Introducing Crystal Reports 2008
3(6)
Crystal Reports Screen Elements
4(4)
Starting Out: Opening or Creating a Report
8(1)
Using the Report Wizards
9(4)
Using the Blank Report Option
13(15)
The Database Expert
13(2)
The Design Tab and Field Explorer
15(2)
Report Sections
17(1)
Previewing the Report
18(1)
Moving and Sizing Objects
19(2)
Formatting Objects
21(2)
Customizing Crystal Reports Behavior
23(5)
The Report Explorer
28(1)
The Workbench
29(3)
Creating Projects and Adding Existing Reports
30(1)
Adding Report Packages
31(1)
The Dependency Checker
32(5)
Checking Dependencies in the Current Report
32(2)
Checking Dependencies for Workbench Projects
34(3)
Sorting and Grouping
37(34)
Sorting Your Report
37(3)
New Interactive Sorting
38(2)
Grouping Records
40(31)
Manipulating Existing Groups
45(1)
The Group Expert
46(1)
Adding Summaries
46(6)
Multiple Groups
52(2)
Specified Order Grouping
54(2)
Drilling Down on Data
56(3)
Grouping on Data Fields
59(1)
Customizing Group Name Fields
60(1)
Grouping on Formula Fields
61(1)
Top N Reporting
62(4)
Hierarchical Groups
66(5)
Analyzing with Advanced Selection Criteria
71(14)
Three Different Ways to Select Data
71(2)
The Select Expert
73(8)
Refreshing the Report Versus Using Saved Data
78(1)
Selection with Date Fields
79(2)
Manipulating the Selection Formula Directly
81(2)
Performance Considerations with Record Selection
83(2)
Using Formulas
85(70)
The Formula Workshop
85(4)
The Formula Expert
89(2)
The Formula Editor
91(18)
Data Types
101(2)
Creating a New Formula
103(4)
Editing, Renaming, or Deleting an Existing Formula
107(1)
Copying Formulas
108(1)
Number Formulas
109(3)
Order of Precedence
111(1)
String Formulas
112(8)
The ToText Function
116(2)
Picking Apart Strings
118(2)
Date/Time Formulas
120(3)
Number of Days Between Dates
120(1)
Number of Hours and Minutes Between Times
121(1)
Month, Day, Year, Hour, Minute, and Seconds Functions
122(1)
Date Value Function
122(1)
If-Then-Else Formulas
123(7)
Data Types in If-Then-Else Formulas
124(2)
Multiple Actions with One If-Then-Else Statement
126(3)
Helpful Built-in Functions for If-Then-Else Formulas
129(1)
Other Crystal Reports Logic Constructs
130(4)
Select Case Statement
130(1)
For Loop
131(2)
While Do Loop
133(1)
Boolean Formulas
134(2)
Variables in Formulas and Evaluation Times
136(12)
Declaring a Variable
136(2)
Variable Scope
138(1)
Assigning a Value to a Variable
138(2)
Displaying a Variable's Contents
140(1)
Evaluation Times and Report Passes
141(5)
When Not to Use Variables
146(2)
User Function Libraries
148(1)
Running Total Fields
149(6)
Creating Custom Functions
155(16)
Custom Functions Defined
155(2)
Creating Your Own Custom Functions
157(11)
Extracting Custom Functions from Existing Formulas
157(5)
Creating Custom Functions from Scratch
162(4)
Modifying Existing Custom Functions
166(2)
Sharing Custom Functions with Other Users
168(1)
Using Custom Functions in Your Formulas
168(3)
Making Your Reports Visually Appealing
171(44)
Setting Page Size, Orientation, and Margins
171(3)
General Formatting
174(3)
The Formatting Toolbar
174(1)
The Format Editor
174(3)
The Highlighting Expert
177(2)
Conditional Formatting Formulas
179(5)
Absolute Versus Conditional Formatting
179(4)
Creative Use of the Suppress Property
183(1)
Special Fonts, Graphics, Line Drawing, and Barcodes
184(8)
Using Special Fonts
184(2)
Using Bitmap Graphics
186(4)
Line and Box Drawing
190(1)
Printing Barcodes
190(2)
Text and Paragraph Formatting
192(3)
Format Editor Paragraph Formatting Tab
193(2)
The Format Painter
195(1)
Report Alerts
196(4)
Basing Report Formulas or Conditional Formatting on Report Alerts
200(1)
Crystal Reports Templates
200(6)
The Template Expert
202(1)
Creating Your Own Templates
203(3)
Adding Custom Text
206(9)
The Field Heading Text Object
207(1)
Combining Database Fields
208(2)
Combining Special Fields
210(2)
Formatting Individual Parts of Text Objects
212(1)
Importing Text from a File
213(2)
Using Sections and Areas
215(30)
Formatting Sections with the Section Expert
215(12)
The Section Expert
217(10)
Creating Summary and Drill-Down Reports
227(6)
Drill-Down Reports
229(4)
Multiple-Column Reports for Labels and Listings
233(2)
Using Multiple Sections
235(4)
Conditionally Suppressing Sections
239(2)
Printing a Bonus Message for Certain Records
239(1)
Printing a Different Page Header on Page 2 and Later
239(1)
Printing Odd and Even Page Headers or Footers
240(1)
Underlaying Sections
241(4)
Analyzing with Cross-Tabs
245(46)
Creating a Cross-Tab Object
245(10)
Editing an Existing Cross-Tab
250(2)
Creative Use of Grouping and Formulas
252(3)
Multiple Rows, Columns, and Summarized Fields
255(4)
Reordering Fields in the Rows, Columns, or Summarized Field Boxes
259(1)
New Derived Rows, Columns, and Cells
259(18)
Creating Calculated Members
260(14)
Using Embedded Summaries
274(3)
Customizing Cross-Tab Appearance
277(14)
The Style Tab
279(1)
The Customize Style Tab
280(4)
Labels or Legends with Cross-Tabs
284(1)
Conditionally Formatting Cross-Tabs
285(3)
Cross-Tab Virtual Page Formatting Options
288(3)
Creating Charts
291(34)
Types and Layouts of Charts
291(3)
Chart Type
292(1)
Chart Layout
293(1)
Creating Charts
294(21)
The Type Tab
295(1)
The Data Tab
295(11)
The Axes Tab
306(2)
The Options Tab
308(2)
The Color Highlight Tab
310(1)
The Text Tab
310(1)
Placing and Sizing Charts
311(3)
Modifying Existing Charts
314(1)
Zooming In and Out on Charts
315(1)
Drilling Down on Charts
315(1)
Finer Points of Chart Formatting
316(9)
Customizing Charts with Chart Options
316(9)
Creating Geographic Maps
325(16)
Different Map Types
325(2)
Adding a Map
327(6)
The Data Tab
327(6)
The Type Tab
333(1)
The Text Tab
333(1)
Drilling Down on Maps
333(1)
Changing the Map View
334(7)
The Map Navigator
334(1)
Resolving Data Mismatches
335(2)
Map Layers
337(4)
Integration with Crystal Xcelsius and Flash
341(18)
Adding a Flash .SWF File to a Report
341(3)
Flash Formatting Options
342(2)
Integrating Crystal Reports 2008 with Xcelsius
344(15)
Using Flash Variables with Crystal Xcelsius 4.5
344(7)
Integration with Xcelsius 2008
351(8)
Using Subreports
359(20)
Unlinked Subreports
360(6)
Drilling Down on Subreports
364(2)
Linked Subreports
366(5)
Linking Based on Formula Fields
369(1)
Linking to Existing Parameter Fields in Subreports
370(1)
Subreport Formatting with the Format Editor
371(1)
On-Demand Versus In-Place Subreports
372(2)
Passing Data Between Main Reports and Subreports
374(4)
Handling Empty Subreports
376(2)
Performance Considerations
378(1)
Interactive Reporting with Parameter Fields
379(40)
Creating a Parameter Field
380(5)
Responding to Parameter Field Prompts
382(1)
Data Type Considerations
383(2)
Using Parameter Fields in Record, Group, or Saved Data Selection
385(4)
The New Parameter Panel
389(2)
Displaying Parameter Field Values on the Report
391(1)
Creating Pick Lists
392(10)
Static Pick Lists
393(2)
Dynamic and Cascading Pick Lists
395(7)
Special Parameter Field Features
402(9)
Optional Parameter Fields
402(2)
Multiple Values
404(1)
Range Values
405(4)
Controlling Parameter Field Data Entry
409(2)
Conditional Formatting with Parameter Fields
411(2)
Highlighting Data Based on Parameter Fields
411(1)
Conditional Suppression Based on Parameter Fields
412(1)
Using Parameter Fields with Formulas
413(6)
Using a Parameter Field for Partial Text Matches
413(2)
Using a Parameter Field to Change Sorting or Grouping
415(1)
Using a Parameter Field to Control Top N Reporting
416(3)
Exporting Reports to Different Formats
419(18)
Exporting Reports to Office Applications
420(8)
Exporting to Different File Formats
420(8)
Exporting and Launching an Application
428(1)
Exporting to an ODBC Data Source
428(1)
Sending Reports via E-Mail and Messaging Systems
428(2)
New Crystal Reports 2008 XML Exporting
430(7)
Initial Export via Crystal Reports XML Schema
431(2)
Using an XSLT Transform
433(4)
Reporting from SQL Databases
437(54)
Logging On to SQL Databases
438(11)
Direct Database Drivers
438(1)
ODBC
439(1)
OLE DB
439(1)
Choosing the Database
440(5)
Changing SQL Options
445(2)
Changing to a Different Database
447(1)
Adding Additional Tables to the Report
448(1)
Removing Unused Tables from the Report
449(1)
Linking Tables
449(13)
Database Expert Links Tab
451(3)
Using Multiple Database Types in the Same Report
454(2)
Join Types, Link Types, and Join Enforcement
456(6)
Viewing the SQL Query
462(2)
Crystal Reports SQL Commands
464(4)
Creating the SQL Command
464(3)
Using a SQL Command in a Report
467(1)
Using SQL Stored Procedures
468(3)
Choosing Stored Procedures
468(1)
Working with Stored Procedure Parameters
469(2)
Using SQL Expression Fields
471(4)
Creating SQL Expressions
471(4)
Grouping on the Database Server
475(5)
Enabling Server-Based Grouping
477(1)
What's Required to Use Server-Based Grouping
478(1)
Effects of Drill-Down
478(2)
Accommodating Database Changes and Field Mapping
480(9)
Recognizing Database Changes
481(6)
Mapping Old Fields to New Names
487(2)
Performance Considerations
489(2)
Let the Server Do the Work
489(1)
Use Indexed Fields
490(1)
Reporting from Proprietary Data Types
491(28)
Reporting from Microsoft Outlook
494(1)
Reporting from the File System Data
495(3)
Reporting from the Windows Event Log
498(2)
Reporting from Web Server Logs
500(3)
Crystal Reporting with XML Data Sources
503(9)
Using Local XML Data Sources
503(4)
Using Web-Based XML Data Sources
507(5)
BusinessObjects Enterprise Universes
512(3)
Reporting with Salesforce.com Web Data
515(4)
Reporting from OLAP Cubes
519(24)
What Is OLAP?
519(2)
Crystal Reports OLAP Capabilities
521(1)
Supported OLAP Systems
521(1)
OLAP Report Creation Methods
522(1)
Using the OLAP Report Creation Wizard
522(9)
Adding an OLAP Grid to an Existing Report
531(3)
Adding an OLAP Grid Object
531(3)
Changing the OLAP Database Location
534(1)
Controlling OLAP Grid Appearance
534(2)
Virtual Page Formatting Options
535(1)
Interacting with the OLAP Grid
536(7)
The OLAP Worksheet
540(3)
Sharing Report Items with the Repository
543(22)
The Repository Defined
543(5)
The Repository Explorer Enterprise Items Folder
545(1)
The Repository Explorer Categories Folders
545(1)
The Repository Explorer Repository Items Folder
546(2)
Adding To/Updating the Repository
548(6)
Creating Folders and Categories
548(2)
Adding and Deleting Repository Item Objects
550(4)
Adding Repository Items to Reports
554(3)
Text Objects or Bitmap Graphics
554(1)
Custom Functions
555(1)
SQL Commands and Business Views
556(1)
Changing Repository Items on Your Report
557(2)
Updating Repository Versions of Objects
558(1)
Controlling Repository Rights
559(6)
Controlling Rights at the Central Management Server Level
561(2)
Controlling Rights at the Folder and Object Level
563(2)
Creating Crystal Reports Applications with Visual Studio .NET
565(42)
Crystal/VS.NET Bundle Options
566(2)
Crystal Reports Windows and Web Forms Viewer Control Objects
568(4)
Your First Application: Viewing a Report
568(4)
Crystal Report Object Types
572(4)
Integrated Report Designer
576(11)
Choosing a Data Source
578(2)
Selecting Records and Adding Field Objects
580(2)
Formatting Objects and Sections
582(1)
Sorting and Grouping
583(4)
VS.NET Report Customization Object Models
587(14)
Run-Time Customization with the CrystalReportViewer Object
588(3)
Report Viewer Events
591(1)
Run-Time Customization with the Crystal Reports Engine (ReportDocument)
592(9)
Distributing Crystal Reports Visual Studio .NET Applications
601(6)
General Concepts
602(5)
Part II Crystal Reports Enterprise Reporting
Crystal Reports Web Alternatives
607(30)
Exporting to Static HTML
608(10)
Hyperlink Capabilities
613(4)
Cascading Style Sheet Support
617(1)
Navigating and Viewing Report Parts
618(7)
Using Navigation
618(3)
Displaying Report Parts
621(4)
Introduction to BusinessObjects Enterprise XI 3.0
625(12)
BusinessObjects Enterprise Defined
625(4)
BusinessObjects Enterprise XI 3.0 New Features
629(1)
BusinessObjects Enterprise XI 3.0 Architecture
629(8)
Using InfoView
637(60)
Connecting to InfoView
637(3)
BOE Security Model
640(1)
InfoView Organization
640(10)
My Favorites and My Inbox
641(1)
The Document List
641(3)
Objects and Instances
644(2)
Viewing Reports: On Demand or Instance
646(3)
Viewing Third-Party Objects
649(1)
Setting InfoView Preferences
650(4)
General Preferences
651(1)
Change Password
652(1)
Crystal Reports Preferences
652(2)
Searching InfoView Objects and Instances
654(3)
Object-Level Search
654(2)
Content Search
656(1)
Viewing, Printing, and Exporting Reports
657(8)
Supplying Database Credentials and Parameters
657(3)
Using the Report Viewer
660(5)
Scheduling Objects
665(13)
Scheduling Options
666(8)
Scheduling Reports Containing Alerts
674(2)
Rescheduling Existing Instances
676(2)
Using Discussions
678(2)
Modifying or Deleting Existing Messages
680(1)
Organizing InfoView
680(17)
Working with Folders and Categories
681(4)
Organizing Objects and Instances
685(6)
The My InfoView Custom Layout
691(6)
Administering Enterprise Reporting Systems
697(90)
Introducing the Central Management Console
698(2)
Managing Users and Groups
700(12)
Adding, Modifying, and Deleting User Accounts
700(3)
Password Settings
703(1)
Adding Groups
704(6)
Placing Users in Groups
710(2)
Integrating BusinessObjects Enterprise with Existing Security Environments
712(6)
Windows NT
713(2)
Windows Active Directory
715(2)
LDAP
717(1)
Managing Folders, Crystal Reports, and Third-Party Objects
718(19)
Managing Public Folders and Subfolders
718(3)
Managing Personal Subfolders
721(1)
Adding Reports
722(10)
Adding Program Objects
732(3)
Adding Third-Party Objects and Hyperlinks
735(2)
Working with Categories
737(4)
Manipulating Categories
738(1)
Assigning Categories to Reports and Other Objects
739(2)
Controlling Access Using Rights
741(8)
Setting Folder and Object Rights
743(4)
Setting Access Rights for CMC Functions
747(1)
Defining Custom Access Levels
747(2)
BusinessObjects Enterprise Architecture
749(6)
Central Management Server (CMS)
751(1)
File Repository Servers
751(1)
Crystal Reports Processing Server
752(1)
Crystal Reports Job Server
753(1)
Program Job Server
753(1)
Destination Job Server
753(1)
Crystal Reports Cache Server
754(1)
Event Server
754(1)
List of Values Job Server
755(1)
Defining Output Destinations
755(4)
Creating Calendars
759(2)
Using Events
761(3)
Configuring Success/Failure/Alert Notification
764(4)
Success/Failure Notification
764(2)
Alert Notification
766(2)
Other General Administrative Tasks
768(6)
Adding Additional Licenses
768(1)
Setting Instance Limits
769(2)
Specifying Default InfoView Settings
771(1)
Using Instance Manager
772(2)
Managing Servers
774(13)
Viewing Server Properties and Metrics
774(4)
The Server Intelligence Agent and the CCM
778(9)
Appendix Formula Language Reference
787(154)
Functions: Additional Functions
787(12)
ByteToText
788(1)
DateTimeTo2000
788(1)
DateTimeToDate
788(1)
DateTimeToSeconds
788(1)
DateTimeToTime
789(1)
DateTo2000
789(1)
DTSTo2000
789(1)
DTSToDate
789(1)
DTSToDateTime
790(1)
DTSToSeconds
790(1)
DTSToTimeField
790(1)
DTSToTimeString
790(1)
EventNumber
790(1)
ExchGetId
791(1)
ExchGetOrganization
791(1)
ExchGetPath
791(1)
ExchGetSite
792(1)
ExtractString
792(1)
FRAccRecTurnover
792(1)
FRCashFlowVsTotalDebt
792(1)
FRCurrentRatio
793(1)
FRDebtEquityRatio
793(1)
FRDividendYield
793(1)
FREarningsPerCommonShare
794(1)
FREquityVsTotalAssets
794(1)
FRGrossProfitMargin
794(1)
FRInterestCoverage
794(1)
FRInventoryTurnover
795(1)
FRNetProfitMargin
795(1)
FROperatingProfitMargin
795(1)
FRPriceEarningsRatio
796(1)
FRQuickRatio
796(1)
FRReturnOnCommonEquity
796(1)
FRReturnOnEquity
796(1)
FRReturnOnInvestedCapital
797(1)
FRReturnOnNetFixedAssets
797(1)
FRReturnOnTotalAssets
797(1)
LooksLike
798(1)
Now
798(1)
Picture
798(1)
Soundex
798(1)
Functions: Alerts
799(1)
AlertMessage
799(1)
AlertNames
799(1)
IsAlertEnabled
799(1)
IsAlertTriggered
800(1)
Functions: Arrays
800(4)
Average
800(1)
Count
800(1)
DistinctCount
801(1)
MakeArray
801(1)
Maximum
802(1)
Minimum
802(1)
PopulationStdDev
802(1)
PopulationVariance
802(1)
StdDev
803(1)
Sum
803(1)
UBound
803(1)
Variance
803(1)
Functions: Conditional Formatting
804(1)
Color
804(1)
CurrentFieldValue
804(1)
DefaultAttribute
804(1)
Functions: Date and Time
805(13)
CurrentDate
805(1)
CurrentDateTime
805(1)
CurrentTime
805(1)
Date
805(1)
DateAdd
806(1)
DateDiff
806(1)
DatePart
807(1)
DateSerial
807(1)
DateTime
808(1)
DateTimeValue
808(1)
DateValue
809(1)
Day
810(1)
DayOfWeek
810(1)
Hour
811(1)
IsDate
811(1)
IsDateTime
811(1)
IsTime
812(1)
Minute
812(1)
Month
812(1)
MonthName
813(1)
Second
813(1)
ShiftDateTime
813(2)
Time
815(1)
Timer
815(1)
TimeSerial
815(1)
TimeValue
816(1)
WeekdayName
816(1)
Year
817(1)
Functions: Date Ranges
818(7)
Aged0To30Days
818(1)
Aged31To60Days
818(1)
Aged61To90Days
819(1)
AllDatesFromToday
819(1)
AllDatesFromTomorrow
819(1)
AllDatesToToday
819(1)
AllDatesToYesterday
820(1)
Calendar1stHalf
820(1)
Calendar2ndHalf
820(1)
Calendar1stQtr
820(1)
Calendar2ndQtr
821(1)
Calendar3rdQtr
821(1)
Calendar4thQtr
821(1)
Last4WeeksToSun
821(1)
Last7Days
822(1)
LastFullMonth
822(1)
LastFullWeek
822(1)
LastYearMTD
822(1)
LastYearYTD
823(1)
MonthToDate
823(1)
Next30Days
823(1)
Next31To60Days
823(1)
Next61To90Days
823(1)
Next91To365Days
824(1)
Over90Days
824(1)
WeekToDateFromSun
824(1)
YearToDate
824(1)
Functions: Document Properties
825(5)
ContentLocale
825(1)
CurrentCEUserID
825(1)
CurrentCEUserName
825(1)
CurrentCEUserTimeZone
826(1)
DataDate
826(1)
DataTime
826(1)
DataTimeZone
827(1)
FileAuthor
827(1)
FileCreationDate
827(1)
FileName
827(1)
GroupingLevel
828(1)
ModificationDate
828(1)
ModificationTime
828(1)
PrintDate
828(1)
PrintTime
829(1)
PrintTimeZone
829(1)
ReportComments
829(1)
ReportTitle
829(1)
SelectionLocale
830(1)
Functions: Evaluation Time
830(2)
BeforeReadingRecords
830(1)
EvaluateAfter
831(1)
WhilePrintingRecords
831(1)
WhileReadingRecords
831(1)
Functions: Financial
832(24)
ACCRINT
832(1)
ACCRINTM
832(1)
AmorDEGRC
833(1)
AmorLINC
833(1)
CoupDayBS
834(1)
CoupDays
834(1)
CoupDaysNC
835(1)
CoupNCD
835(1)
CoupNum
835(1)
CoupPCD
836(1)
CumIPMT
836(1)
CumPrinc
836(1)
Days360
837(1)
DB
837(1)
DDB
838(1)
DISC
838(1)
DollarDE
838(1)
DollarFR
839(1)
Duration
839(1)
Effect
840(1)
FV
840(1)
FVSchedule
840(1)
IntRate
841(1)
IPmt
841(1)
IRR
842(1)
ISPMT
842(1)
MDuration
842(1)
MIRR
843(1)
Nominal
843(1)
NPer
843(1)
NPV
844(1)
OddFPrice
844(1)
OddFYield
845(1)
OddLPrice
845(1)
OddLYield
846(1)
Pmt
847(1)
PPmt
847(1)
Price
848(1)
PriceDisc
848(1)
PriceMat
849(1)
PV
849(1)
Rate
850(1)
Received
851(1)
SLN
851(1)
SYD
851(1)
TBillEq
852(1)
TBillPrice
852(1)
TBillYield
852(1)
VDB
852(1)
XIRR
853(1)
XNPV
854(1)
YearFrac
854(1)
Yield
855(1)
YieldDisc
855(1)
YieldMat
856(1)
Functions: Grid Value
856(6)
CurrentColumnIndex
856(1)
CurrentRowIndex
856(1)
CurrentSummaryIndex
857(1)
GetColumnGroupIndexOf
857(1)
GetColumnPathIndexOf
857(1)
GetIndexOf
858(1)
GetNumColumnGroups
859(1)
GetNumRowGroups
859(1)
GetNumRows
859(1)
GetNumSummaries
859(1)
GetRowGroupIndexOf
859(1)
GetRowPathIndexOf
860(1)
GetTotalValueFor
860(1)
GridLabelAt
861(1)
GridRowColumnValue
861(1)
GridValueAt
862(1)
Row Or Column Names
862(1)
Functions: Math
862(7)
Abs
862(1)
Atn
862(1)
Ceiling
863(1)
Cos
863(1)
Exp
863(1)
Floor
864(1)
Int
864(1)
Log
864(1)
MRound
865(1)
Pi
865(1)
Remainder
865(1)
Rnd
866(1)
Round
866(1)
RoundUp
867(1)
Sgn
867(1)
Sin
867(1)
Sqr
868(1)
Tan
868(1)
Truncate
868(1)
Functions: Print State
869(6)
CountHierarchicalChildren
869(1)
CurrentPageOrientation
869(1)
DrillDownGroupLevel
870(1)
GroupNumber
870(1)
GroupSelection
870(1)
HasValue
871(1)
HierarchyLevel
871(1)
InRepeatedGroupHeader
871(1)
IsNull
872(1)
Next (Crystal Syntax only)
872(1)
NextIsNull
872(1)
NextValue (Basic Syntax only)
872(1)
OnFirstRecord
873(1)
OnLastRecord
873(1)
PageNofM
873(1)
PageNumber
873(1)
Previous (Crystal Syntax only)
874(1)
PreviousIsNull
874(1)
PreviousValue (Basic Syntax only)
874(1)
RecordNumber
874(1)
RecordSelection
875(1)
TotalPageCount
875(1)
Functions: Programming Shortcuts
875(1)
Choose
875(1)
IIF
875(1)
Switch
876(1)
Functions: Ranges
876(2)
HasLowerBound
876(1)
HasUpperBound
877(1)
IncludesLowerBound
877(1)
IncludesUpperBound
877(1)
Functions: Strings
878(14)
AscW
878(1)
ChrW
878(1)
Filter
878(1)
InStr
879(1)
InStrRev
880(1)
Join
880(1)
Left
881(1)
Length
881(1)
LowerCase
881(1)
Mid
881(1)
NumericText
882(1)
ProperCase
882(1)
Replace
882(1)
ReplicateString
883(1)
Right
883(1)
Roman
883(1)
Space
884(1)
Split
884(1)
StrCmp
885(1)
StrReverse
885(1)
ToNumber
886(1)
ToText
886(2)
ToWords
888(1)
Trim
889(1)
TrimLeft
889(1)
TrimRight
889(1)
UpperCase
890(1)
URLDecode
890(1)
URLEncode
890(2)
Val
892(1)
Functions: Summary
892(20)
Average
893(1)
Correlation
893(1)
Count
894(1)
Covariance
895(1)
DistinctCount
895(1)
Maximum
896(1)
Median
897(1)
Minimum
897(1)
Mode
898(1)
NthLargest
898(1)
NthMostFrequent
899(1)
NthSmallest
900(1)
PercentOfAverage
901(1)
PercentOfCount
902(1)
PercentOfDistinctCount
903(1)
PercentOfMaximum
904(1)
PercentOfMinimum
904(1)
PercentOfSum
905(1)
PopulationStdDev
906(1)
PopulationVariance
907(1)
PthPercentile
908(1)
StdDev
908(1)
Sum
909(1)
Variance
910(1)
WeightedAverage
910(2)
Functions: Type Conversion
912(1)
CBool
912(1)
CCur
912(1)
CDate
912(1)
CDateTime
912(1)
CDbl
913(1)
CStr
913(1)
CTime
913(1)
Functions: Xcelsius
913(1)
ToXMLColumn
913(1)
ToXMLData
913(1)
ToXMLRow
914(1)
Operators: Arithmetic
914(3)
Add (+)
914(1)
Divide (/)
914(1)
Exponentiate (^)
914(1)
Integer Divide (\)
915(1)
Modulus
915(1)
Multiply (*)
915(1)
Negate (-)
916(1)
Percent (%)
916(1)
Subtract (-)
916(1)
Operators: Array
917(1)
In
917(1)
Make Array
917(1)
Redim
917(1)
Redim Preserve
918(1)
Subscript ([ ])
918(1)
Operators: Boolean
918(3)
And
918(1)
Eqv (Logical equivalence)
919(1)
Imp (Logical implication)
919(1)
Not
919(1)
Or
920(1)
Xor (Logical exclusion)
920(1)
Operators: Comparisons
921(2)
Equal (=)
921(1)
Greater or Equal (>=)
921(1)
Greater Than (>)
921(1)
Less or Equal (<=)
922(1)
Less Than (<)
922(1)
Not Equal (<>)
922(1)
Operators: Control Structures
923(4)
Do While
923(1)
Exit For
924(1)
Exit While
924(1)
For
924(1)
If Then Else
925(1)
Option Loop
925(1)
Select Case
926(1)
While Do
927(1)
Operators: Conversion
927(1)
Currency ($)
927(1)
Operators: Other
928(2)
Assignment (:=)
928(1)
Comment (//)
928(1)
Date-time literal (#)
929(1)
Parentheses
929(1)
Operators: Pattern
930(1)
Like
930(1)
StartsWith
930(1)
Operators: Ranges
930(3)
Both End Points Excluded Range
930(1)
In Range
931(1)
Left End Point Excluded Range
931(1)
Make Range
931(1)
Right End Point Excluded Range
932(1)
UpFrom
932(1)
Up From But Not Including
932(1)
UpTo
933(1)
Up To But Not Including
933(1)
Operators: Scope
933(1)
Global
933(1)
Local
934(1)
Shared
934(1)
Operators: Strings
934(2)
Concatenate (& or +)
934(1)
In String
935(1)
Insert Empty String (``'')
935(1)
Subscript [ ]
936(1)
Operators: Variable Declarations
936(5)
BooleanVar
936(1)
CurrencyVar
936(1)
DateTimeVar
937(1)
DateVar
938(1)
NumberVar
938(1)
StringVar
939(1)
TimeVar
939(2)
Index 941
George Peck (Redondo Beach, CA) is a software trainer, consultant and developer with more than 20 years of experience in the computer industry. After more than 10 years as an internal consultant and trainer in a large corporation, George founded his own consulting and training firm, The ABLAZE Group, in 1994. He started with a large Visual Basic/Crystal Reports project for a major West Coast bank, and since then he has trained, consulted, and developed custom software for large and small clients throughout the United States and Canada. George is certified by Seagate Software as both a trainer and consultant. Seagate awarded him Training Partner of the Year for 1998-1999.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800715909906e.html
Märksõnad: