{"id":24916,"date":"2020-09-28T14:08:47","date_gmt":"2020-09-28T14:08:47","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=24916"},"modified":"2020-10-05T10:41:35","modified_gmt":"2020-10-05T10:41:35","slug":"how-to-add-dynamics365-report-in-notes-of-the-current-entity-record-in-resco-mobile-app","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/09\/how-to-add-dynamics365-report-in-notes-of-the-current-entity-record-in-resco-mobile-app\/","title":{"rendered":"How to add Dynamics365 Report in Notes of the Current Entity Record in Resco Mobile App"},"content":{"rendered":"

Introduction<\/h2>\n

Recently we had a business requirement where we needed to add Dynamics365 Report as a Note <\/strong>of the current entity record in Resco Mobile App. So to achieve this, we followed the below steps:<\/p>\n

1. We added a custom button (i.e.Command) on the Entity Form of the Invoice<\/strong><\/p>\n

\"add<\/a><\/p>\n

\"add<\/a><\/p>\n

\"add<\/a><\/p>\n

2. Then we added an \u201cHTML\u201d file (with \u201cJavaScript\u201d code) \u00a0in the \u201cIframe\u201d of Entity Form of Invoice<\/strong> entity in order to bind \u201cClick Event\u201d with the \u201cAdd Report to Note\u201d button.<\/p>\n

\"add<\/a><\/p>\n

\"add<\/a><\/p>\n

3. Then we added the function \u201cdownloadReport\u201d (i.e. for downloading dynamics365 report) in our script as show below,<\/p>\n

\/\/Funtion for downloading reports<\/p>\n

downloadReport = function (fileName, format, reportId, regarding, success, failed, scope) {<\/p>\n

\/\/\/ <summary>Downloads the MS Dynamics report into a file.<\/summary><\/p>\n

\/\/\/ <param name=”fileName” type=”String”>A file name for resulting file. Leave &quot;null&quot; to let app to safely generate the file name and extension.<\/param><\/p>\n

\/\/\/ <param name=”format” type=”String”>One of following formats (must be supported in Dynamics): XML, CSV, PDF, MHTML, EXCELOPENXML, WORDOPENXML, IMAGE.<\/param><\/p>\n

\/\/\/ <param name=”success” type=”function(location)”>A callback function that is called with the full path to downloaded file.<\/param><\/p>\n

\/\/\/ <param name=”failed” type=”function(errorMsg)”>A callback which is called in case of error.<\/param><\/p>\n

\/\/\/ <param name=”scope” type=”Object”>The scope for callbacks.<\/param><\/p>\n

try {<\/p>\n

var params = JSON.stringify({<\/p>\n

format: format || “PDF”,<\/p>\n

outputFileName: fileName,<\/p>\n

outputFolder: this.outputFolder,<\/p>\n

outputFilePath: this.outputFilePath, \/\/ for internal use only<\/p>\n

reportId: reportId,<\/p>\n

regardingEntity: regarding ? regarding.entityName : null,<\/p>\n

regardingId: regarding ? regarding.id : null<\/p>\n

});<\/p>\n

\/\/command for downloading report<\/p>\n

MobileCRM.bridge.command(“downloadReport”, params, success, failed, scope);<\/p>\n

} catch (e) {<\/p>\n

MobileCRM.bridge.alert(“An Error Has occurred ” + e);<\/p>\n

}<\/p>\n

};<\/p><\/blockquote>\n

4. And then used this function in the \u201cUI.EntityForm.onCommand\u201d event, as shown below,<\/p>\n

MobileCRM.UI.EntityForm.onCommand(“custom_AddReportinNotes”,<\/p>\n

function (EntityForm) {<\/p>\n

_entInvoice = EntityForm;<\/p>\n

var reportId = “32C85C59-7D04-E711-80E6-00155DB8652A”; \/\/GUID of Dyamics365 Report<\/p>\n

try {<\/p>\n

if (isValid(EntityForm) && isValid(EntityForm.entity)) {<\/p>\n

\/\/Reference Object of Entity Record<\/p>\n

_refInvoice = new MobileCRM.Reference(EntityForm.entity.entityName, EntityForm.entity.id, EntityForm.entity.primaryName);<\/p>\n

\/\/Downloaing report<\/p>\n

downloadReport(“”, “pdf”, reportId, _refInvoice,<\/p>\n

function (result) {<\/p>\n

MobileCRM.bridge.alert(“Report Downloaded Successfully!”);<\/p>\n

_resultingReport = result;<\/p>\n

if (isValid(_resultingReport)) {<\/p>\n

\/\/Path of downladed report file<\/p>\n

var filePath = _resultingReport;<\/p>\n

\/\/Create a Parent Relationship object (i.e. on which you want to add Note)<\/p>\n

var objRelationship = new MobileCRM.Relationship(“objectid”, _refInvoice);<\/p>\n

\/\/Add Downloaded Report as Note on the Current Entity Record<\/p>\n

MobileCRM.DynamicEntity.saveDocumentBody(null, null, objRelationship, filePath, null, function (result) {<\/p>\n

if (isValid(result)) {<\/p>\n

MobileCRM.bridge.alert(result.entityName + ” ‘” + result.primaryName + “‘ successfully saved.”);<\/p>\n

}<\/p>\n

}, MobileCRM.bridge.alert, null);<\/p>\n

}<\/p>\n

},<\/p>\n

function (error) {<\/p>\n

_resultingReport = null;<\/p>\n

MobileCRM.bridge.alert(error.message);<\/p>\n

});<\/p>\n

}<\/p>\n

} catch (e) {<\/p>\n

MobileCRM.bridge.alert(“An Error Has occurred ” + e);<\/p>\n

}<\/p>\n

});<\/p><\/blockquote>\n

5. We then published the Resco Mobile Project and synced the Resco Mobile App with the same and then navigated to the Invoice<\/strong> record and clicked on the \u201cAdd Report in Notes\u201d button (i.e. Custom Command).
\n\"add<\/a><\/p>\n

6. Once the button is clicked, it took a few seconds to download the \u201cInvoice Report\u201d and then added it to the Notes <\/strong>of the current Invoice <\/strong>record.<\/p>\n

\"add<\/a><\/p>\n

\"add<\/a><\/p>\n

7. Finally, after synchronization of the Note<\/strong> record of the \u201cInvoice Report\u201d, it is added on that Invoice <\/strong>record in Dynamics365.<\/p>\n

\"add<\/a><\/p>\n

Notes: <\/em><\/strong><\/p>\n

1. We made sure that the Dynamics365 Reports are enabled for Resco Mobile App in the organization.<\/em><\/strong><\/p>\n

2. We also made sure the \u201cNotes\u201d (i.e.Annotation) entity was enabled in Resco Mobile Project and is available on the Entity (i.e. entity for which we are going to use this functionality)<\/em><\/strong><\/p>\n

Conclusion<\/h2>\n

Technicians can use the \u201cAdd Report as Note\u201d functionality in order to attach Dynamics365 Reports (such as Invoice report) in Notes of the Entity record in Resco Mobile App.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Recently we had a business requirement where we needed to add Dynamics365 Report as a Note of the current entity record in Resco Mobile App. So to achieve this, we followed the below steps: 1. We added a custom button (i.e.Command) on the Entity Form of the Invoice 2. Then we added an \u201cHTML\u201d\u2026 Read More: How to add Dynamics365 Report in Notes of the Current\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,18,19,48],"tags":[2078,1440,1441,1445,1446,1449],"class_list":["post-24916","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-resco-mobile-crm","tag-resco","tag-resco-app","tag-resco-crm","tag-resco-mobile-app","tag-resco-mobile-app-dynamics-365-crm","tag-resco-mobile-dynamics-crm"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t