MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))

Mailing Labels Report, 291–299

Manage Jobs page, 510

many-to-many relations, 79–80, 84–85

mapped drives, 64

margins, 262, 299, 608

Margins property, 608

MarkerSize property, 609

MarkerType property, 609

Matrix Column Group item, 586

Matrix Column item, 585

matrix data region, 187

Matrix element, 692

Matrix item, 585

Matrix report item, 191

matrix reports

basic layout for, 732–734

creating, 150–156, 188–196

Invoice-Batch Number Report, 150–156

Repair Count By Type Report, 188–196

Matrix Row Group item, 586

Matrix Row item, 586

Matrix Subtotal item, 586

MaxActiveReqForOneUser setting, 544

MaxAppDomainUnloadTime setting, 546

MAX() function, 111, 177

MaximumMemoryLimit setting, 546

MaxQueueThreads setting, 546

MaxScheduleWait setting, 544

MDAC (Microsoft Data Access Components), 36

MDX queries, 14, 350–355

memory.

See also caching

keeping result sets in, 130

requirements, 36

MemoryLimit setting, 546

menu bar, 62

merged cells, 186, 269–271

MergeTransactions property, 609

methods

authentication, 569

CancelBatch, 632

CancelJob, 632

CheckAccess, 563–564

CreateBatch, 633

CreateDataDrivenSubscription, 633

CreateDataSource, 634

CreateFolder, 634

CreateLinkedReport, 634

CreateModel, 635

CreateReport, 635

CreateReportHistorySnapshot, 635

CreateResource, 636

CreateRole, 636

CreateSchedule, 636

CreateSubscription, 637

DeleteItem, 637

DeleteReportHistorySnapshot, 637

DeleteRole, 638

DeleteSchedule, 638

DeleteSubscription, 638

DisableDataSource, 638

EnableDataSource, 639

ExecuteBatch, 639

FindItems, 639

FireEvent, 639–640

FlushCache, 640

GetCacheOptions, 640

GetDataDrivenSubscriptionProperties, 640–641

GetDataSourceContents, 641

GetDocumentMap, 626

GetExecutionInfo, 626

GetExecutionOptions, 642

GetExtensionSettings, 642

GetltemDataSourcePrompts, 642

GetItemDataSources, 642–643

GetItemType, 643

GetModelDefinition, 643

GetModelItemPermissions, 643–644

GetModelItemPolicies, 644

GetPermissions, 644

GetPolicies, 644–645

GetProperties, 645

GetRenderResource, 626–627, 645

GetReportDefinition, 645

GetReportHistoryLimit, 646

GetReportHistoryOptions, 646

GetReportLink, 646–647

GetReportParameters, 647

GetResourceContents, 647

GetRoleProperties, 648

GetScheduleProperties, 648

GetSubscriptionProperties, 648–649

GetSystemPermissions, 649

GetSystemPolicies, 649

GetSystemProperties, 649

GetUserInfo, 559–560

GetUserModel, 649

HTTP Get, 519–525

HTTP Post, 525–526

InheritModelItemParentSecurity, 650

InheritParentSecurity, 650

IsValidPrincipalName, 560

ListChildren, 625, 650

ListDependentItems, 650–651

ListEvents, 651

ListExtensions, 651

ListJobs, 651

ListModelDrillthroughReports, 651

ListModelItemChildren, 652

ListModePerspective, 652

ListRenderingExtensions, 627

ListReportHistory, 652

ListRoles, 652

ListScheduledReports, 653

ListSchedules, 653

ListSecureMethods, 627, 653

ListSubscriptions, 653

ListSubscriptionsUsingDataSource, 653

ListTasks, 654

LoadDrillthroughTarget, 627

LoadReport, 627

LoadReportDefinition, 628

Logoff, 628, 654

LogonUser, 560, 628, 654

MoveItem, 654

NavigateBookmark, 628

NavigateDocumentMap, 629

PauseSchedule, 655

PrepareQuery, 655

RemoveAllModelItemPolicies, 655

Render, 629

RenderStream, 629–630

ReportExecution2005, 626–631

ReportService2005, 632–663

ResetExecution, 630

ResumeSchedule, 655–656

SetCacheOptions, 656

SetConfiguration, 563

SetDataDrivenSubscriptionProperties, 656–657

SetDataSourceContents, 657

SetExecutionCredentials, 630

SetExecutionOptions, 657

SetItemDataSources, 657

SetModelDefinition, 658

SetModelDrillthroughReports, 658

SetModelItemPolicies, 658

SetPolicies, 658–659

SetProperties, 659

SetReportDefinition, 659

SetReportHistoryLimit, 659–660

SetReportHistoryOptions, 660

SetReportLink, 660

SetReportParameters, 660–661

SetResourceContents, 661

SetRoleProperties, 661

SetScheduleProperties, 661–662

SetSubscriptionProperties, 662

SetSystemPolicies, 662

SetSystemProperties, 663

Sort, 630–631

ToggleItem, 631

UpdateReportExecutionSnapshot, 663

ValidateExtensionSettings, 663

VerifyPassword, 560

VerifyUser, 560

.mhtml extension, 394

MHTML format, 394, 520, 524

Microsoft Access databases, 61

Microsoft Access reports, 379–381

Microsoft Data Access Components (MDAC), 36

Microsoft Data Engine (MSDE), 37

Microsoft Distributed Transaction Coordinator, 38–39

Microsoft Excel documents, 397

Microsoft Excel format, 397–399

device information parameters, 520, 521

exporting reports to, 397–399

features supported, 397–399

printing and, 8–9, 399

uses for, 399

Microsoft Internet Explorer, 400, 411

MIMEType property, 609

MIN() function, 111, 201

minus sign (−), 148, 274, 277–278

MinuteRecurrence class, 674

ModelCatalogItem class, 674

ModelDrillthroughReport class, 674

ModelItem class, 674–675

ModelPerspective class, 675

MonthlyDOWRecurrence class, 675

MonthlyRecurrence class, 676

MonthsOfYearSelector class, 676

MoveItem method, 654

MS DTC, 38–39

MSDE (Microsoft Data Engine), 37

My Reports folder, 507–508

My Reports option, 507–508

My Reports role, 455

My Subscriptions page, 496–498

MyReports feature, 555

MyReportsRole property, 548