MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))

faxes, viewing, 389–390

Feature Selection page, 43–48, 64

Field class, 673

FIELD LIST

calculations and, 107–109

constant values in, 106–107

GROUP BY clause and, 110–112

overview, 95–99

fields.

See also attributes;

columns

calculated, 106–109

constant, 106–109

identifying, 99

names, 102, 505

purpose of, 701, 718

Report Builder, 718–720

vs. columns, 73

file share delivery option, 492

files

configuration. See configuration files

data, 121, 123

DLL, 433–434, 571

Excel, 397

HTML, 400, 526

image, 237

log. See log files

PDF. See PDF files

RDL, 421, 442–443, 688

TIFF, 389–392, 449–450

XML, 403

FileShareStorageLocation setting, 546

filter expressions, 308

filtering data, 727–729

filtering tables, 307–308

Filters property, 600

Find Function, 447, 448–449

finding items

with Find Function, 447, 448–449

FindItems method, 639

on Report Manager website, 20

reports, 447–448

with Search function, 447–448

SearchCondition class, 683

text within reports, 447, 448–449

FindItems method, 639

FireEvent method, 639–640

first match code group, 434

FixedHeader property, 600

floating headers, 288–291

FlushCache method, 640

folders

adding with Report Manager, 412–413

common, 467

created through My Reports option, 507–508

creating, 119–120

creating while deploying, 416

deleting, 446

deploying reports to, 419, 467

descriptions, 411, 447

hiding/showing contents, 413, 425–427, 576

log file, 550–551

managing items in, 444–447

moving items between, 445–446

My Reports, 507–508

names, 119–120, 410, 413, 447

navigating, 413

nested, 458

new content in, 413

organizing items in, 20, 457, 575, 706–707

overview, 410–413

renaming, 446–447

Reports, 17

role assignments for, 457–458

security of, 21, 575

Shared Data Sources, 17

Users Folders, 507–508

viewing contents of, 515–516, 517

Font property, 181, 600–601

fonts

labels, 605

PDF files and, 394

previewing, 388–389

size, 180–181

styles, 180–181

footers, 260–264, 582

foreign key, 76

Format property, 601

formats

caching and, 475–476

CSV, 402, 520

Excel. See Excel format

for exporting reports, 385, 387–401

HTML. See HTML format

image, 520, 523

MHTML, 394, 520, 524

PDF. See PDF format

for printing, 8–9

TIFF. See TIFF format

formatting.

See also layouts

margins, 262, 299, 608

reports with Report Builder, 727–729

text boxes, 185

X-AxisFormatting property, 622

Y AxisFormatting property, 622

forms security, 556

FormsSecurity project, 556–564

forward slash (/), 515

FROM clause, 95–96

Fuel Price Chart, 211–221

full installation, 30, 44, 45

Full Trust rights, 568

FullTrust permission, 436

functions

aggregate, 110–112, 279–280

AVG(), 111

Change Key, 59

COUNT(), 111

CStr(), 308

IIF(), 286–288

ISNULL(), 108–109

MAX(), 111, 177

MIN(), 111,201

SUM(), 111, 230–231, 274–279