Skip to main content

Build a Simple Form

  • Updated
 

Build a Simple Form

This article describes how to build a simple form in the Izenda BI.

Steps:

  1. Follow Build a Generic Report until the step to add report parts.
  2. Prepare an empty ReportPartForm object with default properties.
  3. For each selected data source fields, populate a ReportPartElement object with default properties.
  4. Add the ReportPartElement objects into columns.elements in ReportPartForm object.
  5. Update the properties of the map in properties field per user selection (See ReportPartFormProperties).
  6. Back to the steps in Build a Generic Report.

Prepare an empty ReportPartForm object

Empty ReportPartForm object
  • The highlighted properties contains the default properties
  • The highlighted columns.elements contains the selected data source fields
  1
										2
										3
										4
										5
										6
										7
										8
										9
										10
										11
										12
										13
										14
										15
										16
										17
										18
										19
										20
										21
										22
										23
										24
										25
										26
										27
										28
										29
										30
										31
										32
										33
										34
										35
										36
										37
										38
										39
										40
										41
										42
										43
										44
										45
										46
										47
										48
										49
										50
										51
										52
										53
										54
										55
										56
										57
										58
										59
										60
										61
										62
										63
										64
										65
										66
										67
										68
										69
										70
										71
										72
										73
										74
										75
										76
										77
										78
										79
										80
										81
										82
										83
										84
										85
										86
										87
										88
										89
										90
										91
										92
										93
										94
										95
										96
										97
										98
										99
										100
										101
										102
										103
										104
										105
										106
										107
										108
										109
										110
										111
										112
										113
										114
										115
									116
 
{"properties":{"format":{"heading":{"h1":false,"h2":false,"h3":false,"h4":false,"h5":false,"h6":false},"block":{"p":true,"blockquote":false,"div":true,"pre":false},"font":{"bold":false,"italic":false,"underline":false,"strikethrough":false,"superscript":false,"subscript":false,"code":false,"fontFamily":"Roboto","fontSize":14,"textColor":"#000","backgroundColor":"#fff"},"alignment":{"alignleft":false,"aligncenter":false,"alignright":false,"alignjustify":false},"list":{"bullet":"","numbered":""}},"pasteAsText":false,"highlightCode":true,"wrapText":true,"mceDirectionRTL":false,"mceDirectionLTR":false,"mceVisualChars":false,"mceToggleVisualAid":true,"usePagination":true,"pageSize":10,"pageBreakAfterEachEntry":false,"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0}},"reportPartFormRepeater":{},"reportPartFormEmbeddedReport":{},"reportPartFormSmartTag":{},"reportPartFormField":{},"formState":{},"htmlContent":"","dataTree":null,"type":1,"columns":{"text":null,"properties":{},"settings":{},"elements":[],"name":"columns"},"selectedFieldElement":{},"activeTabKey":"","isSelectedCell":false,"isActiveForEdit":false,"title":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":true,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]},"description":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":false,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]}}

Populate selected data sources fields

  1. Refer to the similar step in Building a Grid guide to:

    1. Get the list of available data sources fields from POST report/availableQuerySourceFields
    2. Build a corresponding ReportPartElement object for each selected data source field
    3. Populate a default ReportPartElementProperties for properties field in each ReportPartElement object

    See Sample Properties for a ReportPartElement for some samples.

  2. Add the ReportPartElement objects into columns.elements in ReportPartForm object.

  3. Build the HTML to display selected data source fields in htmlContent.

    Note

    The double quotes must be escaped before adding to json, e.g. “htmlContent”: “<div><field class="field-wrapper" …”

    <div><custom-HTML-tags...><fieldclass="field-wrapper"field-name="[connection].[schema].[table].[field 1]"><field-propkey="subTotalFieldDataType"value="Izenda data type for sub total calculation"></field-prop><field-propkey="grandTotalFieldDataType"value="Izenda data type for grand total calculation"></field-prop><field-propkey="fieldId"value="id of field 1"></field-prop><field-propkey="dataFieldType"value="Izenda data type"></field-prop><field-propkey="querySourceId"value="id of parent query source of field 1"></field-prop>
								Display text in Report Designer for field 1
								</field></custom-HTML-tags...></div>

    The whole <field>..</field> tag will be replaced by the value of selected data source field in Report Viewer.

