|
Save Picture Preview option, 54, 54, 56, 342
saving
custom functions, 109–110, 110
formula code, 99, 100
reports, 4–5, 27, 31, 376
reports as templates, 347–348
subreports, 172, 177
scaling pictures, 72, 72
scheduling
in Automated Process Scheduler, 543
compiled reports, 403
report deployment, 381
scope (of variables), 103
SDKs (Software Developer Kits), Crystal Enterprise, 544
SDKs (Software Developer Kits), RAS, 559, 589, 591
Seagate Info, 553
Search Expert, using formulas in, 97–98, 97–98
Section Editor, 199, 199
sections, See also formatting formulas
defined, 207
in Design mode, 24, 24, 208–209, 208–209
Details section, 23, 23, 208, 208
field placement in, 36–37
Group Footer section, 23–24, 23
Group Header section
conditional formulas, 219
defined, 23–24
repeating on each page, 150, 150, 456
layout areas, 23, 23, 207–208, 208
looping through objects in, 469–470
looping through in reports, 471–472
options for, 370–371, 370
Page Footer section, 23, 23, 208, 208
Page Header section, 23, 23, 208, 208
in Preview mode, 24, 24
Report Footer section, 23, 23, 208, 208
Report Header section, 23, 23, 208, 208
Standard Report Wizard and, 208, 208
suppressing, 199, 199, 500
sections, customizing, 207–224
controlling spacing, 222–223, 222
hiding, 209–211, 209–211
using layout options, 209, 209, 211
overview of, 207, 224
using Section Expert
Color tab options, 220–221, 220–221
Common tab options, 212, 214–217, 216–218
conditional options, 218–221, 220–221
defined, 211
deleting sections, 213
Detail section formulas, 219–220
formula formatting icons, 212, 218
Group Header formulas, 219
inserting sections, 212–213, 212–213
moving sections, 213
opening, 209, 211, 212
overview of, 93, 95
Page Header formulas, 218–219
resizing sections, 222–223, 222
using submenu options
Arrange Lines, 209, 223
Delete Last Line, 209, 223
Don’t Suppress, 209–210, 209
Fit Section, 209, 223
Hide (Drill-Down OK), 209–211, 210–211
Insert Line, 209, 223
Insert Section Below, 209, 213
overview of, 209, 209
Select All Section Objects, 209, 223–224, 223–224
Show Short Section Names, 209, 210, 211
Suppress (No Drill-Down), 210
Sections objects (in RDC), 451
security
for Crystal reports as web services, 531
for databases, 230
permissions, repository and, 143
for stored procedures, 291
Select All Section Objects option, 209, 223–224, 223–224
Select Distinct Records option, 293, 295
Select Expert, See also data retrieval; SQL
AND and OR clauses, 184
group selection formulas, 186, 186
opening, 180, 180
overview of, 179–180
record selection formulas, 185, 185
WHERE clauses
comparison operators, 181–182, 181–182, 192, 192, 281
data types and, 183
Formula Editor and, 183–184
for multiple conditions, 184–185, 184
overview of, 180
parameter fields, 191–193, 191–193
viewing results of, 184–185, 185
warning, 182
SELECT statements, See also SQL
keywords and, 279–280, 280, 282–284, 283
overview of, 179–180, 279, 280
WHERE clauses and, 281–282, 282
Select statements in Crystal, 115–116
selection formulas, See also formulas
changing criteria, 532
defined, 97
group selection formulas
changing, 457–459, 457, 459
coding, 156–157, 157, 186, 186
defined, 156
displaying in reports, 158, 158
processing, 359
record selection formulas
changing in ASPs, 493–494, 494
changing in Windows applications, 457–459, 457, 459
editing, 185, 185
modifying, 403, 403
syntax, 115
sequencing fields, 14, 14
server-based record selection, 355–356
server-side caching, 558
servers, See also client/server; RAS; web servers
adding OLAP servers, 329, 330
Automation Server (in RDC), 444, 449–450, 450, 483
in Crystal Enterprise, 536, 537, 542–544
defined, 276
Log On or Off Server option, 293, 294
Perform Grouping On Server option, 293, 295
Report Engine Automation Server, 410
SQL, connection information, 493
supported by Crystal Enterprise, 545
service providers (OLE DB), 255
Set Datasource Location option, 293–294, 294, 385, 385
Setup and Deployment Projects, 509–510, 509–510
shared network drives, deploying reports to, 394, 396
sharing variables, 175–177, 176
Show Hidden Sections option, 209, 209
Show Short Section Names option, 209, 210, 211
Show SQL Query option, 185, 185, 293, 295
sigma symbol (S) in Summarized Fields, 18, 18
sizing
cross-tab cells, 322
fields, 368
objects, 27, 27
sections, 222–223, 222
slices, 339, 339, See also OLAP
SOAP (Simple Object Access Protocol), 412, 413, 527, 528
Software Developer Kits. See SDKs
Solution Explorer, 502, 502, 509–510, 509–510
sorting grouped data, See also groups
changing sort criteria, 461–463
options for, 371
order in, 15, 15, 43–47, 44–46, 149–150
overview of, 148, 148
in processing reports, 357, 359
records in, 47–48, 48
summarized groups, 162–164, 162–164
sorting trees, 99, 101
source code, 421
spacing
fonts, 62, 62
in paragraphs, 63, 63
in sections, 222–223, 222
special fields
adding to reports, 54–55, 55
defined, 34
for grouped data, 158, 158
Specified Order (groups), 44, 44, 150
SQL commands
adding to repository, 135, 135–136
as data sources, 135, 136, 287–288, 287–288
defined, 287
modifying, 288, 288
parameterizing, 289–290, 290
using in reports, 141, 288, 289
as stored procedures
advantages, 290–291
as data sources, 291–293, 292
defined, 290
uses, 290
viewing in Field Explorer, 288, 289
SQL expression fields, See also formulas
creating, 286–287, 286
defined, 34, 97, 285–286, 286
functions/operators, 128, 128
using, 287
SQL queries, See also data source connections
building, 261–262, 261–262
as data sources, 262, 263
in Database Expert, 263
running, 262, 263
viewing, 185, 185, 293, 295
SQL (Structured Query Language), 273–295
built-in functions for column data, 282
database types and
client/server databases, 267, 274, 276–277
overview of, 274
PC databases, 274–276, 275–276
SQL-capable databases, 277–278, 278
database utilities, 292–293, 293–295
defined, 278–279
keywords
DISTINCT keyword, 279–281, 280, 284
for grouping/sorting, 282, 283, 284
for joins, 283, 284
listed, 284
ODBC and, 278, 278, 285
overview of, 273
retrieving data with SELECT statements, See also Select Expert
keywords and, 282–284, 283
overview of, 279, 280
WHERE clauses and, 281–282, 282
SQL server connection information, 493
standards, 277
vendor-specific dialects, 277–278, 278
views (as data sources), 293
stacks, function call, 88, 129
stand-alone programs, 420–422, 421, 426–428
Standard Report Creation Wizard, See also building reports
creating subreports, 168–169, 169
Data dialog, 6–12, 6, 8–11
defined, 5, 5–6
Fields dialog, 12–14, 12–14
Grouping dialog, 14–16, 14–15
sections and, 208, 208
Summaries dialog, 16–18, 16–18
Templates dialog, 349, 349
Standard toolbar, 41, 41
static data deployment. See deploying
static linking, 423
stock charts, 301
stored procedures. See SQL commands
storing
data, in report processing, 358
databases, 229
report templates, 343, 343
Strings functions (built-in), 605–606
Styles options (cross-tabs), 322–324, 323–324
subreports, 168–177
accessing as full reports, 471
creating, 168–169, 169
data sources, 174–175
defined, 168
editing, 172–173, 173
formatting, 171–172, 171, 173–174, 174
in-place subreports, 170
limitations, 177, 177
linked subreports, 169–170, 170
menu options, 171–172, 171
naming, 173
on-demand subreports
defined, 169, 171
toggling between in-place and, 173, 174
warning, 177
placement of, 171
processing, 360
saving, 172, 177
sharing variables with main reports, 175–177, 176
suppressing, 470
unlinked subreports, 169
subroutines, 426–427, 428
summarizing data, 159–168, See also charts; cross-tabs; grouping; maps
creating summaries
grand totals, 162, 164
overview of, 159, 159
and placing in reports, 49, 49, 161, 162
subtotals, 162, 164
types of, 159–161, 159
and viewing, 49–50, 50
and using Group Sort Expert
Include Others option, 162, 164, 164
Include ties option, 162–163, 163
overview of, 162, 162
problem with, 164
overview of, 147, 178
Report Part Viewer and, 74–75, 75
with running total fields
creating, 166–167, 166
defined, 164–165
processing, 359
records evaluated by, 168
using, 167, 167
when to use, 165
in Standard Report Wizard, 16–18, 16–18
techniques for, 48, 48
Summary area in Formula Expert, 108, 108
Summary functions (built-in), 601–602
summary report information
accessing outside Crystal, 55–56, 56
adding to reports, 54–55, 55
creating, 54, 54
defined, 54
Save Preview Picture option, 54, 54, 56
statistics, 55
template information, 344, 344
Suppress Blank Section option, 212, 214, 216
Suppress If Duplicated option, 58, 60, 195, 196
Suppress If Embedded Field Blank Lines option, 58, 60, 197–198, 198
Suppress If Zero option, 196, 197
Suppress (No Drill-Down) option (sections), 210, 212, 214, 215
Suppress option, Don’t, (sections), 209, 209–210
Suppress option (unconditional), 58, 59, 195, 196
suppressing data, See also data retrieval
coding formulas for, 195–196, 196
defined, 195
field objects, 58, 59, 195–197, 196–197
sections, 199, 199, 210, 212, 214, 215, 500
subreports, 470
text objects, 197–198, 198
symbols
colored arrow pentagons, 236, 237
green check marks, 34, 34
plus sign (+) in data sources list, 6, 7
sigma symbol (S) in Summarized Fields, 18, 18
vertical bar connector icon, 133, 133, 135, 136
syntax, See also code; formulas; SQL
checking, 100
choosing, 101–102, 102, 111
Crystal Syntax vs. Basic Syntax
changing at runtime, 467–468
choosing between, 99, 101–102, 102, 111
commenting/uncommenting, 102
control structures, 112–118, 113, 115, 117
database processing and, 128
functions, 118–119
iterations, 116–118, 117
operators, 105–107
overview of, 111–112
warning, 112
defined, 93
for setting RGB color values, 222
Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement | |
Conello © 2000-2003 Feedback |