|
DAO (Data Access Objects), 254, 266, 267
data analysis types, 327
data, analyzing visually. See charts; cross-tabs; maps; OLAP
Data dialog in Standard Report Wizard, 6, 6, 10–11, 10–12
Data Explorer, 231
data output, refining
with Highlighting Expert
creating highlight conditions, 200–202, 200–201
defined, 200
viewing results, 202, 202
overview of, 199–200, 206
with report alerts
built-in functions, 205–206, 205
coding, 203–204, 203–204
defined, 203
running, 204, 204
viewing results, 204–205, 205
viewing triggered alerts, 204, 205
data retrieval, processing, 355–356
data retrieval, refining, 179–199, See also SELECT statements; SQL
overview of, 179, 206
using parameter fields
creating, 187–190, 187–189
data types and, 190
defined, 186
edit masks, 189–190
overview of, 186–187, 191
preventing user input errors, 189–190, 189
prompting for user data, 187–188, 188, 191–193, 191–193
in Select Expert, 191–193, 191–193
setting default values, 188–189, 189
user input screen, 193–195, 194
warning, 194
using Select Expert, See also SQL
AND and OR precedence, 184
comparison operators, 181–182, 181–182, 192, 192
data types and, 183
Formula Editor and, 183–184
group selection formulas, 186, 186
for multiple conditions, 184–185, 184
opening, 180, 180
overview of, 179–180
parameter fields, 191–193, 191–193
record selection formulas, 185, 185
warning, 182
WHERE clauses, 180–185, 181, 184–185, 191
suppressing data
coding formulas for, 195–196, 196
defined, 195
field objects, 195–197, 196–197
sections, 199, 199
text objects, 197–198, 198
data source connections, 245–272, See also Database Expert; SQL
changing connection strings, 492–493
Crystal data architecture and, 247–248, 247
to Crystal Dictionary files, 264–265, 264–265
to Crystal (SQL) queries, 261–263, 261–263
via DAO programming, 266, 267
using Database Expert, 246–247, 246
displaying information on, 472–473, 473
listed, 248
native connections, 259–261, 259
to OLAP data, 254, 257–258, 257–258
OLE DB connections
via ADO programming, 266, 267, 267
connection information, 255, 256
defined, 254, 255
versus ODBC, 254, 255, 256, 257
to OLAP data, 257–258, 257–258
providers, 255, 255
Open Database Connectivity
advantages, 249
configuring ODBC drivers, 250–252, 250–251
defined, 248, 254
layers, 248–249, 249
using ODBC drivers, 252–254, 252–254
via RDO programming, 267, 267
warning, 249
to XML data sources, 267–272, 268–271
PC database files, 265–266, 266
programmatic access, 266–267, 267
using Report Creation Wizard, 6–9, 6, 8–9
data source names (DSNs), 250, 250–252, 252
data sources, See also databases
categories of, 7
choosing, 6–7, 6
coding NoData event messages, 459–460
creating templates without, 345–347, 345–347
versus databases, 245
global options, 363–365, 364, 367, 367
plus sign (+) in list of, 6, 7
SQL commands as, 135, 136, 287–288, 287–288
SQL queries as, 262, 263
stored procedures as, 291–293, 292
for subreports, 174–175
switching
coding in RDC, 474
fixing link problems, 386, 386
mapping database fields, 386, 387
overview of, 294, 294, 385, 385
verifying databases, 387, 387
views as, 293
XML files as, 267–272, 268–271, 367, 367
Database Expert
context menus, 246
Create New Connection folder items, See also data source connections
Access/Excel (DAO), 266, 267
Crystal Dictionary, 265
Crystal Queries, 262, 263
Database Files, 266, 266, 275, 276
More Data Sources, 259–261, 259
ODBC (RDO), 252–254, 252–254, 257
OLAP, 258, 258
OLE DB (ADO), 256–257, 256
overview of, 7, 246, 247, 248
Current Connections folder, 7, 246, 247
versus Data Explorer, 231
Data tab, 6–7, 6, 10–12, 10–11, 231, 231
defined, 246, 246
Favorites folder, 7, 246, 247
History folder, 246, 246, 247
Links tab, 231, 232, 234–236, 238, 386, 386
opening, 246, 293, 294
Repository folder, 7, 246, 247
SQL commands in, 135, 136
Database menu, 292–293, 293–295
Database objects in RDC, 451
databases, 227–244, See also data sources; repository; SQL
client/server databases, 267, 274, 276–277
components, 9, 10
in Crystal Reports, 229–230, 229
versus data sources, 245
database fields (in records), See also fields
adding to reports, 32–36, 33–36
defined, 33, 228, 229
mapping, 386, 387
global options, 363–367, 364, 373
overview of, 227, 274
PC databases
accessing, 265–266, 266, 277
in Database Expert, 275, 276
defined, 274
standalone PC databases, 274–275, 275
workgroup PC databases, 275, 275
records (in tables)
defined, 229
distinct, selecting, 293, 295
evaluated by running total fields, 168
in groups, sorting, 47–48, 48
processing, 355–357
relational databases, 228, 228
SQL-capable databases, 277–278, 278
storage layer, 247, 247, 248
storing, 229
supported by Crystal Enterprise, 545
tables in
adding to reports, 9–12, 10–11
database schemas and, 230–231
defined, 228
indexes of, 229
normalization and, 230
reference tables, 240
in repository, 142–143, 142–143
tables, linking multiple, 243–244, 243
tables, linking two
creating links automatically, 236, 236
creating links manually, 235–236, 235
creating valid links, 233–235, 234
via field name matching, 232, 233
full outer joins, 243, 243
inner joins, 241–242, 242
via key matching, 232–233
left outer joins, 242, 242
Link Options button, 236, 238, 241
link types, 237–238, 238
linking to indexed fields, 236, 236, 237
using Links dialog, 231, 232–238, 232, 234–236, 238
option buttons, 232, 233
Order Links option, 236, 236
overview of, 244
queries workaround, 237
relationships based on, 238–240
right outer joins, 242, 243
types of joins, 240–243, 241–243
warning, 235
translation layer, 247–248, 247
verifying, 387, 387
date data
formatting, 64–66, 65
grouping on, 153, 153
Date functions (built-in), 606–609
DBMS (database management system), 228, 229
DCOM (Distributed Component Object Model), 520
debugging, 128
default value lists, creating, 188–189, 189
Define Named Group dialog, 44–46, 45
Delete Last Line option (sections), 209, 223
deleting, See also removing
column labels, 39
fields, 39, 43
formulas, 92, 93
groups, 47, 47, 154
labels, 39
repository objects, 134, 138
sections, 213
deploying reports, 379–405
choosing techniques for, 380–382
compiled reports
compiling reports, 397–398, 398
custom VB applications, 481–483, 482
defined, 396
distributing to user computers, 398–402, 399–401
installing on user computers, 401–402
Package & Deployment Wizard for, 481–483, 482
pros and cons, 396
record selection formulas, 403, 403
running, 402–403, 402–404
scheduling, 403
steps in, 396–397
testing, 404
troubleshooting, 405
utility, installing, 397, 397
viewing, 403, 404
warnings, 396, 399, 401
overview of, 379, 383, 405
real-time data deployment, See also web applications
e-mailing RPT files, 382, 383
.NET applications, 508–510, 509–510
overview of, 380, 382
scheduling, 381
size and, 381
static data deployment
archived reports, 381, 382
compiled reports, 396–405, 397–404
exporting to HTML format, 382, 390, 392–394, 392–393
exporting to other formats, 389–391, 391
overview of, 380, 382
printing or faxing, 380, 382
publishing to web servers, 394–396, 395
Report Bursting Indexes and, 384, 384
with saved data, 383–384, 384
to shared network drives, 394, 396
warnings, 383, 384
without saved data, 383
switching data sources and
fixing link problems, 386, 386
mapping database fields, 386, 387
overview of, 385, 385
verifying databases, 387, 387
updating repository when, 381, 388, 389
user requirements and, 380–382
Descending Order (group sorts), 44, 149
design environment. See configuring design environment
Design mode. See building reports
Design Time Control, 411
desktop applications. See .NET
Details section, See also sections
conditional formulas, 219–220
defined, 23, 23, 208, 208
developer documentation, See also help
Crystal Reports files, 585
Crystal Reports for Visual Studio .NET, 586–587, 587
online references, 588
Report Application Server files, 586
supported platforms, 587
Developers Help, 454, 454
developing applications. See application development; ASP; .NET;
programming; RDC
development languages, 413–414, See also code; Java; .NET; VB
DHTML, hyperlinks and, 75, 75
direct-access databases. See PC databases
discrete values, 87
Display String option, 58, 60
Distributed Component Object Model (DCOM), 520
Distribution Expert, See also deploying reports, compiled
defined, 398
Distribution tab, 401, 401
Options tab, 399–400, 399, 400
starting, 398
Third Party Dlls tab, 400–401, 400
warning, 399
DLLs (dynamic link libraries), See also OOP
as API interface, 429
in compiled reports, 399–400, 400, 405
creating, 428–429
creating objects in, 429–430
defined, 247–248, 424–425, 424–426
fixing link problems, 385–386, 386
functions in, 426–429
native driver DLLs, 259–261, 259
problems, 429
stand-alone programs and, 426–428
subroutines in, 426–427, 428
Do loops, 117–118
docking Field Explorer, 33, 33
Document Properties dialog, 54–55, 54, 344, 344
Document Properties functions (built-in), 600
documentation. See developer documentation; help
Don’t Suppress option (sections), 209, 209–210
dot density maps, 316, 317
doughnut charts, 300
drawing boxes, 26, 26, See also graphic objects
Drill-Down OK option, 209, 210–211, 214, 215
Drop Shadow option (borders), 61, 61
DSNs (data source names), See also data sources
defined, 250
File DSNs, 251
setting up, 252, 252
System DSNs, 250, 250, 251
DTDs (Document Type Definitions), 271–272, 525
dynamic link libraries. See DLLs
Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement | |
Conello © 2000-2003 Feedback |