P


package tracking services, GDS, 89–91

Padding property, 610–611

page breaks, 284, 400–401, 611

Page Footer item, 582

page footers, 260–264, 582

Page Header item, 583

page headers, 257–259, 264, 288–292, 583

PageBreakAtEnd property, 611

PageBreakAtStart property, 611

PageSize property, 611

Paid Invoices Report, 379–381

Palette property, 611

ParameterFieldReference class, 677

Parameterized Invoice-Batch Number Report, 156–164

parameters

command, 516–517

device information, 519–525

hiding, 517–518

passing, 517–518

report, 156–164

response format, 518–519

Parameters property, 612

ParameterValue class, 677

ParameterValueOrFieldReference class, 677

parent elements, 688

Parent Group property, 612

Parent property, 612

parent tables, 76–77

parent-child relationship, 76–77

parent/subsidiary relations, 85–87

passwords

authentication, 552, 553

Connection Properties, 121–124

encrypted, 58–60, 540

prompting for credentials, 524–525

Report Model, 698–699

Reporting Services and, 451

validating, 556

verifying, 560

PauseSchedule method, 655

Payroll Checks Report, 338–344

PDB (debug database file), 571

PDF files

fonts and, 394

overview, 7

printing, 449–450

viewing, 392, 478

PDF format

advantages of, 7

device information parameters, 524, 525

drilldown functionality and, 394

exporting reports to, 392–394

features supported, 393–394

printing and, 8–9

uses for, 394

permission sets, 434–436

permissions

configuration files, 566

FullTrust, 436

GetModelItemPermissions method, 643–644

GetPermissions method, 644

GetSystemPermissions method, 649

.NET assemblies, 436

Nothing, 436

report execution, 436

persisting authentication, 553

personnel, GDS, 91–92

Perspective property, 612

perspectives, 709–712, 716

PHP, 6

pie charts, 222–225

pivot table reports. See matrix reports

place cards, 240–245

PlotAreaBorderAndLineStyle property, 612–613

PlotAreaFillStyle property, 613

PlotDataAsLine property, 613

plus sign (+), 136, 155, 156, 274, 277–278, 589

PointWidth property, 613

Policy class, 677

PolicyLevel setting, 546

PollingInterval setting, 545

populating reports

charts, 213–216

with List items, 205–207

tables, 307–308

Portable Document Format. See PDF

Position property, 613–614

PreAuthenticate property, 625, 632

PrepareQuery method, 655

presentation formats, 384, 387–401

Preview tab, 16, 133–135, 386–387

previews.

See also report display

data caching during, 280–309

fonts, 388–389

print, 386–387

reports, 133–135, 147–148, 386–387

templates, 262–264

primary keys, 74, 90

print preview, 386–387

printed documents, 399

printed presentation format, 399–400

printers, 8–9

printing

client-side, 450

Excel format and, 399

formats for, 8–9

HTML format and, 401, 449

options for, 449–450

PDF documents, 449–450

procedure for, 386–387

from Report Manager, 449–450

TIFF documents, 449–450

PrintOnFirstPage property, 614

PrintOnLastPage property, 614

privileges

administrative, 63–64

local administrator, 451–453

user, 563–564, 576

processor requirements, 35

ProcessRecycleOptions setting, 543

product key, 43

Production Manager, 5, 9

production schedule, 5

programming, 8

projects. See report projects

properties

Action, 589

Angle, 589

Author, 589

AutoRefresh, 589–590

BackgroundColor, 234, 238, 239, 590

BackgroundImage, 590

BatchHeaderValue, 631

Bookmark, 590

BorderColor, 238, 239, 592

BorderStyle, 239, 592

BorderWidth, 592–593

Calendar, 593

CanGrow, 593

CanShrink, 593

CellDataElementName, 593

CellDataElementOutput, 594

ChartAreaBorderAndLineStyle, 594

ChartAreaFillStyle, 594

Classes, 594–595

Clustered, 595

Color, 239, 595

Columns, 595

ColumnSpacing, 595

Credentials, 625, 631

CustomCode, 595

Cylinder, 596

DataElementCollection, 596

DataElementName, 596

DataElementOutput, 596

DataElementStyle, 597

DataInstanceElementOutput, 597