Sample full ReportPartForm object
  • htmlContent displays this line: Order #[OrderID] for Customer# [CustomerID] by Employee# [EmployeeID]
  • The double quotes in htmlContent have been escaped
{"properties":{"format":{"heading":{"h1":false,"h2":false,"h3":false,"h4":false,"h5":false,"h6":false},"block":{"p":true,"blockquote":false,"div":true,"pre":false},"font":{"bold":false,"italic":false,"underline":false,"strikethrough":false,"superscript":false,"subscript":false,"code":false,"fontFamily":"Roboto","fontSize":14,"textColor":"#000","backgroundColor":"#fff"},"alignment":{"alignleft":false,"aligncenter":false,"alignright":false,"alignjustify":false},"list":{"bullet":"","numbered":""}},"pasteAsText":false,"highlightCode":true,"wrapText":true,"mceDirectionRTL":false,"mceDirectionLTR":false,"mceVisualChars":false,"mceToggleVisualAid":true,"usePagination":true,"pageSize":10,"pageBreakAfterEachEntry":false,"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0}},"reportPartFormRepeater":{},"reportPartFormEmbeddedReport":{},"reportPartFormSmartTag":{},"reportPartFormField":{},"formState":{},"htmlContent":"<div>Order #<field class=\"field-wrapper\" field-name=\"[Northwind].[dbo].[Orders].[OrderID]\"><field-prop key=\"subTotalFieldDataType\" value=\"Numeric\"></field-prop><field-prop key=\"grandTotalFieldDataType\" value=\"Numeric\"></field-prop><field-prop key=\"fieldId\" value=\"07ed1f4c-f30d-4759-bfc5-0e4636d446cd\"></field-prop><field-prop key=\"dataFieldType\" value=\"Numeric\"></field-prop><field-prop key=\"querySourceId\" value=\"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c\"></field-prop>OrderID<span class=\"icon-cancel\"></span></field> for Customer# <field class=\"field-wrapper\" field-name=\"[Northwind].[dbo].[Orders].[CustomerID]\"><field-prop key=\"fieldId\" value=\"ab4e3871-76ba-4604-8a8d-97fbfbca7144\"></field-prop><field-prop key=\"querySourceId\" value=\"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c\"></field-prop><field-prop key=\"dataFieldType\" value=\"Text\"></field-prop>CustomerID<span class=\"icon-cancel\"></span></field> by Employee#&nbsp;<field class=\"field-wrapper\" field-name=\"[Northwind].[dbo].[Orders].[EmployeeID]\"><field-prop key=\"fieldId\" value=\"2bc3a102-6621-4713-a167-3579b664dd3e\"></field-prop><field-prop key=\"querySourceId\" value=\"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c\"></field-prop><field-prop key=\"dataFieldType\" value=\"Numeric\"></field-prop>EmployeeID<span class=\"icon-cancel\"></span></field></div>","dataTree":null,"type":1,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"name":"OrderID","properties":{"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"ASC","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{"hasRepeaterPart":false}},"position":1,"field":{"fieldId":"07ed1f4c-f30d-4759-bfc5-0e4636d446cd","fieldName":"OrderID","fieldNameAlias":"OrderID","dataFieldType":"Numeric","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false},{"name":"CustomerID","properties":{"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"ASC","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{"hasRepeaterPart":false}},"position":2,"field":{"fieldId":"ab4e3871-76ba-4604-8a8d-97fbfbca7144","fieldName":"CustomerID","fieldNameAlias":"CustomerID","dataFieldType":"Text","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false},{"name":"EmployeeID","properties":{"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"ASC","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{"hasRepeaterPart":false}},"position":3,"field":{"fieldId":"2bc3a102-6621-4713-a167-3579b664dd3e","fieldName":"EmployeeID","fieldNameAlias":"EmployeeID","dataFieldType":"Numeric","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false}],"name":"columns"},"selectedFieldElement":{},"activeTabKey":"","isSelectedCell":false,"isActiveForEdit":false,"title":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":true,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]},"description":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":false,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]}}

Update the properties of each field per user selection

Please see ReportPartElementProperties for the purpose of each field.

See Sample Properties for a ReportPartElement for more samples.

Update the properties of the Form in “properties” field per user selection

Please see ReportPartFormProperties for the purpose of each field.

Back to the Save step in Build a Generic Report

Sample full ReportSavingParameter object for Save report API
{"reportKey":{"key":"e22406a0-4f6d-4077-bac2-3877b7233986","tenantId":null},"section":2,"saveAs":false,"ignoreCheckChange":false,"report":{"inaccessible":false,"category":{"name":"","type":1,"parentId":null,"tenantId":null,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":null,"dashboards":null,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"John Doe","modified":null,"modifiedBy":null},"subCategory":{"name":"","type":1,"parentId":null,"tenantId":null,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":null,"dashboards":null,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"John Doe","modified":null,"modifiedBy":null},"reportRelationship":[],"reportPart":[{"reportPartContent":{"properties":{"format":{"heading":{"h1":false,"h2":false,"h3":false,"h4":false,"h5":false,"h6":false},"block":{"p":true,"blockquote":false,"div":true,"pre":false},"font":{"bold":false,"italic":false,"underline":false,"strikethrough":false,"superscript":false,"subscript":false,"code":false,"fontFamily":"Roboto","fontSize":14,"textColor":"#000","backgroundColor":"#fff"},"alignment":{"alignleft":false,"aligncenter":false,"alignright":false,"alignjustify":false},"list":{"bullet":"","numbered":""}},"pasteAsText":false,"highlightCode":true,"wrapText":true,"mceDirectionRTL":false,"mceDirectionLTR":false,"mceVisualChars":false,"mceToggleVisualAid":true,"usePagination":true,"pageSize":10,"pageBreakAfterEachEntry":false,"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0}},"reportPartFormRepeater":{},"reportPartFormEmbeddedReport":{},"reportPartFormSmartTag":{},"reportPartFormField":{},"formState":{},"htmlContent":"<div>Order #<field class=\"field-wrapper\" field-name=\"[Northwind].[dbo].[Orders].[OrderID]\"><field-prop key=\"subTotalFieldDataType\" value=\"Numeric\"></field-prop><field-prop key=\"grandTotalFieldDataType\" value=\"Numeric\"></field-prop><field-prop key=\"fieldId\" value=\"07ed1f4c-f30d-4759-bfc5-0e4636d446cd\"></field-prop><field-prop key=\"dataFieldType\" value=\"Numeric\"></field-prop><field-prop key=\"querySourceId\" value=\"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c\"></field-prop>OrderID<span class=\"icon-cancel\"></span></field> for Customer# <field class=\"field-wrapper\" field-name=\"[Northwind].[dbo].[Orders].[CustomerID]\"><field-prop key=\"fieldId\" value=\"ab4e3871-76ba-4604-8a8d-97fbfbca7144\"></field-prop><field-prop key=\"querySourceId\" value=\"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c\"></field-prop><field-prop key=\"dataFieldType\" value=\"Text\"></field-prop>CustomerID<span class=\"icon-cancel\"></span></field> by Employee#&nbsp;<field class=\"field-wrapper\" field-name=\"[Northwind].[dbo].[Orders].[EmployeeID]\"><field-prop key=\"fieldId\" value=\"2bc3a102-6621-4713-a167-3579b664dd3e\"></field-prop><field-prop key=\"querySourceId\" value=\"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c\"></field-prop><field-prop key=\"dataFieldType\" value=\"Numeric\"></field-prop>EmployeeID<span class=\"icon-cancel\"></span></field></div>","dataTree":null,"type":1,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"name":"OrderID","properties":{"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"ASC","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{"hasRepeaterPart":false}},"position":1,"field":{"fieldId":"07ed1f4c-f30d-4759-bfc5-0e4636d446cd","fieldName":"OrderID","fieldNameAlias":"OrderID","dataFieldType":"Numeric","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false},{"name":"CustomerID","properties":{"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"ASC","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{"hasRepeaterPart":false}},"position":2,"field":{"fieldId":"ab4e3871-76ba-4604-8a8d-97fbfbca7144","fieldName":"CustomerID","fieldNameAlias":"CustomerID","dataFieldType":"Text","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false},{"name":"EmployeeID","properties":{"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"ASC","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{"hasRepeaterPart":false}},"position":3,"field":{"fieldId":"2bc3a102-6621-4713-a167-3579b664dd3e","fieldName":"EmployeeID","fieldNameAlias":"EmployeeID","dataFieldType":"Numeric","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false}],"name":"columns"},"selectedFieldElement":{},"activeTabKey":"","isSelectedCell":false,"isActiveForEdit":false,"title":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":true,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]},"description":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":false,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]}},"width":12,"height":4,"positionY":0,"positionX":0,"title":"Form"}],"reportFilter":{"filterFields":[],"logic":"","visible":false,"reportId":"e22406a0-4f6d-4077-bac2-3877b7233986","id":"3920d594-f813-4b90-995a-42dbe9e4858a","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"John Doe","modified":null,"modifiedBy":null},"calculatedFields":[],"accesses":[],"schedules":[],"dynamicQuerySourceFields":[],"name":"Example Form 2","reportDataSource":[{"reportId":"e22406a0-4f6d-4077-bac2-3877b7233986","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceCategoryId":null,"connectionId":null,"selected":true,"id":"3f8129f1-7ebb-43f8-b7f7-100d1e58cf8e","state":1,"deleted":false,"inserted":false,"version":null,"created":null,"createdBy":"John Doe","modified":null,"modifiedBy":null}],"type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":null,"categoryName":null,"subCategoryId":null,"subCategoryName":null,"tenantId":null,"tenantName":null,"description":"","title":"","lastViewed":null,"owner":"John Doe","ownerId":"d928e941-19ef-4382-ba60-7238cb555631","excludedRelationships":null,"numberOfView":0,"renderingTime":0,"createdById":"d928e941-19ef-4382-ba60-7238cb555631","modifiedById":"d928e941-19ef-4382-ba60-7238cb555631","snapToGrid":false,"usingFields":null,"hasDeletedObjects":false,"header":{"visible":false,"items":[{"isDirty":false,"type":"image","label":"Image","id":"formatDetails_209","positionX":0,"positionY":0,"width":6,"height":6,"name":"Logo Image","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","imageUrl":"http://","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_210","positionX":20,"positionY":0,"width":12,"height":2,"name":"Report Name","value":"{reportName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"thinHorizontalRule","label":"Horizontal Rule","id":"formatDetails_211","positionX":20,"positionY":4,"width":12,"height":1,"name":"Upper Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":2},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_212","positionX":20,"positionY":5,"width":6,"height":2,"name":"Report Generated","value":"Report Generated:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_213","positionX":20,"positionY":7,"width":6,"height":2,"name":"User","value":"User:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_214","positionX":20,"positionY":9,"width":6,"height":2,"name":"Tenant","value":"Tenant:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"dateTime","label":"Date Time","id":"formatDetails_215","positionX":26,"positionY":5,"width":6,"height":2,"name":"Current Date Time","value":"{currentDateTime}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_216","positionX":26,"positionY":7,"width":6,"height":2,"name":"Current User Name","value":"{currentUserName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_217","positionX":26,"positionY":9,"width":6,"height":2,"name":"Tenant Name","value":"{tenantName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_218","positionX":0,"positionY":11,"width":32,"height":1,"name":"Lower Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4}]},"footer":{"visible":false,"items":[{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_219","positionX":0,"positionY":0,"width":32,"height":1,"name":"Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_220","positionX":0,"positionY":1,"width":10,"height":2,"name":"Footer Text","value":"Footer Text","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_221","positionX":20,"positionY":1,"width":4,"height":2,"name":"Page","value":"Page","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"pageNumber","label":"Page Number","id":"formatDetails_222","positionX":24,"positionY":1,"width":8,"height":2,"name":"Page Number","value":"{pageNumber}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1}]},"titleDescription":{"visible":false,"items":[{"isDirty":false,"type":"title","label":"Title","id":"formatDetails_223","name":"Title","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"description","label":"Description","id":"formatDetails_224","name":"Description","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1}]},"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":{"orientation":0,"margins":0,"centerOnPage":{"horizontally":false,"vertically":false},"pageBreakAfterReportPart":false,"marginSettings":[{"type":3,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":0,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":1,"topValue":0.75,"bottomValue":0.75,"leftValue":0.25,"rightValue":0.25,"headerValue":0.3,"footerValue":0.3},{"type":2,"topValue":1,"bottomValue":1,"leftValue":1,"rightValue":1,"headerValue":0.5,"footerValue":0.5}]},"deletable":false,"editable":false,"movable":false,"copyable":false,"accessPriority":0,"active":false,"id":"e22406a0-4f6d-4077-bac2-3877b7233986","state":1,"deleted":false,"inserted":false,"version":0,"created":null,"createdBy":"John Doe","modified":null,"modifiedBy":"John Doe"}}