D


daily company information report, 5

DailyRecurrence class, 666

data

constraints, 74

denormalized, 81

duplication of, 75–76

filtering, 727–729

organizing, 70–80

relations, 76–80

retrieval of, 80–88

sorting, 87–88, 727–729

data caching. See caching

data definitions, 13–14

data exchange formats, 384, 402–405

.data extension, 280

data files, 121, 123

data model, 12

data providers

changing, 123–124

choosing, 121, 123–124

described, 19

.NET Framework, 123

data regions, 187–196

described, 14, 187

report objects, 583–589

data source credentials, 124, 475, 668

data source definition, 124

data source view, 699

data sources

changing, 123–124

choosing, 123–124

creating, 120–125, 697–699

described, 13–14, 122

nonshared, 124–125

shared. See shared data sources

types of, 13

viewing contents of, 515–516, 517

Data tab, 15

Data Transformation Services. See DTS

Database Connection page, 56–58

database queries. See queries

database servers.

See also servers

connections to, 169–170

naming, 56–57

DatabaseQueryTimeout setting, 544

databases, 69–113

AdventureWorks, 27

choosing for reports, 121, 123

data in. See data

entities, 74, 75

images in, 232, 233, 250

normalization, 75–76

organization, 70–80

queries. See queries

relations, 76–80

Report Server, 27

Report Server Temp DB, 27

structure, 70–88

data-driven subscriptions, 30, 498–505

DataElementCollection property, 596

DataElementName property, 596

DataElementOutput property, 596

DataElementStyle property, 597

DataInstanceElementOutput property, 597

DataInstanceName property, 597

DataLabel property, 597

DataRetrievalPlan class, 666

DataSchema property, 597

DataSetDefinition class, 667

DataSetName property, 188, 597–598

datasets

creating, 125–130, 160–161, 219–221, 696

described, 13–14, 129

names, 171, 188

shown in Datasets window, 16

stored procedures for, 301–303

Datasets window, 16

DataSource class, 668

DataSourceCredentials class, 668

DataSourceDefinition class, 668–669

DataSourceDefinitionOrReference class, 669

DataSourcePrompt class, 669–670

DataSourceReference class, 670

DataTransform property, 598

dates

logging, 551

specifying, 158, 160, 518

date/time attributes, 701–702

datetime data type, 160

Days in Maintenance Chart, 225–231

DaysOfWeekSelector class, 670

dbo abbreviation, 96

DDX queries, 14

debug database file (PDB), 571

debugger, Visual Studio, 571

debugging, 571

Delete Content option, 60

DELETE query, 94

DeleteItem method, 637

DeleteReportHistorySnapshot method, 637

DeleteRole method, 638

DeleteSchedule method, 638

DeleteSubscription method, 638

deleting

encrypted data, 540

folders, 446

history snapshots, 489–490

report items, 445

reports, 445

Delivery Analysis Report, 350–357

Delivery Status Report, 317–327

denormalization, 81

deployment

custom security extensions, 564–570

Report Model, 712

Report Server supporting items, 576

reports. See report deployment

Description property, 598

DescriptionLocID property, 598

descriptions

attributes, 709

entities, 709

folders, 411, 447

organizing reports with, 575

reports, 575

roles, 709

Design window, 15–16

DetailDataCollectionName property, 598

DetailDataElementName property, 598

DetailDataElementOutput property, 599

details grouping, 273–274

device information parameters, 519–525

DeviceInfo XML structure, 531

diagram pane, 126

Direction property, 599

directories, virtual, 37, 54–56

DisableDataSource method, 638

disk space requirements, 36

DisplayChartWith3-DVisualEffectproperty, 599

DisplayErrorLink setting, 544

DisplayLegendInsidePlotArea property, 599

DISTINCT query, 97–98, 161

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

Distributed Transaction Coordinator service. See MS DTC

DLL files, 433–434, 571

document maps, 392

documentation, 29

DocumentMapNode class, 670–671

domain groups, 576

domain logon, 551

domain user account, 41

downloading

Galactic database, 116

report definitions, 442–443

DrawGrid property, 599

drilldown capability

adding, 271–274

described, 574

Excel format and, 399

PDF format and, 394

subreports, 366, 368–370

TIFF format and, 392

drilldown reports, 136, 149, 368–370

drillthrough capability

described, 574

ListModelDrillthroughReports method, 651

LoadDrillthroughTarget method, 627

ModelDrillthroughReport class, 674

navigating between reports, 371–374

SetModelDrillthroughReports method, 658

drive mappings, 64

dsp prefix, 524–525

dsu prefix, 524–525

DTC. See MS DTC

DTS (Data Transformation Services), 507

DTS packages, 507

dynamic HTML, 8




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