Crystal Reports XI: The Complete Reference

by Peck, George

• ISBN13: 9780072262469
• ISBN10: 007226246X
• Edition: 1st
• Format: Paperback
• Copyright: 2005-11-09
• Publisher: McGraw-Hill Education

Summary

This best-seller has been fully updated for Crystal Reports XI (extreme insight) -- the first release of this leading report writing and analysis software with joint development 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

Author Biography

George Peck (Evergreen, CO) is a seasoned consultant and trainer, specializing in Crystal Reports, Crystal Enterprise, and their integration into custom Windows and web products. He has authored five best-selling editions of Crystal Reports: The Complete Reference.

Table of Contents

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