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

IDE (integrated development environment), 11

identifying field, 701

IIF() function, 286–288

IIS (Internet Information Services)

installation issues, 27–28, 37, 64

restarting, 570

version, 36

iisreset utility, 570

image files, 237

image format, 520, 523

Image item, 588

Image Wizard, 258

images

background, 232

in database, 232, 233, 250

embedded, 232, 241–243, 245

external, 430–431

modifying, 232, 258

obtained through Internet, 233

retrieving from database, 232

sharing, 232, 233

storage of, 232

updating, 232

uploading, 430–431

URLs for, 233

importing Access reports, 379–381

IncludeGroupFooter property, 603

IncludeGroupHeader property, 603

infinity sign, 90

information. See business intelligence

inherited role assignments, 458–459

InheritModelItemParentSecurity method, 650

InheritParentSecurity method, 650

Initialization page, 60, 61

InitialToggleState property, 603

inner joins, 81–82, 100, 102

INSERT query, 94

installation errors, 64

installation log file, 65

Installation Wizard, 43–52

InstallationID setting, 543

installing Reporting Services, 24–65

administrative rights, 63–64

common problems, 63–65

considerations for, 36–42

database server installation, 31, 37, 44–46

disk space requirements, 36

distributed installation, 32–33, 37, 47–48

editions available, 30–35

e-mail server issues, 37–38

encryption option, 38

full installation, 30, 44, 45

hardware requirements, 35–36

IIS Server issues, 27–28, 37, 64

Instance Name page, 48–49

login account setup during, 39–42

memory requirements, 36

modifying configuration settings, 52–63

preparation for, 24–42

procedure for, 42–63

recovering installations, 541

report author installation, 32, 46–47

Report Server Installation Options page, 50–52

Service Account page, 49–50

software requirements, 36

types of installations, 30–35

web farm installation, 33–35, 47–48

installing SQL Server, 26, 42–52

Instance Name page, 48–49

Instance Selection dialog box, 52–53

InstanceID setting, 543

InstanceName setting, 543

instances

cached, 475

Report Server, 52–53

Report Viewer, 532–533

integrated development environment (IDE), 11

Integration Services package, 551

interactive sorting, 288–291

interactive table report, 136–150

InteractiveSize property, 603

Internet.

See also URLs;

Web

images obtained through, 233

report delivery via, 9

Internet Explorer, 400, 411

Internet Information Services (IIS)

installation issues, 27–28, 37, 64

restarting, 570

version, 36

inventory reports, 5, 9

invoice batches, 150–164

Invoice Detail table, 73

Invoice Header table, 73

Invoice Report, 366–370

Invoice-Batch Number Report, 150–156

IsEventService setting, 545

IsNotificationService setting, 545

ISNULL() function, 108–109

IsSchedulingService setting, 545

IsValidPrincipalName method, 560

IsWebServiceEnabled setting, 547

IsWindowsServiceEnabled setting, 546

item-level role definitions, 509

ItemNameSpaceHeader class, 673

ItemNamespaceHeaderValue property, 632