Index_D


D

Data Association page, properties for, 464

data definition, components of, 12–13

data exchange formats

CVS (Comma-Separated Values), 367

examples of, 348

overview of, 366–367

XML (eXtensible markup language), 367–370

data labels, using with charts, 215, 220

Data Link Properties dialog box, displaying, 122

data providers

purpose of, 18

requirements for, 123

selecting, 122

data range, specifying in Parameterized Invoice-Batch Number Report, 152–154

data regions

in Employee Time Report, 261

explanation of, 13

and fields in Employee Evaluation Report, 331

overview of, 179–187

report objects for, 517–521

data, retrieving from databases, 82–90

data source credentials, relationship to cached reports, 437. See also credentials

data sources. See also shared data sources

changing for Paid Invoices Report, 343–344

creating for Customer List Report, 119–123

for Customer-Invoice Report, 135–139

hiding and viewing, 390–391

role in data definition, 12–13

database servers, installation requirements for, 37

database structure, overview of, 72–73

databases

cardinality of relations in, 79–82

for Fuel Price chart, 201–202

normalization of, 76–78

primary keys in, 76

relations in, 78–79

retrieving data from, 82–90

sorting result sets in, 88–90

structuring, 73–74

tables, rows, and columns in, 73–76

data-driven subscriptions

creating, 460–466

overview of, 460

and security, 466

Data-Driven Subscriptions, availability of, 29

Dataset dialog box

displaying, 156, 189

using with Fuel Prices chart version 2, 209

datasets

adding parameters to, 152–155

applying filters to, 283

Business Type Distribution chart, 212

conference nametags, 223–227

conference place cards, 229–234

Customer List Report, 124–127

Customer-Invoice Report, 135–139, 144

Days in Maintenance chart, 215–219

Delivery Status Report, 293–294

Employee Evaluation Report, 325–330

Employee List Report, 268–269

Employee Time Report, 255–256

Fuel Price chart version 2, 208–210

Invoice Front End Report, 338

Invoice Report, 333–336

Invoice-Batch Number Report, 146–147

Lost Delivery Report, 304–306

modifying for Customer List Report revisited, 312–313

Overtime Report, 276–277

Parameterized Invoice-Batch Number Report, 155–157

Payroll Checks Report, 315–317

Rate Sheet Report, 235

Repair Count by Type Report, 180–182

role in data definition, 12–13

Transport Information Sheet, 188–189

Transport List Report, 166–170

Transport Monitor Report, 341–342

using stored procedures with, 278

Weather Report, 322–324

DATEPART( ) function, using with Employee Time Report, 256

dates, using with SQL Server, 155

datetime data type, explanation of, 155

Days in Maintenance chart

creating report for, 215–219

overview of, 215

previewing, 219

dbo (database owner), significance of, 96–97

debugger in Visual Studio, using, 507–508

default values, selecting

Employee List Report, 270–271

report parameters, 157–159

Define Query Parameters dialog box, displaying, 202

DELETE queries, explanation of, 94–95

Delivery Status Report

adding expressions to, 301–302

adding table to, 296–299

creating, 293–294

overview of, 293

previewing, 300

report layout for, 299

setting up report parameters for, 294–296

sorting, 297

DeliveryDetail Report, creating, 333

DeliveryNumber field, absence of aggregate function in, 299–300

DeliveryStatus dataset, creating, 333

denormalized data, explanation of, 83. See also normalization

DESC, using with ORDER BY clauses, 105

descending order, sorting columns in, 89

descending sort, explanation of, 392

Description field

adding to rectangle in Rate Sheet Report, 240

appending to expressions, 175

modifying in Rate Sheet Report, 238

Design the Matrix page of Report Wizard, displaying, 148

Design the Query page, displaying, 124, 126

Design the Table page, displaying in Report Wizard, 128, 140

Design window in Visual Studio .NET 2003, features of, 14–15

detail data, grouping in Payroll Checks Report, 317

detail row, reducing height of, 173

Details button, effect of, 148

Details Grouping dialog box, displaying, 260, 315

Developer Edition, features of, 30

diagram pane in Query Builder

Customer List Report, 124

Invoice-Batch Number Report, 146

diamond in Query Builder, appearance of, 137–138

disk space requirements, overview of, 36

DISTINCT queries

including with FIELD LISTS, 98–99

using with Parameterized Invoice-Batch Number Report, 156–157

distributed installation

description of, 32–33

performing, 61

DocMap URL parameters, values for and function for, 479

document map

displaying in Excel, 361–362

using with Invoice Front End Report, 340

documentation, role in Reporting Services, 29

documents, uploading with Report Manager, 396–398

domain groups, assigning security to, 511

domain user account, significance of, 43

drilldown feature

adding to Employee Time Report, 260–262

description of, 133

enabling in Report Wizard, 141, 145

using with Invoice-Batch Number Report, 148

drill-down matrix, creating for Repair Count by Type Report, 185

DrillthroughTest Report, restricting rights assigned to, 423

drop-down lists, using in Overtime Report, 283

DTS package, location of, 468

duplicate data, including in databases, 77

dynamic query, explanation of, 313–314




Microsoft SQL Server 2000 Reporting Services
Microsoft SQL Server 2000 Reporting Services Step by Step (Pro-Step by Step Developer)
ISBN: 0735621063
EAN: 2147483647
Year: 2003
Pages: 109

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