■ INDEXMIME HTML (MHTML), 11
Multivalued parameters
Emp_Svc_Cost, 169
fn_MVParam, string-parsing function, 169
generated report, 170
IN clause, 166, 167
MVP, 166, 167
NULL values, 166
query/stored procedure, 165
selection, 168
table-valued function, 168
WHERE clause, 165, 166, 169
wrapping SQL statements, 168
Year and Month parameters, 166
N
NULL rendering extension, 11
NULL values, 36
O
OverwriteDataSets, 221
OverwriteDataSources, 222
P
Parameterized stored procedure
column and table aliasing, 35
CREATE PROCEDURE command, 32
database expansion, 32
Emp_Svc_Cost, 32–34
ISNULL function, 34
performance and indexes, 34–35
procedure testing, 35–36
SELECT statement, 32
Patient census report
admission and discharge information, 403
BIDS 2008 R2, 405–406
chart report (see Chart report creation)
data source views (see Data source view
creation)
data source Wizard, 406–408
Data Sources folder, 421–422
health-care industry, 403
matrix report (see Matrix report creation)
process completed successfully, 419–420
Report Builder 1.0 (see Report Builder 1.0)
Report Builder 3.0 (see Report Builder 3.0)
report model, 404, 420
table report (see Table report)
Patient Name detail textbox, 152
Patient Recertification Listing report, 298
Patient Survey Letter, 153, 156
Performance-tuning queries, 35
Placeholder Properties dialog, 155
Point-to-Point tunneling protocol (PPTP), 330
Portable Document Format (PDF), 11 Q
Query design, 19
advanced query
COUNT and SUM functions, 28
employee cost query, healthcare
database, 27
optimizing performance, 30–32
ORDER BY PATID clause, 28
required data output, 26
SELECT clause, 27
SQL Server machine, 28
SSMS, 28–30
dataset configuration, 19
graphical query
sample output, 26
single-user execution scenario, 26
SSMS, 23–25
top ten patient diagnoses code, 25
parameterized stored procedure
column and table aliasing, 35
CREATE PROCEDURE command, 32
database expansion, 32
Emp_Svc_Cost, 32–34
ISNULL function, 34
performance and indexes, 34–35
procedure testing, 35–36
SELECT statement, 32
sample relational database
Pro_SSRS database, 20
schema design, 20–21
sp_FieldInfo, 21–23
Query parameter, 158 R
Remote desktop protocol (RDP), 330
Report Builder 1.0, 46
BIDS/Visual Studio, 423
chart report (see Chart report creation)