Pro SQL Server 2012 Reporting Services

■ INDEX

 C

Central Administration, 384

Chart report creation

3-D Visual Effect box, 444–445

Active Patient Census, 445

Chart Title, 444

data labels, 445

data region, 441–442

Discharge Date, 443

drag and drop data, 442

Patient Count formula, 442–443

Report Builder 2.0 Wizard

data source and dataset, 454–457

default Ocean style, 452

Emp_Svc_Cost stored procedure, 450–451

Estimated_Cost field, 460

execution time and title, 462

final formatting report, 463

finished report, 453

Insert tab, 457–458

layout selection screen, 452, 453

Microsoft’s Reporting Services ad-hoc

tool, 463

New Table/Matrix wizard, 449

NULL values, 459

Preview button, 459

query design, 450

Ribbon technology, 447–448

Service Type Estimated Cost, 452

setting data source and connection string

property, 449–450

SQL Server 2008 R2/SQL Server 2012, 449

SSRS 2008, 447

User ID, 461

Visit Count, 458

Report Builder 3.0 (see Report Builder 3.0)

Report Layout tab, 441

Report Manager, 446

report parts, 473

Command-line utilities, 12, 14

Comma-separated values (CSVs), 11

CreateCatalogItem method, 230, 237, 239, 240

CreateReportEditSession method, 231

Custom .NET code

class library project, 195–198

custom assembly

asserting permission, 202

code reuse, 195

debugging, 207–210

deploying, 198

flexibility, 195

language neutrality, 195

Named Permission Sets, 200–201

productive development environment,

195

reference adding, report, 202–207

rssrvpolicy.config file, 199

security control, 195

SSRS 2012, 199

task separation, 195

troubleshooting, 210

embedded code, 186, 194

ExceedMaxCosts function, 187

Boolean return value, 190

Code member, 189

Code.ExceedMaxCost method, 189

color property, 190, 191

color selection list, 192

conditional expression, 190

EmployeeServiceCost-NoCode.rdl file,

188

expression adding, report, 190

expression editor, 192

IIF native SSRS function, 190

Pro_SSRS.rds file, 188

report with the embedded code, 193

Visual Studio 2010 BI project creation,

187, 188

Custom clients, 12, 15

 D

Dashboard, 394–397

Dashboard-style report objects, 89

chart data region, 89

Chart Start.rdl, 90, 91

Chart.rdl, 95

Emp_Svc_Cost stored procedure, 90

preview, 93, 94

properties, 91, 93

RDL ouptput, 94

SSRS, 90, 91

three fields, 91, 92

data bar, 89

Chart Data dialog, 111, 112

Data Bar Start.rdl, 110

Data Bar.rdl, 115

object recognition, 110

preview, 113, 114