Datasheet
sections
(continued)
identifying 67
inserting 192
making read-only 240
merging two related 193
moving 193
multiple in report 196
Page Header 65
Report Header 65
resizing 195
resizing to delete white space 253
splitting 194
suppressing to delete white space
253
security 626
defining 602
global lock feature 603
migrating from client-independent
model 603
preserving existing restrictions 603
row-level restrictions 610
table-level restrictions 603
Security Definition Editor
description 602
SELECT clause 513
Select Expert 130, 153
and Formula Editor 132
for group selection 153
selecting 565
ABAP functions 592
ABAP queries 585
an SAP system 557
BW queries 565
cubes 565
drivers for reports 556
InfoSets 585
multiple objects 232
tables, views, functions, and
clusters 589
selection criteria 38
selection formulas 119, 453
and performance 119
parameter fields 453
range limit conditions 527
saved data 134
saved data selection formulas 134
troubleshooting 137
Separated Values (CSV), exporting to
380
Server connection type 621
server-side processing 116, 545
server, log on command 557, 620
settings, for connecting to BW 561
shapes, adding 248
Shockwave Flash Objects (SWF) 310
binding to an Xcelsius SWF 313
Shockwave Flash Objects (SWF)
(continued)
inserting in reports 312
Xcelsius 312
Siebel formatting, applying 626
Siebel Mobile Web Client 623
Siebel security 626
Smart Linking 530, 591
linking tables with multiple indexes
530
smart tags 408
snapping objects to guidelines 227
sort orders 143
ascending 143
descending 143
using parameter fields to set 485
sorting 125, 662
and performance 125
Bottom N 662
group 662
groups conditionally 150
OLAP grid 374
records 43
records within groups 151
reports 41
single fields 143
Top N 662
with SQL expressions 127
spacing between text-based objects
225
indenting lines 230
selecting the grid 226
SPRAS field 591
SQL 509
and Crystal Reports 512
database considerations when
linking 527
databases 527, 651
using 509
databases via ODBC 651
DBMS 511
join types 532
language 513
server-side grouping 547
stored procedures 118, 512
using expressions 124
SQL commands 515
SQL expression fields
for Case Logic 127
for performance 124
placing on reports 77
SQL Injection 515
SQL link types 532
SQL query, editing 512
SQL statements 513
DISTINCT clause 513
SQL statements
(continued)
FROM clause 513
GROUP BY clause 515
ORDER BY clause 514
SELECT clause 513
WHERE clause 514
SQL, viewing 347
standard deviation option, Ranged
map 286
standard group headers, creating 176
Standard Report Wizard 24
stock chart 271
stored procedures 512
and performance 118
subquery 355
building 355
defined 355
parameters 356
subreports 491
adding captions to 503
and accessibility 674, 682
and SQL databases 527
caution when using 113
creating on-demand 502
different views of same data 504
for performance 113
inserting 494
linked vs. unlinked 491
linking 114, 497
to data in primary reports 497
to main report without
modifying selection formula
499
manually updating 497
one-to-many vs. database links 492
previewing 495
re-importing 496
saving as primary report 496
updating linked reports 496
using 499
to combine unrelated reports
499
with unlinkable data 501
when to use 491
subtotal fields, charting on 275
subtotaling grouped data 171
summarized data, drilling down on 84
summarized group values, sorting 167
summarizing grouped data 166
summary fields, charting on 275
summary information, adding 34
summary reports, for usability 112
Sybase Adaptive Server 642
2011-05-16703
Index