■ INDEX
Report Builder 1.0, 4.6 (cont.)
ClickOnce application installation screen,
425
NET Framework 2.0, 424
Report Builder URL, 424
report designer, 423
Report Manager, 424
report model selection, 425–426
SQL Server 2008 R2, 424
table report template, 426–427
Report Builder 2.0 Wizard, 45
connection string property, 450
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
finished report, 453
Insert tab, 457
layout selection screen, 452
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 property, 450
SQL Server 2008 R2/SQL Server 2012, 449
SSRS 2008, 447
User ID, 461
Visit Count, 458
Report Builder 3.0, 12, 14–15, 45, 219
BIDS/Visual Studio integrated tools, 218
data sources, 464
dataset caching, 464
drill, 465
Employee Service Cost by branch and patient
state, 465–472
loaded report, 219, 220
Map report, 464
Pearl menu, 220
RDL file, 220
report items, 464
report parts, 464
save options, 221
Report creation
adding a data source, 406–408
BIDS 2008 R2, 405–406
chart report (see Chart report creation)data source view (see Data source view
creation)
matrix report (see Matrix report creation)
patient census model, 404
Report Builder 1.0 (see Report Builder 1.0)
table report (see Table report)
user feedback, 402
Report Definition Language (RDL), 1
Active Directory querying, 54
data source creation, 47–49
dataset creation, 49–53
expressions, 58–59
filters, 56–57
find-and-replace method, 45
OLE DB, 54
query and report parameters, 54–56
report adding, 46–47
updating and uploading
default parameter value, 288–290
Download and Replace links, 287
Notepad, RDL file, 287, 288
options menu, 285, 286
properties screen, 286, 287
ReportParameter, 287
XML-based schema, 45
Report deployment
Actions link button, 393
application running, 239–242
Average Referral to Admissions, 392
configuration
Configuration Manager, 223–224
properties, 221–223
data source definition, 391, 392
PatRef_DS data source, 390
permission-related issues, 391
Report Builder 3.0 (see Report Builder 3.0)
Report Manager (see Report Manager)
report server web service (see Report server
web service)
Reports Library, 388
rs.exe utility
CreateFolder method, 229
report and data source, 230
RSS file configuration, 226–227
RSS file contents, 227–229
VB .NET code, 226
SharePoint Document Center main page, 388
SharePoint document features, 390, 391
SharePoint, rendered report, 392–394
Solution Explorer, 224–225
target URL properties, 389, 390