{ "ReportGuid": "c62cbd1b006921cd1799ef8ba22f12c9", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "R1PI-1022 (Exemplo 2).mrt", "ReportCreated": "/Date(1618180532000-0300)/", "ReportChanged": "/Date(1685547052000-0300)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "PreviewSettings": 268435455, "Dictionary": { "Resources": { "0": { "Name": "R1PI-1022(2)", "Alias": "R1PI-1022(2)", "Type": "Json", "Image": "hwMCsR8pCfMNvErEEEFx/37KzeKWm+nGKpHOCCy84oB6LkK9pZ/LsAQ7Z1T3OtIgQ06Bc6b+PfK0bdxmEqqu4xzo9FSsUTwRgswkYe0s8RMpVuay1qx+MwpBlezJWnmhcFCcc3pH4cOFOb77dj3VupdfWCxN0vW4AxzMALkujj5+dpB0XCkwBWKqkb/EXortrc+wMCsa69p6RGtVD5TsuC1+LHjnXDMLnZzQlDtHeTZu5KMUzWN8JNeMENw84m4dah1aeH2Lj7AmeNTJcuA9eFNw9528s7ltySHGr79F0wklHcFszCVJ3pIHuL7V8FQEC116HEUZWKkCMGQh23OQI3wHc72yTx156fKj3EmY7trT3vFID5PIb0jpD+C0XkTgCFdqFyr0EYa3gFhN6ac4zSXKtnDAXfAfBCowRol287ZJjdISZwxoNs9VOpD0ozuaeRxabSXie8ViNvTVePS0W68RmGa1OMJ2e5qqS5hcFC7Jzl2CXFRHMVrIiMc2AHeQ7JYlvWZOezhDz0+mkyzgih2+M6j5xbr5f8+Bo2vIM5mE3NaTH7b0/4M4Dr8QG+N7ZgdEgQD/EeYeWFrQZVdDo+OoHGlpuDVvCzZzbkF5WMSu9keE7S0lDavIX9KIo1agCOY/xbyfVEy8zoig21u5Qx3L9M7iBYKB9w7OmmydCByuHilYt5jnVg7tU7XK83nXSUOwa+6RVFwKlI/zl/ukXbuLPXHdRwk/pQ==" } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "header", "Alias": "header", "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", "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", "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", "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", "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", "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", "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", "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", "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", "ImageBytes": "" }, "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", "ImageBytes": "" } } }, "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": "TOTAL: {Count(data_internalUser_nodes_permanentAccessLevels_accessLevel)}" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" } }, "PrintIfDetailEmpty": true, "DataSourceName": "data_internalUser_nodes" }, "5": { "Ident": "StiDataBand", "Name": "Datadata_usuarioPessoaInterna_nodes_niveisAcessoPermanente", "ClientRectangle": "0,7.21,27.7,0.45", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Datadata_usuarioPessoaInterna_nodes_niveisAcessoPermanente_RelationNivelAcesso_nome", "CanGrow": true, "ClientRectangle": "20.27,0.05,7.43,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{data_internalUser_nodes_permanentAccessLevels_accessLevel.name}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextQuality": "Wysiwyg", "AllowHtmlTags": true, "Type": "DataColumn" } }, "PrintIfDetailEmpty": true, "DataSourceName": "data_internalUser_nodes_permanentAccessLevels_accessLevel", "MasterComponent": "DataBand1" } }, "PaperSize": "A4", "Orientation": "Landscape", "PageWidth": 29.7, "PageHeight": 21, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }