ReportPartDefinition¶
Field | NULL | Description | Note |
---|---|---|---|
reportPartContent object |
A ReportPartContent object |
Inherited fields:
ReportPart¶
Field | NULL | Description | Note |
---|---|---|---|
title string |
The title of the report part | ||
positionX int |
The position of the report part on X-axis | ||
positionY int |
The position of the report part on Y-axis | ||
width string |
The width of the report part | ||
height int |
The height of the report part | ||
reportId string (GUID) |
The id of the parent report | ||
numberOfRecord integer |
Y | The number of records to preview | |
content string |
The content of the report part, in json format | ||
sourceId string (GUID) |
Y | The id of the source report part, in case this is a copy |
Inherited fields:
Entity¶
Field | NULL | Description | Note |
---|---|---|---|
id string (GUID) |
The id of this object Example: 572bd576-8c92-4901-ab2a-b16e38144813 |
Allow null incase insert a new entity | |
state integer |
The entity state of this object
|
||
deleted boolean |
Is this object deleted | ||
inserted boolean |
Is this object inserted | ||
version string |
Y | The version | |
created datetime in ISO 8601 format |
Y | The created datetime | |
createdBy string |
The creator | ||
modified datetime in ISO 8601 format |
Y | The modification datetime | |
modifiedBy string |
The user who last modified this object |
Sample:
{
"reportPartContent" : {
"showDataInOneGroupNextTogether" : false,
"columns" : {
"text" : null,
"properties" : {},
"settings" : {},
"elements" : [{
"name" : "ShipCountry",
"properties" : {
"isDirty" : false,
"fieldItemVisible" : true,
"dataFormattings" : {
"function" : "",
"functionInfo" : {},
"format" : {},
"font" : {
"family" : "Roboto",
"size" : 14,
"bold" : false,
"italic" : false,
"underline" : false,
"color" : "",
"backgroundColor" : ""
},
"alignment" : "alignLeft",
"sort" : "",
"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" : "Open link in New Window"
},
"embeddedJavascript" : {
"script" : ""
},
"subTotal" : {
"label" : "",
"function" : "",
"expression" : "",
"dataType" : "",
"previewResult" : ""
},
"grandTotal" : {
"label" : "",
"function" : "",
"expression" : "",
"dataType" : "",
"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" : []
}
},
"otherProps" : {}
},
"settings" : {},
"chartType" : null,
"showTotal" : false,
"position" : 1,
"field" : {
"fieldId" : "d300a6bd-f218-46c8-a262-3b9fa5ee0382",
"originalName" : null,
"fieldName" : "ShipCountry",
"fieldNameAlias" : "ShipCountry",
"dataFieldType" : "Text",
"querySourceId" : "d609ecdc-2afc-43ce-a0a4-0583ed667c8f",
"querySourceType" : "Table",
"sourceAlias" : "Orders",
"relationshipId" : "00000000-0000-0000-0000-000000000000",
"visible" : true,
"filterable" : false,
"reportId" : null,
"fieldFunctionExpression" : "",
"expression" : null,
"grandTotalExpression" : "",
"subTotalExpression" : "",
"sort" : "Unsorted",
"function" : null,
"calculatedTree" : null,
"grandTotalTree" : null,
"isCalculated" : false
}
}
]
},
"rows" : {
"text" : null,
"properties" : {},
"settings" : {},
"elements" : []
},
"values" : {
"text" : null,
"properties" : {},
"settings" : {},
"elements" : []
},
"separators" : {
"text" : null,
"properties" : {},
"settings" : {},
"elements" : [{
"name" : "Group (Freight)",
"properties" : {
"isDirty" : false,
"fieldItemVisible" : true,
"dataFormattings" : {
"function" : "7f942ac7-08d8-41fa-9e89-bad96f07f102",
"functionInfo" : {
"id" : "7f942ac7-08d8-41fa-9e89-bad96f07f102",
"name" : "Group",
"expression" : null,
"dataType" : "Money",
"formatDataType" : "Money",
"syntax" : null,
"expressionSyntax" : null,
"isOperator" : false,
"extendedProperties" : {}
},
"format" : {},
"font" : {
"family" : "Roboto",
"size" : 14,
"bold" : false,
"italic" : false,
"underline" : false,
"color" : "",
"backgroundColor" : ""
},
"alignment" : "alignLeft",
"sort" : "",
"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" : "Open link in New Window"
},
"embeddedJavascript" : {
"script" : ""
},
"subTotal" : {
"label" : "",
"function" : "",
"expression" : "",
"dataType" : "",
"previewResult" : ""
},
"grandTotal" : {
"label" : "",
"function" : "",
"expression" : "",
"dataType" : "",
"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" : []
}
},
"otherProps" : {}
},
"settings" : {},
"chartType" : null,
"showTotal" : false,
"position" : 1,
"field" : {
"fieldId" : "fa47d01d-e055-43ad-b1ec-891b1685b9fe",
"originalName" : null,
"fieldName" : "Freight",
"fieldNameAlias" : "Group (Freight)",
"dataFieldType" : "Money",
"querySourceId" : "d609ecdc-2afc-43ce-a0a4-0583ed667c8f",
"querySourceType" : "Table",
"sourceAlias" : "Orders",
"relationshipId" : "00000000-0000-0000-0000-000000000000",
"visible" : true,
"filterable" : false,
"reportId" : null,
"fieldFunctionExpression" : "",
"expression" : null,
"grandTotalExpression" : "",
"subTotalExpression" : "",
"sort" : "Unsorted",
"function" : "Group",
"calculatedTree" : null,
"grandTotalTree" : null,
"isCalculated" : false
}
}
]
},
"type" : 3,
"properties" : {
"isDirty" : false,
"generalInfo" : {
"gridStyle" : "Vertical",
"separatorStyle" : "Comma"
},
"table" : {
"border" : {
"top" : {},
"right" : {},
"bottom" : {},
"midVer" : {},
"left" : {},
"midHor" : {}
},
"backgroundColor" : "#efefef"
},
"columns" : {
"width" : {
"value" : null,
"unit" : "Pixels"
},
"alterBackgroundColor" : false
},
"rows" : {
"height" : 40,
"alterBackgroundColor" : false
},
"headers" : {
"font" : {
"family" : "Roboto",
"size" : 14,
"bold" : true,
"italic" : false,
"underline" : false,
"backgroundColor" : "#dbf2ff"
},
"alignment" : "left",
"wordWrap" : false,
"removeHeaderForExport" : false
},
"grouping" : {
"useSeparator" : true
},
"view" : {
"dataRefreshInterval" : {
"enable" : false,
"updateInterval" : 0,
"isAll" : true,
"latestRecord" : 0
},
"usePagination" : false
},
"printing" : {
"usePageBreakAfterSeparator" : false
}
},
"settings" : {},
"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" : []
},
"expandedLevel" : -1
},
"title" : "Grid",
"positionX" : 0,
"positionY" : 0,
"width" : 12,
"height" : 4,
"reportId" : "055899a3-8886-4099-b360-fabf4656f5ce",
"numberOfRecord" : 0,
"id" : "7391fec3-53a1-411d-b92e-02c007fb4dd6",
"state" : 0,
"inserted" : true,
"version" : 1,
"created" : "2016-08-29T09:17:05.13",
"createdBy" : null,
"modified" : "2016-08-29T09:17:05.13",
"modifiedBy" : null
}