{ "ReportVersion": "2017.1.11.0", "ReportGuid": "a0f1efe06d95480cb51828431c03471a", "ReportName": "Report", "ReportAlias": "Report", "ReportCreated": "/Date(1501924078000+0200)/", "ReportChanged": "/Date(1510053026028+0100)/", "EngineVersion": "EngineV1", "CalculationMode": "Interpretation", "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", "Styles": { "0": { "Ident": "StiStyle", "Name": "data1", "Font": ";9;;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "TextBrush": "solid:0,0,0" }, "1": { "Ident": "StiStyle", "Name": "data2", "Font": ";9;;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:191,191,191", "TextBrush": "solid:0,0,0" } }, "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": { "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "pagingParameters", "Alias": "pagingParameters", "Columns": { "0": { "Name": "pageNumber", "Index": -1, "NameInSource": "pageNumber", "Alias": "pageNumber", "Type": "System.Double" }, "1": { "Name": "pageSize", "Index": -1, "NameInSource": "pageSize", "Alias": "pageSize", "Type": "System.Double" }, "2": { "Name": "totalCount", "Index": -1, "NameInSource": "totalCount", "Alias": "totalCount", "Type": "System.Double" }, "3": { "Name": "self", "Index": -1, "NameInSource": "self", "Alias": "self", "Type": "System.String" }, "4": { "Name": "first", "Index": -1, "NameInSource": "first", "Alias": "first", "Type": "System.String" }, "5": { "Name": "last", "Index": -1, "NameInSource": "last", "Alias": "last", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.pagingParameters" }, "1": { "Ident": "StiDataTableSource", "Name": "results", "Alias": "results", "Columns": { "0": { "Name": "_id", "Index": -1, "NameInSource": "_id", "Alias": "_id", "Type": "System.Guid" }, "1": { "Name": "_version", "Index": -1, "NameInSource": "_version", "Alias": "_version", "Type": "System.Double" }, "2": { "Name": "individualDetails", "Index": -1, "NameInSource": "individualDetails", "Alias": "individualDetails", "Type": "System.String" }, "3": { "Name": "communicationDetails", "Index": -1, "NameInSource": "communicationDetails", "Alias": "communicationDetails", "Type": "System.String" }, "4": { "Name": "addressDetails", "Index": -1, "NameInSource": "addressDetails", "Alias": "addressDetails", "Type": "System.String" }, "5": { "Name": "links", "Index": -1, "NameInSource": "links", "Alias": "links", "Type": "System.Double" }, "6": { "Name": "preferences", "Index": -1, "NameInSource": "preferences", "Alias": "preferences", "Type": "System.Double" }, "7": { "Name": "guestIds", "Index": -1, "NameInSource": "guestIds", "Alias": "guestIds", "Type": "System.Double" } }, "NameInSource": "GTM-Profiles.results" }, "2": { "Ident": "StiDataTableSource", "Name": "results_addressDetails", "Alias": "results_addressDetails", "Columns": { "0": { "Name": "addressLine1", "Index": -1, "NameInSource": "addressLine1", "Alias": "addressLine1", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "addressLine2", "Index": -1, "NameInSource": "addressLine2", "Alias": "addressLine2", "Type": "System.String" }, "3": { "Name": "city", "Index": -1, "NameInSource": "city", "Alias": "city", "Type": "System.String" }, "4": { "Name": "postalCode", "Index": -1, "NameInSource": "postalCode", "Alias": "postalCode", "Type": "System.String" }, "5": { "Name": "state", "Index": -1, "NameInSource": "state", "Alias": "state", "Type": "System.String" }, "6": { "Name": "country", "Index": -1, "NameInSource": "country", "Alias": "country", "Type": "System.String" }, "7": { "Name": "addressType", "Index": -1, "NameInSource": "addressType", "Alias": "addressType", "Type": "System.String" }, "8": { "Name": "is-primary", "Index": -1, "NameInSource": "is-primary", "Alias": "is-primary", "Type": "System.Boolean" }, "9": { "Name": "language", "Index": -1, "NameInSource": "language", "Alias": "language", "Type": "System.Double" } }, "NameInSource": "GTM-Profiles.results_addressDetails" }, "3": { "Ident": "StiDataTableSource", "Name": "results_addressDetails_addressType", "Alias": "results_addressDetails_addressType", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_addressDetails_addressType" }, "4": { "Ident": "StiDataTableSource", "Name": "results_addressDetails_country", "Alias": "results_addressDetails_country", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_addressDetails_country" }, "5": { "Ident": "StiDataTableSource", "Name": "results_addressDetails_language", "Alias": "results_addressDetails_language", "NameInSource": "GTM-Profiles.results_addressDetails_language" }, "6": { "Ident": "StiDataTableSource", "Name": "results_addressDetails_state", "Alias": "results_addressDetails_state", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_addressDetails_state" }, "7": { "Ident": "StiDataTableSource", "Name": "results_communicationDetails", "Alias": "results_communicationDetails", "Columns": { "0": { "Name": "type", "Index": -1, "NameInSource": "type", "Alias": "type", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "mode", "Index": -1, "NameInSource": "mode", "Alias": "mode", "Type": "System.String" }, "3": { "Name": "details", "Index": -1, "NameInSource": "details", "Alias": "details", "Type": "System.String" }, "4": { "Name": "primary", "Index": -1, "NameInSource": "primary", "Alias": "primary", "Type": "System.Boolean" } }, "NameInSource": "GTM-Profiles.results_communicationDetails" }, "8": { "Ident": "StiDataTableSource", "Name": "results_communicationDetails_mode", "Alias": "results_communicationDetails_mode", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_communicationDetails_mode" }, "9": { "Ident": "StiDataTableSource", "Name": "results_individualDetails", "Alias": "results_individualDetails", "Columns": { "0": { "Name": "title", "Index": -1, "NameInSource": "title", "Alias": "title", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "firstName", "Index": -1, "NameInSource": "firstName", "Alias": "firstName", "Type": "System.String" }, "3": { "Name": "lastName", "Index": -1, "NameInSource": "lastName", "Alias": "lastName", "Type": "System.String" }, "4": { "Name": "greeting", "Index": -1, "NameInSource": "greeting", "Alias": "greeting", "Type": "System.String" }, "5": { "Name": "vip", "Index": -1, "NameInSource": "vip", "Alias": "vip", "Type": "System.String" }, "6": { "Name": "gender", "Index": -1, "NameInSource": "gender", "Alias": "gender", "Type": "System.String" }, "7": { "Name": "birthday", "Index": -1, "NameInSource": "birthday", "Alias": "birthday", "Type": "System.String" }, "8": { "Name": "preferredLanguageProfileDetail", "Index": -1, "NameInSource": "preferredLanguageProfileDetail", "Alias": "preferredLanguageProfileDetail", "Type": "System.String" }, "9": { "Name": "anniversaries", "Index": -1, "NameInSource": "anniversaries", "Alias": "anniversaries", "Type": "System.String" }, "10": { "Name": "company", "Index": -1, "NameInSource": "company", "Alias": "company", "Type": "System.String" }, "11": { "Name": "position", "Index": -1, "NameInSource": "position", "Alias": "position", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails" }, "10": { "Ident": "StiDataTableSource", "Name": "results_communicationDetails_type", "Alias": "results_communicationDetails_type", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_communicationDetails_type" }, "11": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_anniversaries", "Alias": "results_individualDetails_anniversaries", "Columns": { "0": { "Name": "date", "Index": -1, "NameInSource": "date", "Alias": "date", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails_anniversaries" }, "12": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_anniversaries_date", "Alias": "results_individualDetails_anniversaries_date", "Columns": { "0": { "Name": "day", "Index": -1, "NameInSource": "day", "Alias": "day", "Type": "System.Double" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "month", "Index": -1, "NameInSource": "month", "Alias": "month", "Type": "System.Double" }, "3": { "Name": "year", "Index": -1, "NameInSource": "year", "Alias": "year", "Type": "System.Double" } }, "NameInSource": "GTM-Profiles.results_individualDetails_anniversaries_date" }, "13": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_birthday", "Alias": "results_individualDetails_birthday", "Columns": { "0": { "Name": "day", "Index": -1, "NameInSource": "day", "Alias": "day", "Type": "System.Double" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "month", "Index": -1, "NameInSource": "month", "Alias": "month", "Type": "System.Double" }, "3": { "Name": "year", "Index": -1, "NameInSource": "year", "Alias": "year", "Type": "System.Double" } }, "NameInSource": "GTM-Profiles.results_individualDetails_birthday" }, "14": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_gender", "Alias": "results_individualDetails_gender", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails_gender" }, "15": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_preferredLanguageProfileDetail", "Alias": "results_individualDetails_preferredLanguageProfileDetail", "Columns": { "0": { "Name": "languageCode", "Index": -1, "NameInSource": "languageCode", "Alias": "languageCode", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "localizedIndividualProfileDetails", "Index": -1, "NameInSource": "localizedIndividualProfileDetails", "Alias": "localizedIndividualProfileDetails", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails_preferredLanguageProfileDetail" }, "16": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_preferredLanguageProfileDetail_localizedIndividualProfileDetails", "Alias": "results_individualDetails_preferredLanguageProfileDetail_localizedIndividualProfileDetails", "Columns": { "0": { "Name": "title", "Index": -1, "NameInSource": "title", "Alias": "title", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "firstName", "Index": -1, "NameInSource": "firstName", "Alias": "firstName", "Type": "System.String" }, "3": { "Name": "lastName", "Index": -1, "NameInSource": "lastName", "Alias": "lastName", "Type": "System.String" }, "4": { "Name": "greetings", "Index": -1, "NameInSource": "greetings", "Alias": "greetings", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails_preferredLanguageProfileDetail_localizedIndividualProfileDetails" }, "17": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_title", "Alias": "results_individualDetails_title", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails_title" }, "18": { "Ident": "StiDataTableSource", "Name": "results_individualDetails_vip", "Alias": "results_individualDetails_vip", "Columns": { "0": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails_vip" }, "19": { "Ident": "StiDataTableSource", "Name": "results2", "Alias": "results2", "Columns": { "0": { "Name": "_id", "Index": -1, "NameInSource": "_id", "Alias": "_id", "Type": "System.Guid" }, "1": { "Name": "_version", "Index": -1, "NameInSource": "_version", "Alias": "_version", "Type": "System.Double" }, "2": { "Name": "individualDetails", "Index": -1, "NameInSource": "individualDetails", "Alias": "individualDetails", "Type": "System.String" }, "3": { "Name": "communicationDetails", "Index": -1, "NameInSource": "communicationDetails", "Alias": "communicationDetails", "Type": "System.String" }, "4": { "Name": "addressDetails", "Index": -1, "NameInSource": "addressDetails", "Alias": "addressDetails", "Type": "System.String" }, "5": { "Name": "links", "Index": -1, "NameInSource": "links", "Alias": "links", "Type": "System.Double" }, "6": { "Name": "preferences", "Index": -1, "NameInSource": "preferences", "Alias": "preferences", "Type": "System.Double" }, "7": { "Name": "guestIds", "Index": -1, "NameInSource": "guestIds", "Alias": "guestIds", "Type": "System.Double" } }, "NameInSource": "GTM-Profiles.results" }, "20": { "Ident": "StiDataTableSource", "Name": "results_individualDetails2", "Alias": "results_individualDetails2", "Columns": { "0": { "Name": "title", "Index": -1, "NameInSource": "title", "Alias": "title", "Type": "System.String" }, "1": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "2": { "Name": "firstName", "Index": -1, "NameInSource": "firstName", "Alias": "firstName", "Type": "System.String" }, "3": { "Name": "lastName", "Index": -1, "NameInSource": "lastName", "Alias": "lastName", "Type": "System.String" }, "4": { "Name": "greeting", "Index": -1, "NameInSource": "greeting", "Alias": "greeting", "Type": "System.String" }, "5": { "Name": "vip", "Index": -1, "NameInSource": "vip", "Alias": "vip", "Type": "System.String" }, "6": { "Name": "gender", "Index": -1, "NameInSource": "gender", "Alias": "gender", "Type": "System.String" }, "7": { "Name": "birthday", "Index": -1, "NameInSource": "birthday", "Alias": "birthday", "Type": "System.String" }, "8": { "Name": "preferredLanguageProfileDetail", "Index": -1, "NameInSource": "preferredLanguageProfileDetail", "Alias": "preferredLanguageProfileDetail", "Type": "System.String" }, "9": { "Name": "anniversaries", "Index": -1, "NameInSource": "anniversaries", "Alias": "anniversaries", "Type": "System.String" }, "10": { "Name": "company", "Index": -1, "NameInSource": "company", "Alias": "company", "Type": "System.String" }, "11": { "Name": "position", "Index": -1, "NameInSource": "position", "Alias": "position", "Type": "System.String" } }, "NameInSource": "GTM-Profiles.results_individualDetails" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "GTM-Profiles", "Alias": "GTM-Profiles", "PathData": "C:\\Users\\Michal-AC\\Downloads\\GTM-Profiles.JSON" } }, "Relations": { "0": { "Name": "Name", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "communicationDetails" }, "NameInSource": "Relation2", "Alias": "Name", "ParentSource": "results", "ChildSource": "results_communicationDetails" }, "1": { "Name": "Name", "ChildColumns": { "0": "individualDetails" }, "ParentColumns": { "0": "relationId" }, "NameInSource": "Relation", "Alias": "Name", "ParentSource": "results_individualDetails", "ChildSource": "results" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "af505643-9305-a1e1-3d20-3049c62f0f7a", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiDataBand", "Name": "Dataresults", "ClientRectangle": "0,0.4,19.01,0.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Dataresults__id", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,6.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{results._id}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "Dataresults_Relation_firstName", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6.4,0,6.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{results.Name.firstName}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "2": { "Ident": "StiText", "Name": "Dataresults_Relation_lastName", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "12.8,0,6.2,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{results.Name.lastName}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } } }, "DataSourceName": "results" } }, "PageWidth": 21.01, "PageHeight": 29.7, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1.0, "Right": 1.0, "Top": 1.0, "Bottom": 1.0 } } } }