G

Galactic Data Model, 17

Galactic database

downloading, 116

introduction to, 90–93

Galactic Delivery Services. See GDS

GDS (Galactic Delivery Services), 88–93

accounting department, 92–93

background on, 88–93

package tracking services, 89–91

personnel, 91–92

reports for. See GDS reports

transport maintenance, 93

GDS reports.

See also reports

Customer List Report, 117–136, 334–338

Customer-Invoice Report, 136–150

Delivery Analysis Report, 350–357

Delivery Status Report, 317–327

Employee Evaluation Report, 358–366

Employee List Report, 281–292

Employee Mailing Labels Report, 291–299

Employee Time Report, 266–280

Invoice Report, 366–370

Invoice-Batch Number Report, 150–156

Lost Delivery Report, 327–334

Nametags report, 422–427, 430

Overtime Report, 300–308

Paid Invoices Report, 379–381

Parameterized Invoice-Batch Number Report, 156–164

Payroll Checks Report, 338–344

Rate Sheet Report, 245–253

Repair Count By Type Report, 188–196

Transport Information Sheet, 196–208

Transport List Report, 166–187

Transport Monitor Report, 374–379

Weather Report, 345–350, 476

Generic Query Designer, 171–172

GetCacheOptions method, 640

GetDataDrivenSubscriptionProperties method, 640–641

GetDataSourceContents method, 641

GetDocumentMap method, 626

GetExecutionInfo method, 626

GetExecutionOptions method, 642

GetExtensionSettings method, 642

GetltemDataSourcePrompts method, 642

GetItemDataSources method, 642–643

GetItemType method, 643

GetModelDefinition method, 643

GetModelItemPermissions method, 643–644

GetModelItemPolicies method, 644

GetPermissions method, 644

GetPolicies method, 644–645

GetProperties method, 645

GetRenderResource method, 626–627, 645

GetReportDefinition method, 645

GetReportHistoryLimit method, 646

GetReportHistoryOptions method, 646

GetReportLink method, 646–647

GetReportParameters method, 647

GetResourceContents method, 647

GetRoleProperties method, 648

GetScheduleProperties method, 648

GetSubscriptionProperties method, 648–649

GetSystemPermissions method, 649

GetSystemPolicies method, 649

GetSystemProperties method, 649

GetUserInfo method, 559–560

GetUserModel method, 649

global assembly cache, 539

globalinstall switch, 539

globally unique identifier (GUID), 551

Graphical Query Designer, 125–130, 171–177

GridSpacing property, 601

GROUP BY clause, 95, 109–112, 176–177, 186

Group By column, 174–175, 177

group expression, 186

Grouping element, 694

Grouping property, 601

Grouping/Sorting property, 601

GroupOn property, 602

groups

code access, 434–435

collapsing/expanding, 274, 276–278

columns, 193–195

details grouping, 273–274

Name column and, 149

report parameters and, 285–288

sorting, 284–288

tables, 182, 186

totalling values, 274–280

GroupsBeforeRowHeaders property, 602

GUID (globally unique identifier), 551