Muutke küpsiste eelistusi

E-raamat: Crystal Reports XI: The Complete Reference

3.54/5 (54 hinnangut Goodreads-ist)
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 82,37 €*
  • * 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 XI: 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.







This best-seller has been fully updated for Crystal Reports XI (extreme insight) -- the first jointly developed release of this leading report writing and analysis software since the acquisition of Crystal Decisions by Business Objects. Readers will learn to create visually appealing reports that communicate content effectively using helpful features such as charts, complex formulas, custom functions, sorting and grouping, Business Views, and more. Publishing and viewing reports on the Web is also explained in detail. NEW coverage includes: All the new user interface elements; New Dynamic/Cascading Parameter Fields; and, Using Crystal Reports with Business Objects Enterprise XI.
Acknowledgments xxv
Introduction xxvi
Part I Designing Reports
Getting a Feel for Crystal Reports XI
3(34)
Introducing Crystal Reports XI
3(5)
Crystal Reports Screen Elements
5(3)
Starting Out: Opening or Creating a Report
8(1)
Using the Report Wizards
8(5)
Using the Blank Report Option
13(14)
The Database Expert
13(2)
The Design Tab and Field Explorer
15(1)
Report Sections
16(1)
Previewing the Report
17(1)
Moving and Sizing Objects
18(2)
Formatting Objects
20(3)
Customizing Crystal Reports Behavior
23(4)
The Report Explorer
27(2)
The New Workbench
29(3)
Creating Projects and Adding Existing Reports
30(1)
Adding Report Packages
31(1)
The New Dependency Checker
32(5)
Checking Dependencies in the Current Report
32(2)
Checking Dependencies for Workbench Projects
34(3)
Adding Text to Reports
37(8)
The Field Heading Text Object
38(1)
Combining Database Fields
38(2)
Combining Special Fields
40(2)
The Can Grow Formatting Option
41(1)
Formatting Individual Parts of Text Objects
42(1)
Importing Text from a File
43(2)
Sorting and Grouping
45(30)
Sorting Your Report
45(1)
Grouping Records
46(29)
Manipulating Existing Groups
50(2)
The Group Expert
52(1)
Adding Summaries
53(4)
Multiple Groups
57(2)
Specified Order Grouping
59(3)
Drilling Down on Data
62(3)
Grouping on Date Fields
65(1)
Customizing Group Name Fields
65(1)
Grouping on Formula Fields
66(2)
Top N Reporting
68(3)
Hierarchical Groups
71(4)
Analyzing with Advanced Selection Criteria
75(14)
The Select Expert
75(7)
Refreshing the Report Versus Using Saved Data
80(1)
Record Selection with Date Fields
81(1)
Manipulating the Record Selection Formula Directly
82(2)
Limiting Data with a Group Selection Formula
84(2)
Performance Considerations with Record Selection
86(3)
Using Formulas
89(64)
The Formula Workshop
89(4)
The Formula Expert
93(2)
The Formula Editor
95(14)
Data Types
103(1)
Creating a New Formula
104(4)
Editing, Renaming, or Deleting an Existing Formula
108(1)
Number Formulas
109(3)
Order of Precedence
111(1)
String Formulas
112(7)
The ToText Function
116(2)
Picking Apart Strings
118(1)
Date/Time Formulas
119(4)
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(6)
Data Types in If-Then-Else Formulas
124(2)
Multiple Actions with One If-Then-Else Statement
126(2)
Helpful Built-in Functions for If-Then-Else Formulas
128(1)
Other Crystal Reports Logic Constructs
129(4)
Select Case Statement
130(1)
For Loop
131(1)
While Do Loop
132(1)
Boolean Formulas
133(2)
Variables in Formulas and Evaluation Times
135(12)
Declaring a Variable
136(1)
Variable Scope
137(1)
Assigning a Value to a Variable
138(2)
Displaying a Variable's Contents
140(1)
Evaluation Times and Report Passes
141(4)
When Not to Use Variables
145(2)
User Function Libraries
147(2)
Running Total Fields
149(4)
Creating Custom Functions
153(16)
Custom Functions Defined
153(2)
Creating Your Own Custom Functions
155(10)
Extracting Custom Functions from Existing Formulas
155(5)
Creating Custom Functions from Scratch
160(4)
Modifying Existing Custom Functions
164(1)
Sharing Custom Functions with Other Users
165(1)
Using Custom Functions in Your Formulas
166(3)
Making Your Reports Visually Appealing
169(30)
General Formatting
169(3)
The Formatting Toolbar
170(2)
The Format Editor
172(1)
The Highlighting Expert
172(2)
Conditional Formatting Formulas
174(6)
Absolute Versus Conditional Formatting
175(3)
Creative Use of the Suppress Property
178(2)
Special Fonts, Graphics, and Line Drawing
180(6)
Using Special Fonts
180(1)
Using Bitmap Graphics
180(5)
Line and Box Drawing
185(1)
Text and Paragraph Formatting
186(3)
Format Editor Paragraph Formatting Tab
187(2)
The Crystal Reports Format Painter
189(1)
Report Alerts
190(4)
Basing Report Formulas or Conditional Formatting on Report Alerts
193(1)
Crystal Reports Templates
194(5)
The Template Expert
195(1)
Creating Your Own Templates
196(3)
Using Sections and Areas
199(26)
Formatting Sections with the Section Expert
199(9)
The Section Expert
201(7)
Creating Summary and Drill-Down Reports
208(6)
Drill-Down Reports
210(4)
Multiple-Column Reports for Labels and Listings
214(3)
Using Multiple Sections
217(3)
Conditionally Suppressing Sections
220(1)
Printing a Bonus Message for Certain Records
220(1)
Printing a Different Page Header on Page 2 and Later
221(1)
Printing Odd and Even Page Headers or Footers
221(1)
Underlaying Sections
221(4)
Analyzing with Cross-Tabs
225(26)
Creating a Cross-Tab Object
225(10)
Editing an Existing Cross-Tab
230(1)
Creative Use of Grouping and Formulas
231(4)
Multiple Rows, Columns, and Summarized Fields
235(4)
Reordering Fields in the Rows, Columns, or Summarized Field Boxes
238(1)
Customizing Cross-Tab Appearance
239(12)
The Style Tab
240(1)
The Customize Style Tab
241(4)
Labels or Legends with Cross-Tabs
245(2)
Conditionally Formatting Cross-Tabs
247(2)
Cross-Tab Virtual Page Formatting Options
249(2)
Creating Charts
251(32)
Types and Layouts of Charts
251(3)
Chart Type
252(1)
Chart Layout
253(1)
Creating Charts
254(20)
The Type Tab
255(1)
The Data Tab
256(10)
The Axes Tab
266(2)
The Options Tab
268(1)
The Color Highlight Tab
269(1)
The Text Tab
270(2)
Placing and Sizing Charts
272(1)
Modifying Existing Charts
273(1)
Zooming In and Out on Charts
274(1)
Drilling Down on Charts
274(1)
Finer Points of Chart Formatting
275(8)
Customizing Charts with Chart Options
275(8)
Creating Geographic Maps
283(14)
Different Map Types
283(2)
Adding a Map
285(5)
The Data Tab
285(5)
The Type Tab
290(1)
The Text Tab
290(1)
Drilling Down on Maps
290(1)
Changing the Map View
291(6)
The Map Navigator
291(1)
Resolving Data Mismatches
292(2)
Map Layers
294(3)
Using Subreports
297(20)
Unlinked Subreports
298(6)
Drilling Down on Subreports
302(2)
Linked Subreports
304(4)
Linking Based on Formula Fields
306(2)
Subreport Formatting with the Format Editor
308(1)
On-Demand Versus In-Place Subreports
309(2)
Passing Data Between Main Reports and Subreports
311(4)
Handling Empty Subreports
313(2)
Performance Considerations
315(2)
Interactive Reporting with Parameter Fields
317(28)
Creating a Parameter Field
319(4)
Responding to Parameter Field Prompts
320(1)
Data Type Considerations
321(2)
Using Parameter Fields in Record Selection
323(2)
Displaying Parameter Fields on the Report
325(1)
Creating Pick Lists
325(9)
Static Pick Lists
326(2)
Dynamic and Cascading Pick Lists
328(6)
Special Parameter Field Features
334(5)
Multiple Values
334(1)
Range Values
335(2)
Controlling Parameter Field Data Entry
337(2)
Conditional Formatting with Parameter Fields
339(2)
Highlighting Data Based on Parameter Fields
340(1)
Conditional Suppression Based on Parameter Fields
341(1)
Using Parameter Fields with Formulas
341(4)
Using a Parameter Field for Partial Text Matches
342(1)
Using a Parameter Field to Change Sorting or Grouping
343(1)
Using a Parameter Field to Control Top N Reporting
343(2)
Exporting Reports to Different Formats
345(12)
Exporting Reports to Office Applications
346(10)
Exporting to Different File Formats
346(4)
Exporting and Launching an Application
350(1)
Exporting to an ODBC Data Source
350(2)
Exporting to XML
352(4)
Sending Reports Electronically
356(1)
Reporting from SQL Databases
357(44)
Logging On to SQL Databases
358(11)
Direct Database Drivers
359(1)
ODBC
359(1)
OLE DB
360(1)
Choosing the Database
360(5)
Changing SQL Options
365(2)
Changing to a Different Database
367(1)
Adding Additional Tables to the Report
367(1)
Removing Unused Tables from the Report
368(1)
Linking Tables
369(13)
Database Expert Links Tab
370(4)
Using Multiple Database Types in the Same Report
374(2)
Join Types, Link Types, and Join Enforcement
376(6)
Viewing the SQL Query
382(2)
Crystal Reports SQL Commands
384(3)
Creating the SQL Command
384(3)
Using a SQL Command in a Report
387(1)
Using SQL Stored Procedures
387(3)
Choosing Stored Procedures
388(1)
Working with Stored Procedure Parameters
389(1)
Using SQL Expression Fields
390(4)
Creating SQL Expressions
390(4)
Grouping on the Database Server
394(4)
Enabling Server-Based Grouping
396(1)
What's Required to Use Server-Based Grouping
396(1)
Effects of Drill-Down
397(1)
Performance Considerations
398(3)
Let the Server Do the Work
398(1)
Use Indexed Fields
399(2)
Creating and Using Business Views
401(88)
Business Views Overview
402(2)
Business Views Objects
402(2)
Creating Business Views
404(57)
The Business View Manager
404(4)
Data Connection
408(6)
Dynamic Data Connection
414(4)
Data Foundation
418(27)
Business Element
445(11)
Business View
456(5)
Creating Business View-Based Pick Lists
461(9)
Publishing Crystal Reports with Pick Lists
462(4)
Creating Pick Lists in the Business View Manager
466(2)
Scheduling Pick Lists
468(2)
Navigating and Maintaining Business Views
470(11)
Object Integrity and References
470(2)
Exporting and Importing Business Views
472(3)
Using the Repository Explorer
475(6)
Using Business Views with Crystal Reports
481(8)
Row and Column Security
483(3)
Using Business View-Based Pick Lists in Reports
486(3)
Sharing Report Items with the Repository
489(22)
The Repository Defined
489(5)
The New Repository Explorer Enterprise Items Category
491(1)
The Repository Explorer Repository Items Category
492(2)
Adding To/Updating the Repository
494(6)
Creating Folders
495(1)
Adding and Deleting Objects
496(4)
Adding Repository Items to Reports
500(2)
Text Objects or Bitmap Graphics
500(1)
Custom Functions
500(1)
SQL Commands and Business Views
501(1)
Changing Repository Items on Your Report
502(2)
Updating Repository Versions of Objects
504(1)
Controlling Repository Rights
504(7)
Controlling Rights at the Central Management Server Level
506(2)
Controlling Rights at the Folder and Object Level
508(3)
Accommodating Database Changes and Field Mapping
511(8)
Recognizing Database Changes
511(6)
Verify Database
512(1)
Using Set Datasource Location
512(5)
Mapping Old Fields to New Names
517(2)
Reporting from OLAP Cubes
519(22)
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(5)
The OLAP Worksheet
539(2)
Reporting from Proprietary Data Types
541(26)
Reporting from Microsoft Outlook
544(2)
Reporting from the File System Data
546(2)
Reporting from the Windows 2000/XP/2003 Event Log
548(3)
Reporting from Web Server Logs
551(3)
Crystal Reporting with XML
554(6)
XML ODBC Driver
555(3)
New XML Native Driver
558(2)
BusinessObjects Enterprise Universes
560(7)
Part II Crystal Reports XI on the Web
Crystal Reports Web Alternatives
567(16)
Exporting to Static HTML
568(7)
Hyperlink Capabilities
573(2)
Cascading Style Sheet Support
575(1)
Navigating and Viewing Report Parts
575(8)
Using Navigation
576(2)
Displaying Report Parts
578(5)
Introduction to Crystal Reports Server
583(14)
Crystal Reports Server Defined
583(1)
The Two-Tier Web Reporting Method
584(1)
The Multitier Reporting Method
585(1)
Crystal Reports Server Licensing
586(1)
Crystal Reports Server New Features
587(1)
Dynamic Prompts and Cascading Lists of Values
587(1)
Categories
587(1)
Discussions
588(1)
Info View
588(1)
Universes
588(1)
Crystal Reports Server Architecture
588(9)
End-User Components for Reporting
589(3)
Server and Maintenance Components for Administrators
592(5)
Using Info View
597(56)
Connecting to Info View
597(3)
CRS Security Model
600(1)
Folders, Categories, Inbox, Objects, and Instances
600(12)
Info View Hierarchy
600(3)
Objects and Instances
603(2)
Viewing Reports: On Demand or Instance
605(1)
Viewing Third-Party Objects
606(1)
Setting Info View Preferences
607(5)
Controlling, Printing, and Exporting Reports
612(9)
Supplying Database Credentials and Parameters
613(2)
Navigating the Report Viewers
615(5)
Exporting and E-Mailing Reports
620(1)
Printing Reports on Your Local Printer
620(1)
Scheduling Objects
621(10)
Scheduling Options
622(7)
Scheduling Reports Containing Alerts
629(1)
Rescheduling Existing Instances
630(1)
Using Discussions
631(3)
Modifying or Deleting Existing Messages
633(1)
Organizing Info View
634(17)
Working with Folders and Categories
634(6)
Organizing Objects and Instances
640(7)
The My Info View Dashboard
647(4)
Sending Objects and Instances to Destinations
651(2)
Administering Crystal Reports Server
653(84)
Crystal Reports Server Architecture
654(5)
Central Management Server (CMS)
654(1)
File Repository Servers
655(1)
Crystal Reports Page Server
656(1)
Crystal Reports Job Server and Report Application Server
656(1)
Program Job Server
657(1)
Destination Job Server
657(1)
Crystal Reports Cache Server
657(1)
Event Server
658(1)
List of Values Job Server
658(1)
Managing Users and Groups
659(12)
Introducing the Administration Launchpad and Central Management Console
659(2)
Adding, Modifying, and Deleting User Accounts
661(2)
Adding Groups
663(4)
Placing Users in Groups
667(3)
Password Settings
670(1)
Integrating Crystal Reports Server with Existing Security Environments
671(5)
Windows NT
671(2)
Windows Active Directory
673(2)
LDAP
675(1)
Controlling Access Using Rights
676(5)
Setting Rights
677(4)
Creating Folders and Adding Objects
681(14)
Creating Folders and Subfolders
681(1)
Adding Reports
682(9)
Adding Program Objects
691(3)
Adding Third-Party Objects
694(1)
Working with Categories
695(3)
Creating Categories
696(1)
Adding Reports and Other Objects to Categories
697(1)
Defining Output Destinations
698(4)
Using Inboxes
702(2)
Creating Calendars
704(1)
Using Events
705(5)
Scheduling with Events in the CMC
708(2)
Configuring Success/Failure/Alert Notification
710(4)
Success/Failure Notification
711(1)
Alert Notification
712(2)
Other General Administrative Tasks
714(6)
Adding Additional Licenses
714(1)
Viewing Server Metrics
715(2)
Setting Instance Limits
717(2)
Specifying Default Info View Settings
719(1)
Managing Servers
720(17)
Enabling Servers
721(1)
Managing the CMS
722(8)
Managing Other Servers
730(2)
Server Groups
732(1)
Universes and Universe Connections
733(4)
Part III Custom Web and Windows Reporting Applications
Integrating Crystal Reports with ASP and Visual Basic
737(72)
Developing ASP Web Applications with the RDC
738(7)
Active Server Pages and VBScript Overview
740(1)
Preparing for RDC-Based ASP Applications
740(1)
The RDC Object Model in ASPs
741(4)
RDC Report Viewers
745(2)
Choosing and Customizing RDC Report Viewers
745(1)
What Is CleanUp.ASP?
746(1)
Developing Visual Basic Windows Applications with the RDC
747(62)
RDC Object Model Architecture
747(5)
Adding the RDC to Your Project
752(8)
The RDC Object Model
760(3)
An Introduction to the RDC Object Model
763(3)
Providing Database Logon Credentials
766(1)
Controlling Record Selection
767(2)
Setting Formulas
769(2)
Changing Text Objects at Run Time
771(1)
Passing Parameter-Field Values
772(1)
Manipulating Report Groups
773(2)
Conditional Formatting and Formatting Sections
775(4)
Choosing Output Destinations
779(2)
Changing the Data Source at Run Time
781(3)
Customizing the Report Viewer
784(6)
Error Handling
790(1)
Other RDC Properties and Methods
790(5)
Creating New Reports at Run Time
795(7)
Distributing RDC Windows Applications
802(7)
Crystal Reports with Visual Studio .NET
809(36)
Windows and Web Integration with Visual Studio .NET
809(17)
Crystal/VS.NET Bundle Options
809(3)
Windows Forms Viewer and Web Forms Viewer
812(6)
Integrated Report Designer
818(8)
VS.NET Report Customization Object Models
826(12)
Run-Time Customization with the Crystal Windows or Web Forms Viewer
827(3)
Report Viewer Events
830(2)
Run-Time Customization with the Crystal Reports Engine (ReportDocument)
832(5)
Exporting Reports in Windows and Web Applications
837(1)
Crystal Reports as XML Web Services
838(5)
Creating a Web Service
838(1)
Consuming Web Service Reports in a Web Application
839(3)
Setting Viewer Properties with Consumed Web Services
842(1)
Distributing Crystal Reports .NET and ASP.NET Applications
843(2)
Windows Applications
843(1)
Web Applications
843(1)
General Concepts
843(2)
Appendix Formula Language Reference
845(146)
Functions: Additional Functions
845(12)
ByteToText
846(1)
DateTimeTo2000
846(1)
DateTimeToDate
846(1)
DateTimeToSeconds
846(1)
DateTimeToTime
847(1)
DateTo2000
847(1)
DTSTo2000
847(1)
DTSToDate
847(1)
DTSToDateTime
848(1)
DTSToSeconds
848(1)
DTSToTimeField
848(1)
DTSToTimeString
848(1)
EventNumber
848(1)
ExchGetld
849(1)
ExchGetOrganization
849(1)
ExchGetPath
849(1)
ExchGetSite
850(1)
ExtractString
850(1)
FRAccRecTurnover
850(1)
FRCashFlowVsTotalDebt
850(1)
FRCurrentRatio
851(1)
FRDebtEquityRatio
851(1)
FRDividendYield
851(1)
FREarningsPerCommonShare
852(1)
FREquityVsTotalAssets
852(1)
FRGrossProfitMargin
852(1)
FRInterestCoverage
852(1)
FRInventoryTurnover
853(1)
FRNetProfitMargin
853(1)
FROperatingProfitMargin
853(1)
FRPriceEarningsRatio
854(1)
FRQuickRatio
854(1)
FRReturnOnCommonEquity
854(1)
FRReturnOnEquity
854(1)
FRReturnOnInvestedCapital
855(1)
FRReturnOnNetFixedAssets
855(1)
FRReturnOnTotalAssets
855(1)
LooksLike
856(1)
Now
856(1)
Picture
856(1)
Soundex
856(1)
Functions: Alerts
857(1)
AlertMessage
857(1)
AlertNames
857(1)
IsAlertEnabled
857(1)
IsAlertTriggered
858(1)
Functions: Arrays
858(4)
Average
858(1)
Count
858(1)
DistinctCount
859(1)
MakeArray
859(1)
Maximum
860(1)
Minimum
860(1)
PopulationStdDev
860(1)
Population Variance
860(1)
StdDev
861(1)
Sum
861(1)
UBound
861(1)
Variance
861(1)
Functions: Conditional Formatting
862(1)
Color
862(1)
CurrentFieldValue
862(1)
DefaultAttribute
862(1)
GridRowColumnValue
863(1)
Row Or Column Names
863(1)
Functions: Date and Time
863(13)
CurrentDate
863(1)
CurrentDateTime
864(1)
CurrentTime
864(1)
Date
864(1)
DateAdd
864(1)
DateDiff
864(1)
DatePart
865(1)
DateSerial
866(1)
DateTime
866(1)
DateTimeValue
866(2)
DateValue
868(1)
Day
868(1)
DayOfWeek
868(1)
Hour
869(1)
IsDate
869(1)
IsDateTime
870(1)
IsTime
870(1)
Minute
870(1)
Month
871(1)
MonthName
871(1)
Second
871(1)
ShiftDateTime
871(2)
Time
873(1)
Timer
873(1)
TimeSerial
873(1)
TimeValue
874(1)
WeekdayName
874(1)
Year
875(1)
Functions: Date Ranges
876(7)
Aged0To30Days
876(1)
Aged31To60Days
876(1)
Aged61To90Days
877(1)
AIIDatesFromToday
877(1)
AIIDatesFromTomorrow
877(1)
AIIDatesToToday
877(1)
AllDatesToYesterday
878(1)
Calendar1stHalf
878(1)
Calendar2ndHalf
878(1)
Calendar1stQtr
878(1)
Calendar2ndQtr
879(1)
Calendar3rdQtr
879(1)
Calendar4thQtr
879(1)
Last4WeeksToSun
879(1)
Last7Days
880(1)
LastFullMonth
880(1)
LastFullWeek
880(1)
LastYearMTD
880(1)
LastYearYTD
881(1)
MonthToDate
881(1)
Next30Days
881(1)
Next31To60Days
881(1)
Next61To90Days
881(1)
Next91To365Days
882(1)
Over90Days
882(1)
WeekToDateFromSun
882(1)
YearToDate
882(1)
Functions: Document Properties
883(5)
ContentLocale
883(1)
CurrentCEUserID
883(1)
CurrentCEUserName
883(1)
CurrentCEUserTimeZone
884(1)
DataDate
884(1)
DataTime
884(1)
DataTimeZone
885(1)
FileAuthor
885(1)
FileCreationDate
885(1)
FileName
885(1)
GroupingLevel
886(1)
ModificationDate
886(1)
ModificationTime
886(1)
PrintDate
886(1)
PrintTime
887(1)
PrintTimeZone
887(1)
ReportComments
887(1)
ReportTitle
887(1)
Functions: Evaluation Time
888(1)
BeforeReadingRecords
888(1)
EvaluateAfter
888(1)
WhilePrintingRecords
889(1)
WhileReadingRecords
889(1)
Functions: Financial
889(25)
ACCRINT
889(1)
ACCRINTM
890(1)
AmorDEGRC
890(1)
AmorLINC
891(1)
CoupDayBS
891(1)
CoupDays
892(1)
CoupDaysNC
892(1)
CoupNCD
893(1)
CoupNum
893(1)
CoupPCD
893(1)
CumIPMT
893(1)
CumPrinc
894(1)
Days360
894(1)
DB
895(1)
DDB
895(1)
DISC
895(1)
DollarDE
896(1)
DollarFR
896(1)
Duration
897(1)
Effect
897(1)
FV
897(1)
FVSchedule
898(1)
IntRate
898(1)
IPmt
899(1)
IRR
899(1)
ISPMT
900(1)
MDuration
900(1)
MIRR
900(1)
Nominal
901(1)
NPer
901(1)
NPV
902(1)
OddFPrice
902(1)
OddFYield
902(1)
OddLPrice
903(1)
OddLYield
904(1)
Pmt
904(1)
PPmt
905(1)
Price
906(1)
PriceDisc
906(1)
PriceMat
907(1)
PV
907(1)
Rate
908(1)
Received
909(1)
SLN
909(1)
SYD
909(1)
TBillEq
910(1)
TBillPrice
910(1)
TBillYield
910(1)
VDB
910(1)
XIRR
911(1)
XNPV
912(1)
YearFrac
912(1)
Yield
913(1)
YieldDisc
913(1)
YieldMat
914(1)
Functions: Math
914(6)
Abs
914(1)
Atn
914(1)
Ceiling
915(1)
Cos
915(1)
Exp
915(1)
Floor
916(1)
Int
916(1)
Log
916(1)
MRound
917(1)
Pi
917(1)
Remainder
917(1)
Rnd
918(1)
Round
918(1)
RoundUp
919(1)
Sgn
919(1)
Sin
919(1)
Sqr
920(1)
Tan
920(1)
Truncate
920(1)
Functions: Print State
920(5)
DrillDownGroupLevel
920(1)
GroupNumber
921(1)
GroupSelection
921(1)
HierarchyLevel
921(1)
InRepeatedGroupHeader
922(1)
IsNull
922(1)
Next (Crystal Syntax only)
922(1)
NextIsNull
923(1)
NextValue (Basic Syntax only)
923(1)
OnFirstRecord
923(1)
OnLastRecord
923(1)
PageNofM
923(1)
PageNumber
924(1)
Previous (Crystal Syntax only)
924(1)
PreviousIsNull
924(1)
PreviousValue (Basic Syntax only)
924(1)
RecordNumber
925(1)
RecordSelection
925(1)
TotalPageCount
925(1)
Functions: Programming Shortcuts
925(2)
Choose
925(1)
IIF
926(1)
Switch
926(1)
Functions: Ranges
927(1)
HasLowerBound
927(1)
HasUpperBound
927(1)
IncludesLowerBound
927(1)
IncludesUpperBound
928(1)
Functions: Strings
928(15)
AscW
928(1)
ChrW
928(1)
Filter
929(1)
InStr
929(1)
InStrRev
930(1)
Join
930(1)
Left
931(1)
Length
931(1)
LowerCase
931(1)
Mid
932(1)
NumericText
932(1)
ProperCase
932(1)
Replace
933(1)
ReplicateString
933(1)
Right
934(1)
Roman
934(1)
Space
934(1)
Split
934(1)
StrCmp
935(1)
StrReverse
936(1)
ToNumber
936(1)
ToText
936(3)
ToWords
939(1)
Trim
939(1)
TrimLeft
939(1)
TrimRight
940(1)
UpperCase
940(1)
URLDecode
940(1)
URLEncode
941(1)
Val
942(1)
Functions: Summary
943(19)
Average
943(1)
Correlation
943(1)
Count
944(1)
Covariance
945(1)
DistinctCount
946(1)
Maximum
946(1)
Median
947(1)
Minimum
947(1)
Mode
948(1)
NthLargest
949(1)
NthMostFrequent
949(1)
NthSmallest
950(1)
PercentOfAverage
951(1)
PercentOfCount
952(1)
PercentOfDistinctCount
953(1)
PercentOfMaximum
954(1)
PercentOfMinimum
955(1)
PercentOfSum
955(1)
PopulationStdDev
956(1)
Population Variance
957(1)
PthPercentile
958(1)
StdDev
958(1)
Sum
959(1)
Variance
960(1)
WeightedAverage
960(2)
Functions: Type Conversion
962(1)
CBool
962(1)
CCur
962(1)
CDate
962(1)
CDateTime
962(1)
CDbl
963(1)
CStr
963(1)
CTime
963(1)
Operators: Arithmetic
963(2)
Add (+)
963(1)
Divide (/)
963(1)
Exponentiate (^)
963(1)
Integer Divide (\)
964(1)
Modulus
964(1)
Multiply (*)
964(1)
Negate (-)
965(1)
Percent (%)
965(1)
Subtract (-)
965(1)
Operators: Array
965(2)
In
966(1)
Make Array
966(1)
Redim
966(1)
Redim Preserve
966(1)
Subscript ([ ])
967(1)
Operators: Boolean
967(3)
And
967(1)
Eqv (Logical equivalence)
968(1)
Imp (Logical implication)
968(1)
Not
968(1)
Or
969(1)
Xor (Logical exclusion)
969(1)
Operators: Comparisons
970(2)
Equal (=)
970(1)
Greater or Equal (>=)
970(1)
Greater Than (>)
970(1)
Less or Equal (<t=)
971(1)
Less Than (<)
971(1)
Not Equal (<>)
971(1)
Operators: Control Structures
972(4)
Do While
973
Exit For
972(1)
Exit While
973(1)
For
973(1)
If Then Else
974(1)
Option Loop
974(1)
Select Case
975(1)
While Do
975(1)
Operators: Conversion
976(1)
Currency ($)
976(1)
Operators: Other
976(2)
Assignment (:=)
977(1)
Comment (//)
977(1)
Date-time literal (#)
978(1)
Parentheses
978(1)
Operators: Pattern
978(1)
Like
978(1)
StartsWith
979(1)
Operators: Ranges
979(3)
Both End Points Excluded Range
979(1)
In Range
980(1)
Left End Point Excluded Range
980(1)
Make Range
980(1)
Right End Point Excluded Range
981(1)
UpFrom
981(1)
Up From But Not Including
981(1)
UpTo
982(1)
Up To But Not Including
982(1)
Operators: Scope
982(1)
Global
982(1)
Local
983(1)
Shared
983(1)
Operators: Strings
983(2)
Concatenate (& or +)
983(1)
In String
984(1)
Insert Empty String (``'')
984(1)
Subscript [ ]
985(1)
Operators: Variable Declarations
985(6)
Boolean Var
985(1)
Currency Var
986(1)
DateTimeVar
986(1)
DateVar
987(1)
NumberVar
987(1)
String Var
988(1)
TimeVar
988(3)
Index 991


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/97800715023446e.html
Märksõnad: