{ "ReportVersion": "2023.2.5.0", "ReportGuid": "365d3e83eaeb49b6ac9da19c1d40dd63", "ReportName": "Report", "ReportAlias": "Report", "ReportCreated": "/Date(1618180532000+0000)/", "ReportChanged": "/Date(1685547052000+0000)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "PreviewSettings": 268435455, "Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class Report : Stimulsoft.Report.StiReport\r\n {\r\n public Report() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "ReferencedAssemblies": { "0": "System.Dll", "1": "System.Drawing.Dll", "2": "System.Windows.Forms.Dll", "3": "System.Data.Dll", "4": "System.Xml.Dll", "5": "Stimulsoft.Controls.Dll", "6": "Stimulsoft.Base.Dll", "7": "Stimulsoft.Report.Dll" }, "Dictionary": { "Resources": { "0": { "Name": "R1PI-1022(2)", "Alias": "R1PI-1022(2)", "Type": "Json", "Image": "yPt3szVWRn0irUofpMIoOTSYe+sTmCYf0pxoi7fxD4HUFGoPCyB86gvdy7l5nQXmQT0lZ1qJN5NPVZWlDYPxVc+m3AIm8C2R58xbRN4pi5uJl3sJYPilxVO3xuAfGMIc433jjnxPQ/jusqaff2NBi7k/XCxiUmI7G7xK3xF7MUo7g4Au1GggsWDUTWIYLaJTcXdwPip7Fn6VHqbTjjSkHpBaKpjRxPxm1QMXGS4yVo3TF4WP+0PgcJXl70ppqkdRqsiuaBEK+LEbe2OTJE4cgWd1t2QckXctBMeeXpWN6ge5t1GYuYqzTFzl4vdNkkU+Mv+yYn6FcLsHSN7G98jNWnyjSuIzgzlNZH+kGYQKDhOqua8fOgmPUHoTgB3CYCK0Y++NB3I/bDTfxw9Av+VsbPGf6mfmpmgQHf/ZkSXthMwn1bwOsb/ZWyGipd738QnYk++G0q5GQUxnpbA+XqrQ+syE6WM6d1Ts5Rd5Y4TVzEU+COmINWDz1Y5BP/TkFtiS9DDD4tXy5BA9R4a9SVFTClmmWBbO2uiFLvLVtJPXxfxpX4Eq44DW4/b60IewRitMAU33L6HlIm7eypZGyL+8jjqhrR/zLA9UEIQjcm4UciWu7Z5az0rmrVl8Ziy7DYdpDRUu82VXg781l+Pzf+bQkA8beLODr08/zWpfvOrI7K6dbtHQ5hSdIg292+10C+FuKk13EvKfQZOIALDl3hRDRGI+chZMdZotkMNnQVW+806BDEeb/QQwa02Crwo+C9z84+z9DtmevhfoVMqiy5vQxvxMkjhQIbxzWOgCO7gtdeBZiJXO4BThHD2s87csnzoi7GYkBIq35HkcLDsT5F1HwMl+WiMz1AFvag==" } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "header", "Alias": "header", "Key": "04de2c6c0d1d44e8b10863498e51643f", "Columns": { "0": { "Name": "titulo", "Index": -1, "NameInSource": "titulo", "Alias": "titulo", "Type": "System.String" }, "1": { "Name": "subtitulo", "Index": -1, "NameInSource": "subtitulo", "Alias": "subtitulo", "Type": "System.String" }, "2": { "Name": "periodo", "Index": -1, "NameInSource": "periodo", "Alias": "periodo", "Type": "System.String" }, "3": { "Name": "organizacao", "Index": -1, "NameInSource": "organizacao", "Alias": "organizacao", "Type": "System.String" }, "4": { "Name": "contador", "Index": -1, "NameInSource": "contador", "Alias": "contador", "Type": "System.String" }, "5": { "Name": "logoAplicacao", "Index": -1, "NameInSource": "logoAplicacao", "Alias": "logoAplicacao", "Type": "System.String" }, "6": { "Name": "logoOrganizacao", "Index": -1, "NameInSource": "logoOrganizacao", "Alias": "logoOrganizacao", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).header" }, "1": { "Ident": "StiDataTableSource", "Name": "data_internalUser_nodes_identifier", "Alias": "data_internalUser_nodes_identifier", "Key": "ac2b59290b214f0ba16c1f8d887d7c30", "Columns": { "0": { "Name": "internalUserId", "Index": -1, "NameInSource": "internalUserId", "Alias": "internalUserId", "Type": "System.Decimal" }, "1": { "Name": "mask", "Index": -1, "NameInSource": "mask", "Alias": "mask", "Type": "System.String" }, "2": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser_nodes_identifier" }, "2": { "Ident": "StiDataTableSource", "Name": "data_internalUser_nodes_group", "Alias": "data_internalUser_nodes_group", "Key": "c4f7e927b7c44334ba7140012ab12785", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Decimal" }, "1": { "Name": "groupPerson", "Index": -1, "NameInSource": "groupPerson", "Alias": "groupPerson", "Type": "System.String" }, "2": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser_nodes_group" }, "3": { "Ident": "StiDataTableSource", "Name": "data_internalUser_nodes_area", "Alias": "data_internalUser_nodes_area", "Key": "e5f1564c89654530bf447582a8931248", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Decimal" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser_nodes_area" }, "4": { "Ident": "StiDataTableSource", "Name": "data_internalUser_nodes_permanentAccessLevels_accessLevel", "Alias": "data_internalUser_nodes_permanentAccessLevels_accessLevel", "Key": "2b08537cad4146f2950b2b9f134dbc0f", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Decimal" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser_nodes_permanentAccessLevels_accessLevel" }, "5": { "Ident": "StiDataTableSource", "Name": "data_internalUser_nodes_permanentAccessLevels", "Alias": "data_internalUser_nodes_permanentAccessLevels", "Key": "8b015b9198de488ebc0c0535d8dbdd64", "Columns": { "0": { "Name": "personId", "Index": -1, "NameInSource": "personId", "Alias": "personId", "Type": "System.Decimal" }, "1": { "Name": "accessLevelId", "Index": -1, "NameInSource": "accessLevelId", "Alias": "accessLevelId", "Type": "System.Decimal" }, "2": { "Name": "accessLevel", "Index": -1, "NameInSource": "accessLevel", "Alias": "accessLevel", "Type": "System.String" }, "3": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser_nodes_permanentAccessLevels" }, "6": { "Ident": "StiDataTableSource", "Name": "data_internalUser_nodes", "Alias": "data_internalUser_nodes", "Key": "9b1046eed9934653bc89eaec04658493", "Columns": { "0": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.Decimal" }, "1": { "Name": "name", "Index": -1, "NameInSource": "name", "Alias": "name", "Type": "System.String" }, "2": { "Name": "identifier", "Index": -1, "NameInSource": "identifier", "Alias": "identifier", "Type": "System.String" }, "3": { "Name": "groupId", "Index": -1, "NameInSource": "groupId", "Alias": "groupId", "Type": "System.Decimal" }, "4": { "Name": "group", "Index": -1, "NameInSource": "group", "Alias": "group", "Type": "System.String" }, "5": { "Name": "areaId", "Index": -1, "NameInSource": "areaId", "Alias": "areaId", "Type": "System.Decimal" }, "6": { "Name": "area", "Index": -1, "NameInSource": "area", "Alias": "area", "Type": "System.String" }, "7": { "Name": "permanentAccessLevels", "Index": -1, "NameInSource": "permanentAccessLevels", "Alias": "permanentAccessLevels", "Type": "System.String" }, "8": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser_nodes" }, "7": { "Ident": "StiDataTableSource", "Name": "data_internalUser", "Alias": "data_internalUser", "Key": "36b07e9d42c54daab4eaf41a652fa4b5", "Columns": { "0": { "Name": "nodes", "Index": -1, "NameInSource": "nodes", "Alias": "nodes", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data_internalUser" }, "8": { "Ident": "StiDataTableSource", "Name": "data", "Alias": "data", "Key": "ec988b0f8cc449849747333e92108d2a", "Columns": { "0": { "Name": "internalUser", "Index": -1, "NameInSource": "internalUser", "Alias": "internalUser", "Type": "System.String" } }, "NameInSource": "R1PI-1022(2).data" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "R1PI-1022(2)", "Alias": "R1PI-1022(2)", "PathData": "resource://R1PI-1022(2)" } }, "Relations": { "0": { "Name": "RelationArea", "ChildColumns": { "0": "areaId" }, "ParentColumns": { "0": "id" }, "NameInSource": "RelationArea", "Alias": "RelationArea", "ParentSource": "data_internalUser_nodes_area", "ChildSource": "data_internalUser_nodes" }, "1": { "Name": "RelationGroup", "ChildColumns": { "0": "groupId" }, "ParentColumns": { "0": "id" }, "NameInSource": "RelationGroup", "Alias": "RelationGroup", "ParentSource": "data_internalUser_nodes_group", "ChildSource": "data_internalUser_nodes" }, "2": { "Name": "RelationIdentifier", "ChildColumns": { "0": "id" }, "ParentColumns": { "0": "internalUserId" }, "NameInSource": "RelationIdentifier", "Alias": "RelationIdentifier", "ParentSource": "data_internalUser_nodes_identifier", "ChildSource": "data_internalUser_nodes" }, "3": { "Name": "RelationAccessLevels", "ChildColumns": { "0": "id" }, "ParentColumns": { "0": "personId" }, "NameInSource": "RelationAccessLevels", "Alias": "RelationAccessLevels", "ParentSource": "data_internalUser_nodes_permanentAccessLevels", "ChildSource": "data_internalUser_nodes" }, "4": { "Name": "RelationAccessLevel", "ChildColumns": { "0": "accessLevelId" }, "ParentColumns": { "0": "id" }, "NameInSource": "RelationAccessLevel", "Alias": "RelationAccessLevel", "ParentSource": "data_internalUser_nodes_permanentAccessLevels_accessLevel", "ChildSource": "data_internalUser_nodes_permanentAccessLevels" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Relatório_de_Pessoa_Interna_R1PI_1021", "Guid": "a040926935fa3f2242ac54a98973e977", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeaderBand1", "PrintOn": "OnlyFirstPage", "ClientRectangle": "0,0.4,27.7,2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text5", "Guid": "5be8cfc4f60cf48905ad8c221ce554a0", "ClientRectangle": "3.14,0.38,21.4,0.81", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{header.titulo}" }, "HorAlignment": "Center", "Font": ";18;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text6", "Guid": "b5dbbcb4c9542479b0f4e50c439d06ec", "CanGrow": true, "ClientRectangle": "3.14,1.32,21.4,0.41", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{header.contador}" }, "HorAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "2": { "Ident": "StiImage", "Name": "Image1", "ClientRectangle": "0,0,3,1.5", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "Stretch": true, "DataColumn": "header.logoAplicacao" }, "3": { "Ident": "StiImage", "Name": "Image2", "Guid": "a89eaff725aaf6c41f53aa3410d714fc", "ClientRectangle": "24.7,0,3,1.5", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "Stretch": true, "DataColumn": "header.logoOrganizacao" } } }, "1": { "Ident": "StiPageFooterBand", "Name": "PageFooterBand1", "ClientRectangle": "0,18.55,27.7,0.45", "Interaction": { "Ident": "StiInteraction" }, "Border": "Top;;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "Guid": "43f8ce914896b1fd063601178dac35cb", "PrintOn": "OnlyFirstPage", "CanGrow": true, "ClientRectangle": "0.04,0.05,25.33,0.35", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{header.subtitulo}" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text2", "CanGrow": true, "ClientRectangle": "25.6,0.05,2,0.35", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNofM}" }, "HorAlignment": "Right", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true } } } }, "2": { "Ident": "StiHeaderBand", "Name": "HeaderBand1", "PrintOn": "OnlyFirstPage", "ClientRectangle": "0,3.2,27.7,0.58", "Interaction": { "Ident": "StiInteraction" }, "Border": "Top;;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text7", "Guid": "5fb8f1a0a8d1dd7db1e0908bd51ea63b", "ClientRectangle": "15.6,0.11,12.08,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{header.periodo}" }, "HorAlignment": "Right", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" } }, "PrintIfEmpty": true }, "3": { "Ident": "StiColumnHeaderBand", "Name": "ColumnHeaderBand1", "ClientRectangle": "0,4.58,27.7,0.58", "Interaction": { "Ident": "StiInteraction" }, "Border": "All;216,216,216;;;;;;solid:0,0,0", "Brush": "solid:237,237,237", "Components": { "0": { "Ident": "StiText", "Name": "Text12", "Guid": "c9e05b1158c823b14537285ffe6923dd", "ClientRectangle": "0.07,0.11,8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " Name" }, "Font": ";8.25;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text13", "Guid": "6187597ea9ae235367a1ac33bfed69e7", "ClientRectangle": "8.37,0.11,3,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "ID" }, "HorAlignment": "Right", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text16", "Guid": "90d6d7f363a5cdbda4fdd83ca35d7627", "ClientRectangle": "11.7,0.11,4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Group" }, "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text17", "Guid": "b081191b3e89a8dbc4ad7d79d2a47add", "ClientRectangle": "16,0.11,4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Area" }, "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text4", "Guid": "3f19b072ee7a659e0ecce82083dbd92e", "ClientRectangle": "20.27,0.11,7.43,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "List of Access Levels" }, "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "4": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,5.96,27.7,0.45", "Interaction": { "Ident": "StiBandInteraction" }, "Border": "Top;216,216,216;;;;;True;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text14", "Guid": "33bfcf5aa9a13ce61b2cadd62a222b28", "CanGrow": true, "ClientRectangle": "0.07,0.05,8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " {data_internalUser_nodes.name}" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text15", "Guid": "4a344cd9f364e6971b1f6fbe0e89063a", "CanGrow": true, "ClientRectangle": "11.7,0.05,4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{data_internalUser_nodes.RelationGroup.groupPerson}" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text24", "Guid": "49364ed3083f13693d77130131d036fc", "CanGrow": true, "ClientRectangle": "16,0.05,4,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{data_internalUser_nodes.RelationArea.name}" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text11", "Guid": "8e623d24df99c4f9639dd64cccaffa06", "CanGrow": true, "ClientRectangle": "8.37,0.05,3,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{data_internalUser_nodes.RelationIdentifier.mask}" }, "HorAlignment": "Right", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text3", "Guid": "55f1fd3fbc4c4a8d6ccc77aaa4bdd297", "CanGrow": true, "ClientRectangle": "20.27,0.05,7.43,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{JoinColumnContent(data_internalUser_nodes_permanentAccessLevels_accessLevel,\"name\",\",\")}" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" } }, "PrintIfDetailEmpty": true, "DataSourceName": "data_internalUser_nodes" } }, "PaperSize": "A4", "Orientation": "Landscape", "PageWidth": 29.7, "PageHeight": 21.0, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1.0, "Right": 1.0, "Top": 1.0, "Bottom": 1.0 } } } }