Error while uploading report in Microsoft Dynamics CRM Online

(0) Share

Report

Posted on by Community Member

I have created a report using fetch-xml query for Microsoft Dynamics CRM Online. In this field, I have created a custom enity which has "Last Accessed Date Time" field of type "DateTime". This field stores the value in GTM. I am retrieving the value of this field using fetch-xml query. Also, I want to calculate the difference between the current DateTime and the value (in the locale and not in GMT) of this field in "Hours Minutes Seconds" format. I have written an expression for the same in reportas follows.

(IIF(((INT((DateDiff(DateInterval.Second, DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value), DateTimeKind.Utc).ToLocalTime(), DateTime.Now))/60))>60), INT(((((DateDiff(DateInterval.Second, DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value), DateTimeKind.Utc).ToLocalTime(), DateTime.Now)))/60)) / 60), 0))
& "Hours"&
(IIF(((INT((DateDiff(DateInterval.Second, DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value), DateTimeKind.Utc).ToLocalTime(), DateTime.Now))/60))>60), INT((((DateDiff(DateInterval.Second,DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value), DateTimeKind.Utc).ToLocalTime(), DateTime.Now)))/60) Mod 60), INT((DateDiff(DateInterval.Second, DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value), DateTimeKind.Utc).ToLocalTime(), DateTime.Now))/60)))
& "Minutes" &
((DateDiff(DateInterval.Second, DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value),
DateTimeKind.Utc).ToLocalTime(), DateTime.Now)) Mod 60)
& "Seconds"

This works fine in visual studio. But, when tried to upload the same report in CRM Online organization, it gives the following error.

Any idea how to solve this issue?

*This post is locked for comments

All responses (6)

Answers (2)

Suggested answer

PriyaP 15 on at

Like (0)

Report

RE: Error while uploading report in Microsoft Dynamics CRM Online

Hi Purva, if you have solved this please help me in this, I have used date format like,

IIf(DateAdd("d",Fields!durationdays.Value,Fields!startdate.Value).Date > ("31/Dec/2017"),(IIF(IsNothing(Fields!startdate.Value), 0, DateDiff(DateInterval.Day, Fields!startdate.Value, CDate("31/Dec/2017")))),Fields!durationdays.Value)

And I am not getting which part is not supported by online CRM.
Community Member on at

Like (1)

Report
RE: Error while uploading report in Microsoft Dynamics CRM Online

Hi Purva

I had the same issue and in my case it was the version differences.

If the .rdl file which is exported (downloaded) from CRM has a text like that (it's nearly at the end)

Microsoft.Crm.Reporting.RdlHelper, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

and in the .rdl file produced in SSRS has a line like that

Microsoft.Crm.Reporting.RdlHelper, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

Change the version to 6.0.0.0 in SSRS before importing to CRM

If this isn't your case maybe this article is (https://support.microsoft.com/en-us/kb/2600639)
Verified answer

Community Member on at

Like (2)

Report

RE: Error while uploading report in Microsoft Dynamics CRM Online

I have found the following useful link-

- support.microsoft.com/.../en-us

The error occurred because I have used some functions("Int", "DateTime.SpecifyKind(DateTime.Parse(Fields!new_lastaccesseddatetime.Value), DateTimeKind.Utc).ToLocalTime()") in my ssrs report which are not supported by CRM Online., though it works fine in visual studio.
Verified answer

Rajkumar Rajaraman on at

Like (0)

Report

RE: Error while uploading report in Microsoft Dynamics CRM Online

Hi Purva,

Take a look to the following link. It explains deeply.

a33ik.blogspot.in/.../issues-uploading-report-to-crm-online.html

thinketg.com/dynamics-crm-error-uploading-report-solved

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"
Community Member on at

Like (0)

Report

RE: Error while uploading report in Microsoft Dynamics CRM Online

Thanks for yor quick reply Guido.

The following is the log file.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator.Detail:

<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">

<ErrorCode>-2147188072</ErrorCode>

<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />

<Message>An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator.</Message>

<Timestamp>2015-04-21T14:17:28.0223365Z</Timestamp>

<InnerFault i:nil="true" />

<TraceText i:nil="true" />

</OrganizationServiceFault>
Guido Preite 54,077 Moderator on at

Like (0)

Report

RE: Error while uploading report in Microsoft Dynamics CRM Online

did you download the log file? what is written inside?