DataInstanceName, 597

DataLabel, 597

DataSchema, 597

DataSetName, 188, 597–598

DataTransform, 598

described, 16

Description, 598

DescriptionLocID, 598

DetailDataCollectionName, 598

DetailDataElementName, 598

DetailDataElementOutput, 599

Direction, 599

DisplayChartWith3-DVisualEffect, 599

DisplayLegendInsidePlotArea, 599

DrawGrid, 599

EmbeddedImages, 600

EnableClieExecutionLogging, 548

EnableClientPrinting, 548

EnableIntegratedSecurity, 548, 549

EnableMyReports, 548

EnableReportDesignClientDownload, 548

EndPoint, 600

ExecutionHeaderValue, 626

ExecutionLogDaysKept, 548

ExternalImageTimeout, 548

Filters, 600

FixedHeader, 600

Font, 181, 600–601

Format, 601

GridSpacing, 601

Grouping, 601

Grouping/Sorting, 601

GroupOn, 602

GroupsBeforeRowHeaders, 602

Height, 602

HideDuplicates, 602

HorizontalRotation, 602

IncludeGroupFooter, 603

IncludeGroupHeader, 603

InitialToggleState, 603

InteractiveSize, 603

ItemNamespaceHeaderValue, 632

JumpToBookmark, 603–604

JumpToReport, 604

JumpToReportParameters, 604

JumpToURL, 604

KeepTogether, 605

Label, 605

LabelFontStyle, 605

LabelLocID, 605–606

Language, 606

LayoutDirection, 606

LegendBorderAndLineStyle, 606

LegendFillStyle, 606

LegendFontStyle, 607

LegendLayout, 607

LegendPosition, 607

LineColor, 239, 607

LineHeight, 607

LineStyle, 608

Line Width, 608

LinkToChild, 608

Location, 608

Margins, 608

MarkerSize, 609

MarkerType, 609

MergeTransactions, 609

MIMEType, 609

MyReportsRole, 548

Name, 609

NoRows, 610

NumeralLanguage, 610

NumeralVariant, 610

Orthographic, 610

Padding, 610–611

PageBreakAtEnd, 611

PageBreakAtStart, 611

PageSize, 611

Palette, 611

Parameters, 612

Parent, 612

Parent Group, 612

Perspective, 612

PlotAreaBorderAndLineStyle, 612–613

PlotAreaFillStyle, 613

PlotDataAsLine, 613

PointWidth, 613

Position, 613–614

PreAuthenticate, 625, 632

PrintOnFirstPage, 614

PrintOnLastPage, 614

References, 614

RepeatFooterOnNewPage, 614

RepeatHeaderOnNewPage, 615

RepeatOnNewPage, 615

RepeatWith, 615

report objects, 589–622

ReportExecution2005, 626

ReportName, 615

ReportParameters, 615–616

ReportService2005, 631–632

SeriesLabel, 616

ServerInfoHeaderValue, 626, 632

SessionTimeout, 548

Shading, 616

ShowLegend, 616

ShowMarkers, 616

ShowPointLabels, 617

SiteName, 549

Size, 617

Sizing, 617

SnapshotCompression, 549

SnapToGrid, 617

Sorting, 618

Source, 618

“specified,” 664

Subtype, 618

system, 548–550, 649, 663

SystemReportTimeout, 549, 550

SystemSnapshotLimit, 549

TextAlign, 239–240, 618

TextDecoration, 618–619

Title, 619

TitleFontStyle, 619

ToolTip, 619

ToolTipLocID, 619

Type, 620

UnicodeBiDi, 620

UserSort, 620

UseSessionCookies, 549

Value, 186, 620

ValueLocID, 620

VerticalAlign, 239, 621

VerticalRotation, 621

Visibility, 621

WallThickness, 621

Width, 621

WritingMode, 245, 622

X-AxisFormatting, 622

Y AxisFormatting, 622

Properties window, 16

Property class, 678

property dialog boxes, 196

property elements, 688

Property Pages dialog box, 419–421

Publisher role, 455

pull technology, 491

push technology, 491, 492




Microsoft SQL Server 2005 Reporting Services
MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))
ISBN: 0735622507
EAN: 2147483647
Year: 2007
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net