■ INDEX
Health-care application (cont.)
Clinical Reports root folder, 345
connection screen, 342, 343
content filtering, 352
content management permissions, 341
content manager, 341
Daily Activity report, 346
data source authentication method, 345
data warehouse database, 362
db_datareader permissions, 345
default security group, 348, 349
error message, 347, 348
graphical MDX query builder
Average Referral to Admission report, 372
Average Time to Admission chart, 371
Design Mode toolbar button, 370
dimensional and measure elements, 369,
370
graphical design mode, 369
MAX function, 370
MIN function, 370
output, 369, 370
Referral to Admission Chart, 372
warning message, 371
Group Policy settings, 340
HW_Analysis, 362
Matrix-style reports, 366
MultiDimensional expressions, 363
My Reports feature, 341
New Role Assignment form, 349
Patient Referral cube, 362
Average Referral to Admission report, 367
branch, 364
Browser tab, 364
County, 364
cube browser, 367
Data Source Designer, 364
Date of Admission, 364
design mode, 364
diagnosis, 364
OLAP database, 364
payer, 364
Referral Source, 364
Referral to Admission Chart report, 367
structure, 362, 363
Registered Nurse folder, 345
Report Builder role, 341, 343, 344
report objects, 346, 347
reports publishing, 341
RN_DS data source, 345, 346
RNsecurity group, 340RN Windows security group, 351
roles and system roles, 342
Rubik’s cube, 364
SSIS, 362
test account, 351, 352
Time to Admission, 365–366
users task, 342
windows integrated security option, 345
HTML, 11
text formatting, 5
code output, 154
Hyperlink
actions, 143–147
formatting and tooltips, 157 I, J, K
Integrated development environment (IDE), 13
Error List window, 44
Properties window, 44
Report Data window, 44
sample IDE configuration, 45
toolbox, 44
IntelliSense, 59
Interactive sorting, 141–143
ISNULL function, 34 L
Layer 2 tunneling protocol (L2TP), 330
ListChildren method, 235, 236
Lookup functions, 6 M
Matrix report creation
Average Length of Stay, 437
blank matrix report, 436
data region, 435
Discharge Reason field, 436
Discharge Year parameter, 440–441
filter data, 439–440
Microsoft Excel, 435
number formatting, 438
Microsoft Directory Services, 54
Microsoft Management Console (MMC), 39
Microsoft Office Ribbon technology, 45
Microsoft SharePoint 2010, 373
Microsoft Word, 5, 11
Microsoft’s Reporting Services ad-hoc tool, 463