Book description
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
Table of contents
- Cover
- Copyright
- About the Author
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
-
Part I: Designing Reports
- 1: Getting a Feel for Crystal Reports 2008
- 2: Sorting and Grouping
- 3: Analyzing with Advanced Selection Criteria
- 4: Using Formulas
- 5: Creating Custom Functions
- 6: Making Your Reports Visually Appealing
- 7: Using Sections and Areas
- 8: Analyzing with Cross-Tabs
- 9: Creating Charts
- 10: Creating Geographic Maps
- 11: Integration with Crystal Xcelsius and Flash
- 12: Using Subreports
- 13: Interactive Reporting with Parameter Fields
- 14: Exporting Reports to Different Formats
- 15: Reporting from SQL Databases
- 16: Reporting from Proprietary Data Types
- 17: Reporting from OLAP Cubes
- 18: Sharing Report Items with the Repository
- 19: Creating Crystal Reports Applications with Visual Studio .NET
-
Part II: Crystal Reports Enterprise Reporting
- 20: Crystal Reports Web Alternatives
- 21: Using InfoView
-
22: Administering Enterprise Reporting Systems
- Introducing the Central Management Console
- Managing Users and Groups
- Integrating BusinessObjects Enterprise with Existing Security Environments
- Managing Folders, Crystal Reports, and Third-Party Objects
- Working with Categories
- Controlling Access Using Rights
- BusinessObjects Enterprise Architecture
- Defining Output Destinations
- Creating Calendars
- Using Events
- Configuring Success/Failure/Alert Notification
- Other General Administrative Tasks
- Managing Servers
-
Appendix: Formula Language Reference
-
Functions: Additional Functions
- ByteToText
- DateTimeTo2000
- DateTimeToDate
- DateTimeToSeconds
- DateTimeToTime
- DateTo2000
- DTSTo2000
- DTSToDate
- DTSToDateTime
- DTSToSeconds
- DTSToTimeField
- DTSToTimeString
- EventNumber
- ExchGetId
- ExchGetOrganization
- ExchGetPath
- ExchGetSite
- ExtractString
- FRAccRecTurnover
- FRCashFlowVsTotalDebt
- FRCurrentRatio
- FRDebtEquityRatio
- FRDividendYield
- FREarningsPerCommonShare
- FREquityVsTotalAssets
- FRGrossProfitMargin
- FRInterestCoverage
- FRInventoryTurnover
- FRNetProfitMargin
- FROperatingProfitMargin
- FRPriceEarningsRatio
- FRQuickRatio
- FRReturnOnCommonEquity
- FRReturnOnEquity
- FRReturnOnInvestedCapital
- FRReturnOnNetFixedAssets
- FRReturnOnTotalAssets
- LooksLike
- Now
- Picture
- Soundex
- Functions: Alerts
- Functions: Arrays
- Functions: Conditional Formatting
- Functions: Date and Time
-
Functions: Date Ranges
- Aged0To30Days
- Aged31To60Days
- Aged61To90Days
- AllDatesFromToday
- AllDatesFromTomorrow
- AllDatesToToday
- AllDatesToYesterday
- Calendar1stHalf
- Calendar2ndHalf
- Calendar1stQtr
- Calendar2ndQtr
- Calendar3rdQtr
- Calendar4thQtr
- Last4WeeksToSun
- Last7Days
- LastFullMonth
- LastFullWeek
- LastYearMTD
- LastYearYTD
- MonthToDate
- Next30Days
- Next31To60Days
- Next61To90Days
- Next91To365Days
- Over90Days
- WeekToDateFromSun
- YearToDate
- Functions: Document Properties
- Functions: Evaluation Time
-
Functions: Financial
- ACCRINT
- ACCRINTM
- AmorDEGRC
- AmorLINC
- CoupDayBS
- CoupDays
- CoupDaysNC
- CoupNCD
- CoupNum
- CoupPCD
- CumIPMT
- CumPrinc
- Days360
- DB
- DDB
- DISC
- DollarDE
- DollarFR
- Duration
- Effect
- FV
- FVSchedule
- IntRate
- IPmt
- IRR
- ISPMT
- MDuration
- MIRR
- Nominal
- NPer
- NPV
- OddFPrice
- OddFYield
- OddLPrice
- OddLYield
- Pmt
- PPmt
- Price
- PriceDisc
- PriceMat
- PV
- Rate
- Received
- SLN
- SYD
- TBillEq
- TBillPrice
- TBillYield
- VDB
- XIRR
- XNPV
- YearFrac
- Yield
- YieldDisc
- YieldMat
- Functions: Grid Value
- Functions: Math
-
Functions: Print State
- CountHierarchicalChildren
- CurrentPageOrientation
- DrillDownGroupLevel
- GroupNumber
- GroupSelection
- HasValue
- HierarchyLevel
- InRepeatedGroupHeader
- IsNull
- Next (Crystal Syntax only)
- NextIsNull
- NextValue (Basic Syntax only)
- OnFirstRecord
- OnLastRecord
- PageNofM
- PageNumber
- Previous (Crystal Syntax only)
- PreviousIsNull
- PreviousValue (Basic Syntax only)
- RecordNumber
- RecordSelection
- TotalPageCount
- Functions: Programming Shortcuts
- Functions: Ranges
- Functions: Strings
-
Functions: Summary
- Average
- Correlation
- Count
- Covariance
- DistinctCount
- Maximum
- Median
- Minimum
- Mode
- NthLargest
- NthMostFrequent
- NthSmallest
- PercentOfAverage
- PercentOfCount
- PercentOfDistinctCount
- PercentOfMaximum
- PercentOfMinimum
- PercentOfSum
- PopulationStdDev
- PopulationVariance
- PthPercentile
- StdDev
- Sum
- Variance
- WeightedAverage
- Functions: Type Conversion
- Functions: Xcelsius
- Operators: Arithmetic
- Operators: Array
- Operators: Boolean
- Operators: Comparisons
- Operators: Control Structures
- Operators: Conversion
- Operators: Other
- Operators: Pattern
- Operators: Ranges
- Operators: Scope
- Operators: Strings
- Operators: Variable Declarations
-
Functions: Additional Functions
- Index
Product information
- Title: Crystal Reports 2008: The Complete Reference
- Author(s):
- Release date: August 2008
- Publisher(s): McGraw-Hill
- ISBN: 9780071590990
You might also like
video
Crystal Reports 2008 Advanced
In this Advanced Crystal Reports 2008 training video, expert author Guy Vaccaro picks up where he …
video
Crystal Reports 2008 Fundamentals
Crystal Reports 2008 is the market leading report writing package that allows users to create custom …
video
Advanced Crystal Reports 2011
In this Advanced Crystal Reports 2011 training course, expert trainer and author Guy Vaccaro covers advanced …
video
Crystal Reports 2011
In this SAP Crystal Reports 2011 Training Video, veteran trainer Guy Vaccaro teaches you how to …