Relationship Manager Report
{ "Report": { "69": { "id": "69",
"name": "Relationship Manager Report - Working",
"order": "47",
"show_in_crm": false,
"created": "2023-12-15 15:34:25",
"modified": "2023-12-15 18:13:45" } },
"ReportColumn": { "1450": { "id": "1450",
"report_id": "69",
"report_dataset_id": "199",
"report_dataset_model_id": "687",
"is_internal": true,
"name": "Received (date)",
"alias": "received",
"order": "0",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:38:00",
"modified": "2023-12-15 15:44:47",
"is_filter": true },
"1455": { "id": "1455",
"report_id": "69",
"report_dataset_id": "200",
"report_dataset_model_id": "686",
"is_internal": true,
"name": "Received",
"alias": "received",
"order": "0",
"column_type": "simple",
"simple_expression": "MAX(DATE({column}))",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:42:19",
"modified": "2023-12-15 16:03:28",
"is_filter": true },
"1462": { "id": "1462",
"report_id": "69",
"report_dataset_id": "201",
"report_dataset_model_id": "694",
"is_internal": true,
"name": "Amount",
"alias": "amount",
"order": "0",
"column_type": "simple",
"simple_expression": "SUM({column})",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:09:09",
"modified": "2023-12-15 16:09:30",
"is_filter": true },
"1465": { "id": "1465",
"report_id": "69",
"report_dataset_id": "202",
"report_dataset_model_id": "698",
"is_internal": true,
"name": "Id - Historic Gift Donor",
"alias": "id",
"order": "0",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:17:24",
"modified": "2023-12-15 16:17:24",
"is_filter": true },
"1468": { "id": "1468",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "683",
"is_internal": false,
"name": "Id - Person (Donor)",
"alias": "id",
"order": "0",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:27:44",
"modified": "2023-12-15 16:27:44",
"is_filter": true },
"1449": { "id": "1449",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "682",
"is_internal": false,
"name": "Fullname",
"alias": "fullname",
"order": "1",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:36:51",
"modified": "2023-12-15 15:36:51",
"is_filter": true },
"1451": { "id": "1451",
"report_id": "69",
"report_dataset_id": "199",
"report_dataset_model_id": "687",
"is_internal": true,
"name": "Amount",
"alias": "amount",
"order": "1",
"column_type": "simple",
"simple_expression": "SUM({column})",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:38:00",
"modified": "2023-12-15 15:44:59",
"is_filter": true },
"1460": { "id": "1460",
"report_id": "69",
"report_dataset_id": "200",
"report_dataset_model_id": "692",
"is_internal": true,
"name": "Id - Historic Donor",
"alias": "id",
"order": "1",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:01:55",
"modified": "2023-12-15 16:01:55",
"is_filter": true },
"1464": { "id": "1464",
"report_id": "69",
"report_dataset_id": "201",
"report_dataset_model_id": "695",
"is_internal": true,
"name": "Id - Historic Gift Donor",
"alias": "id",
"order": "1",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:10:56",
"modified": "2023-12-15 16:10:56",
"is_filter": true },
"1466": { "id": "1466",
"report_id": "69",
"report_dataset_id": "202",
"report_dataset_model_id": "697",
"is_internal": true,
"name": "Amount",
"alias": "amount",
"order": "1",
"column_type": "simple",
"simple_expression": "MAX({column})",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:17:40",
"modified": "2023-12-15 16:18:02",
"is_filter": true },
"1452": { "id": "1452",
"report_id": "69",
"report_dataset_id": "199",
"report_dataset_model_id": "687",
"is_internal": true,
"name": "Fullname",
"alias": "fullname",
"order": "2",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:38:00",
"modified": "2023-12-15 15:45:07",
"is_filter": true },
"1453": { "id": "1453",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "682",
"is_internal": false,
"name": "Email",
"alias": "email",
"order": "2",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:39:16",
"modified": "2023-12-15 15:39:16",
"is_filter": true },
"1454": { "id": "1454",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "682",
"is_internal": false,
"name": "Phone",
"alias": "phone",
"order": "3",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:39:31",
"modified": "2023-12-15 15:39:31",
"is_filter": true },
"1457": { "id": "1457",
"report_id": "69",
"report_dataset_id": "199",
"report_dataset_model_id": "687",
"is_internal": true,
"name": "Id - Historic Gift",
"alias": "id",
"order": "3",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:45:58",
"modified": "2023-12-15 15:54:58",
"is_filter": true },
"1458": { "id": "1458",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "691",
"is_internal": false,
"name": "YTD",
"alias": "c_1451",
"order": "4",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:47:16",
"modified": "2023-12-15 15:56:30",
"is_filter": true },
"1459": { "id": "1459",
"report_id": "69",
"report_dataset_id": "199",
"report_dataset_model_id": "689",
"is_internal": true,
"name": "Id - Historic Donor",
"alias": "id",
"order": "4",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 15:49:18",
"modified": "2023-12-15 15:49:18",
"is_filter": true },
"1461": { "id": "1461",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "693",
"is_internal": false,
"name": "Last Gift",
"alias": "c_1455",
"order": "5",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:02:33",
"modified": "2023-12-15 16:02:33",
"is_filter": true },
"1463": { "id": "1463",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "696",
"is_internal": false,
"name": "Lifetime Giving",
"alias": "c_1462",
"order": "6",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:10:10",
"modified": "2023-12-15 16:10:10",
"is_filter": true },
"1467": { "id": "1467",
"report_id": "69",
"report_dataset_id": "198",
"report_dataset_model_id": "699",
"is_internal": false,
"name": "Largest Gift",
"alias": "c_1466",
"order": "7",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"identifier": "",
"created": "2023-12-15 16:18:59",
"modified": "2023-12-15 16:18:59",
"is_filter": true } },
"ReportDataset": { "198": { "id": "198",
"report_id": "69",
"name": "Person",
"description": "",
"is_base": true,
"is_aggregate": false,
"order": "0",
"group_by": "`Model683`.`id`",
"having": "",
"order_by": "",
"limit": null,
"created": "2023-12-15 15:34:51",
"modified": "2023-12-15 15:38:39" },
"199": { "id": "199",
"report_id": "69",
"name": "YTD",
"description": "",
"is_base": false,
"is_aggregate": true,
"order": "1",
"group_by": "`Model689`.`id`",
"having": "",
"order_by": "",
"limit": null,
"created": "2023-12-15 15:38:00",
"modified": "2023-12-15 15:49:29" },
"200": { "id": "200",
"report_id": "69",
"name": "Last Gift Date",
"description": "",
"is_base": false,
"is_aggregate": true,
"order": "2",
"group_by": "`Model692`.`id`",
"having": "",
"order_by": "",
"limit": null,
"created": "2023-12-15 15:41:30",
"modified": "2023-12-15 16:03:46" },
"201": { "id": "201",
"report_id": "69",
"name": "Lifetime Giving",
"description": "",
"is_base": false,
"is_aggregate": true,
"order": "3",
"group_by": "`Model695`.`id`",
"having": "",
"order_by": "",
"limit": null,
"created": "2023-12-15 16:08:15",
"modified": "2023-12-15 16:12:23" },
"202": { "id": "202",
"report_id": "69",
"name": "Largest Gift",
"description": "",
"is_base": false,
"is_aggregate": true,
"order": "4",
"group_by": "`Model698`.`id`",
"having": "",
"order_by": "",
"limit": null,
"created": "2023-12-15 16:16:34",
"modified": "2023-12-15 16:17:48" } },
"ReportDatasetModel": { "682": { "id": "682",
"report_dataset_id": "198",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 15:36:06",
"modified": "2023-12-15 15:36:06",
"union": "" },
"683": { "id": "683",
"report_dataset_id": "198",
"alias": "Person",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "682",
"join_alias": "HistoricGiftDonorPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 15:37:01",
"modified": "2023-12-15 15:37:01",
"union": "" },
"691": { "id": "691",
"report_dataset_id": "198",
"alias": null,
"associated_report_dataset_id": "199",
"join_report_dataset_model_id": "682",
"join_alias": "",
"join_type": "left",
"join_on_clause": "`Model683`.`id` = Model691.c_1459",
"created": "2023-12-15 15:55:26",
"modified": "2023-12-15 16:00:12",
"union": "" },
"693": { "id": "693",
"report_dataset_id": "198",
"alias": null,
"associated_report_dataset_id": "200",
"join_report_dataset_model_id": "682",
"join_alias": "",
"join_type": "left",
"join_on_clause": "`Model683`.`id` = Model693.c_1460",
"created": "2023-12-15 16:02:19",
"modified": "2023-12-15 16:02:19",
"union": "" },
"696": { "id": "696",
"report_dataset_id": "198",
"alias": null,
"associated_report_dataset_id": "201",
"join_report_dataset_model_id": "682",
"join_alias": "",
"join_type": "left",
"join_on_clause": "`Model683`.`id` = Model696.c_1464",
"created": "2023-12-15 16:09:54",
"modified": "2023-12-15 16:15:13",
"union": "" },
"699": { "id": "699",
"report_dataset_id": "198",
"alias": null,
"associated_report_dataset_id": "202",
"join_report_dataset_model_id": "682",
"join_alias": "",
"join_type": "left",
"join_on_clause": "`Model683`.`id` = Model699.c_1465",
"created": "2023-12-15 16:18:24",
"modified": "2023-12-15 16:18:24",
"union": "" },
"705": { "id": "705",
"report_dataset_id": "198",
"alias": "PersonRelation",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "683",
"join_alias": "PersonRelationRelatedPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 16:42:52",
"modified": "2023-12-15 16:42:52",
"union": "" },
"687": { "id": "687",
"report_dataset_id": "199",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 15:44:32",
"modified": "2023-12-15 15:44:32",
"union": "" },
"689": { "id": "689",
"report_dataset_id": "199",
"alias": "Person",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "687",
"join_alias": "HistoricGiftDonorPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 15:49:02",
"modified": "2023-12-15 15:49:02",
"union": "" },
"686": { "id": "686",
"report_dataset_id": "200",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 15:42:08",
"modified": "2023-12-15 15:42:08",
"union": "" },
"692": { "id": "692",
"report_dataset_id": "200",
"alias": "Person",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "686",
"join_alias": "HistoricGiftDonorPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 16:01:29",
"modified": "2023-12-15 16:01:29",
"union": "" },
"694": { "id": "694",
"report_dataset_id": "201",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 16:08:31",
"modified": "2023-12-15 16:08:31",
"union": "" },
"695": { "id": "695",
"report_dataset_id": "201",
"alias": "Person",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "694",
"join_alias": "HistoricGiftDonorPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 16:08:44",
"modified": "2023-12-15 16:08:44",
"union": "" },
"697": { "id": "697",
"report_dataset_id": "202",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 16:16:51",
"modified": "2023-12-15 16:16:51",
"union": "" },
"698": { "id": "698",
"report_dataset_id": "202",
"alias": "Person",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "697",
"join_alias": "HistoricGiftDonorPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 16:17:01",
"modified": "2023-12-15 16:17:01",
"union": "" } },
"ReportDatasetCondition": { "204": { "id": "204",
"is_logical_operator": false,
"parent_id": null,
"condition_type": "simple",
"report_dataset_id": "198",
"report_dataset_model_id": "705",
"column_alias": "relation_type_id",
"negate": false,
"type": "=",
"value": "45",
"compare": "value",
"compare_report_dataset_id": null,
"compare_report_dataset_model_id": null,
"compare_column_alias": null,
"smart_expression": "",
"created": "2023-12-15 16:47:19",
"modified": "2023-12-15 16:59:12" },
"202": { "id": "202",
"is_logical_operator": false,
"parent_id": null,
"condition_type": "smart",
"report_dataset_id": "199",
"report_dataset_model_id": null,
"column_alias": null,
"negate": false,
"type": "",
"value": null,
"compare": "value",
"compare_report_dataset_id": null,
"compare_report_dataset_model_id": null,
"compare_column_alias": null,
"smart_expression": "YEAR(`Model687`.`received`) = YEAR(CURDATE())",
"created": "2023-12-15 15:38:00",
"modified": "2023-12-15 15:47:37" } },
"ReportView": { "113": { "id": "113",
"report_id": "69",
"name": "Relationship Manager Report",
"order": "0",
"conditions": "",
"group_by": "",
"having": "",
"order_by": "",
"limit": null,
"render_as": "table",
"chart_options": "{}",
"created": "2023-12-15 15:43:06",
"modified": "2023-12-15 15:43:06",
"rows_to_columns": false } },
"ReportViewColumn": { "1312": { "id": "1312",
"report_view_id": "113",
"name": "Fullname",
"alias": "c_1449",
"order": "0",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "auto",
"number_style": "decimal",
"decimals": null,
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 15:43:23",
"modified": "2023-12-15 15:43:23",
"dynamic_name": "",
"name_formatted": "Fullname" },
"1316": { "id": "1316",
"report_view_id": "113",
"name": "Last Gift",
"alias": "c_1461",
"order": "1",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "number",
"number_style": "currency",
"decimals": "2",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 16:21:30",
"modified": "2023-12-15 16:24:05",
"dynamic_name": "",
"name_formatted": "Last Gift" },
"1318": { "id": "1318",
"report_view_id": "113",
"name": "Largest Gift",
"alias": "c_1467",
"order": "2",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "number",
"number_style": "currency",
"decimals": "2",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 16:22:05",
"modified": "2023-12-15 16:24:37",
"dynamic_name": "",
"name_formatted": "Largest Gift" },
"1315": { "id": "1315",
"report_view_id": "113",
"name": "YTD",
"alias": "c_1458",
"order": "3",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "number",
"number_style": "currency",
"decimals": "2",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 16:21:19",
"modified": "2023-12-15 16:23:38",
"dynamic_name": "",
"name_formatted": "YTD" },
"1317": { "id": "1317",
"report_view_id": "113",
"name": "Lifetime Giving",
"alias": "c_1463",
"order": "4",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "number",
"number_style": "currency",
"decimals": "2",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 16:21:54",
"modified": "2023-12-15 16:24:24",
"dynamic_name": "",
"name_formatted": "Lifetime Giving" },
"1313": { "id": "1313",
"report_view_id": "113",
"name": "Email",
"alias": "c_1453",
"order": "5",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "auto",
"number_style": "decimal",
"decimals": null,
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 16:21:02",
"modified": "2023-12-15 16:21:02",
"dynamic_name": "",
"name_formatted": "Email" },
"1314": { "id": "1314",
"report_view_id": "113",
"name": "Phone",
"alias": "c_1454",
"order": "6",
"column_type": "simple",
"simple_expression": "",
"smart_expression": null,
"type": "auto",
"number_style": "decimal",
"decimals": null,
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": "{}",
"created": "2023-12-15 16:21:12",
"modified": "2023-12-15 16:21:12",
"dynamic_name": "",
"name_formatted": "Phone" } } }
Source: Ratio Christi
Updated on: 13/04/2026
Thank you!